Oracle Business Intelligence Enterprise Edition 12c – OBIEE 18.104.22.168.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 :
Unlike 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 :
So you have to download and Install JDK first. For me, I have downloaded jdk-8u66-linux-x64.rpm package.
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.
So this opens the Oracle Inventory window: Select default Inventory location :
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.
STOP here and check if you have 12c Database or at-least 11g R2 (22.214.171.124.0) installed where you are trying to create RCU. If not then it will throw you error and Installer will abort.
Also check the Database Character Set otherwise you will get warning to change data-set to AL32UTF8 like below:
For me it was WE8MSWIN1252 in Oracle Db 12c and I have executed below steps to changed it to acceptable CharacterSet.
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:
I have resolved that error using below steps: fortunately for me during Oracle Db 12c installation I have clicked option ‘pdborcl’ as Pluggable database.
- 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:
As mentioned before If you encounter issue with RCU installation just isolate this configuration step from it and trigger RCU script from :
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:
This is visual Analyzer: Some of the Visual Analyzer interfaces: