Oracle Business Intelligence Enterprise Edition 12c – OBIEE 220.127.116.11.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 :
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:
Step 3 – Install below Prerequisite packages
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.
Step 5 – Install OBIEE 12c Software
Execute the binary content as below:
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.
In Below steps if you see error called Domain “bi” already exists then remove the content from below and click Next.
You can experience this issue only if you aborted any previous session of the config steps.
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 ;
Also If your 12c Database configured with multi tenancy Container Database RCU can’t be created and it will give below error:
- Connect as sys user as sysdba
- then execute : ALTER SESSION SET container = pdborcl ;
- select name, open_mode from v$pdbs; — it should return pdborcl
- Alter pluggable database all open;
- Add below in TNSNAMES.ora
(ADDRESS = (PROTOCOL = TCP)(HOST = localhost)(PORT = 1521))
(SERVER = DEDICATED)
(SERVICE_NAME = pdborcl)
If everything works great follow next steps of Configuration:
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.
Assuming the installation and configuration steps completed. Notice there are change of ports in 12c comparing 11g:
Fusion Middleware Control
Step 7 – Testing post Installation / UI
This is Analytics: