OBIEE 12c(OBIEE 12.2.1.0.0) Installation guide on Linux Platform


Oracle Business Intelligence Enterprise Edition 12c – OBIEE 12.2.1.0.0 released on OTN 26th Oct 2015. As soon as I get all the downloadable contents this is my first attempt to install the software.

We know Oracle has made bunch of amendments / enhancements to 12c on top of very successful 11g release. I am going to blog couple of new 12c features pretty soon in terms of UI as well as config changes.

So lets first follow the step by step process to install the software(64 bit) in my Oracle Linux 6.0 OS .

Step 1 – Download and Procure the required files

Download Oracle Business Intelligence 12c from :

http://www.oracle.com/technetwork/middleware/bi-enterprise-edition/downloads/index.html

1Unlike 11g the installation files are little different and need to installed as per mentioned order. As I am using the server version I have downloaded below files :

2So you have to download and Install JDK first. For me, I have downloaded jdk-8u66-linux-x64.rpm package.

3

So it looks like First JDK , then Weblogic and then OBIEE main installer and no separate RCU required to be installed. Also notice the files are little bit different with .jar for Weblogic Infrastructure and .bin for OBIEE installation.

Step 2 – Install JDK

Should be simple install command:

sudo yum localinstall jdk-8u66-linux-x64.rpm

Post install verify the version:

4

Step 3 – Install below Prerequisite packages

compat-libcap1-1.10
compat-libstdc++-33-3.2.3-x86_64
libgcc-4.8.2-x86_64
libstdc++-4.8.2-x86_64
libstdc++-devel-4.8.2-x86_64
sysstat-10.1.5
gcc-4.8.2
gcc-c++-4.8.2
make-3.82
glibc-2.17-x86_64
glibc-devel-2.17-x86_64
libaio-0.3.109-x86_64

Should be simple sudo yum install command

Step 4 – Install Weblogic (Fusion Middleware) Infrastructure

My Linux server has 48 GB Memory with 140GB storage available to perform the installation. It is the simple java command to Launch the setup.

5So this opens the Oracle Inventory window: Select default Inventory location :

Middleware-Install-01Middleware-Install-02Middleware-Install-03 Middleware-Install-04 Middleware-Install-05 Middleware-Install-06 Middleware-Install-07 Middleware-Install-08 Middleware-Install-09 Middleware-Install-10Middleware-Install-11

Step 5 – Install OBIEE 12c Software

Execute the binary content as below:

OBIEE-1 OBIEE-2 OBIEE-3 OBIEE-4 OBIEE-5 OBIEE-6 OBIEE-7 OBIEE-8OBIEE-9 OBIEE-92

Step 6 – Configure RCU, Middleware, OBIEE

In this step we have to run some config setup file to configure RCU , Middleware domain .

I would prefer to install RCU separately (using ……\Middleware\Oracle_Home\oracle_common\bin\rcu.bat)before you come to this step because RCU creation , DB type validations etc can results several errors which you want to be fixed before Middleware config started.

Config01 Config02 Config03

In Below steps if you see error called Domain “bi” already exists then remove the content from below and click Next.

…\Middleware\Oracle_Home\user_projects\domains

You can experience this issue only if you aborted any previous session of the config steps.

Config04STOP here and check if you have 12c Database or at-least 11g R2 (11.2.0.4.0) installed where you are trying to create RCU. If not then it will throw you error and Installer will abort.

RCU2Also check the Database Character Set otherwise you will get warning to change data-set to AL32UTF8 like below:

issue 1For me it was WE8MSWIN1252 in Oracle Db 12c and I have executed below steps to changed it to acceptable CharacterSet.

SHUTDOWN IMMEDIATE;
STARTUP RESTRICT;
ALTER SYSTEM SET JOB_QUEUE_PROCESSES=0;
ALTER SYSTEM SET AQ_TM_PROCESSES=0;

ALTER DATABASE CHARACTER SET AL32UTF8 ;

— if the above fails:
ALTER DATABASE CHARACTER SET INTERNAL_USE AL32UTF8 ;
SHUTDOWN IMMEDIATE;
STARTUP;

Also If your 12c Database configured with multi tenancy Container Database RCU can’t be created and it will give below error:

issue3I have resolved that error using below steps: fortunately for me during Oracle Db 12c installation I have clicked option ‘pdborcl’ as Pluggable database.

  1. Connect as sys user as sysdba
  2. then execute  : ALTER SESSION SET container = pdborcl ;
  3. select name, open_mode from v$pdbs;   — it should return pdborcl
  4. Alter pluggable database all open;
  5. Add below in TNSNAMES.ora

PDBORCL =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = localhost)(PORT = 1521))
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = pdborcl)
)
)

If everything works great follow next steps of Configuration:

Config05

Config06 Config07 Config08 Config09 Config10As mentioned before If you encounter issue with RCU installation just isolate this configuration step from it and trigger RCU script from :

/u00/app/Middleware/Oracle_Home/oracle_common/bin/

This will prompt a RCU Config steps and you can debug any issue here like SYSDBA privilege, Connect String issue, Port issue, password issue etc etc. Here is sample screen.

RCU1

Assuming the installation and configuration steps completed. Notice there are change of ports in 12c comparing 11g:

WebLogic Console
http://<host&gt;:9500/console
Fusion Middleware Control
http://<host&gt;:9500/em
Visal Analyzer
http://<host&gt;:9502/va
BI Publisher
http://<host>l:9502/xmlpserver
BI Analytics
http://<host&gt;:9502/analytics

Step 7 – Testing post Installation / UI

This is Analytics:

analytics01analytics03This is visual Analyzer:analytics02 Some of the Visual Analyzer interfaces:

analytics04 analytics05 analytics06

2 thoughts on “OBIEE 12c(OBIEE 12.2.1.0.0) Installation guide on Linux Platform

  1. I encountered this issue while running config.sh in OBIEE installation

    And to you can install it need to do the next:

    Edit the Java Security Properties file located in $JAVA_HOME/jre/lib/security/java.security and change the securerandom.source property which points to /dev/random (by default). set it as:

    securerandom.source=file:/dev/urandom
    or
    securerandom.source=file:/dev/./urandom

    Because even though “securerandom.source” property is set to “file:/dev/urandom” in the java.security file, this string is actually an alias for “file:/dev/random” in [Java’s] Unix/Linux native SeedGeneration code. As “/dev/random” is being referred indirectly for generation of random numbers, it may block the services startup process if random numbers are exhausted in Entropy Pool.

    Another option is to run:
    rngd -r /dev/urandom -o /dev/random

    After issuing the entropy_avail number jumped up to over 3000. We could then re-run the OBIEE installation and it worked as quickly and correctly as it should.

    • Good helpful information Israel .
      Actually we play with entropy in OBIEE 11g to make the startup of OBIEE processes faster in current platform.
      And we do this and it works great !

      1. Edit or create /etc/sysconfig/rngd to contain:

      # Add extra options here
      EXTRAOPTIONS=”-r /dev/urandom”
      Then “service rngd start”.
      then “chkconfig rngd on”

Leave a Reply

Please log in using one of these methods to post your comment:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s