Tuesday, November 10, 2015

OBIEE 12c Linux Fresh Installation

OBIEE 12c Linux Fresh installation

Oracle released Oracle Business Intelligence 12c (12.2.1.0.0). New features in 12c include an updated and cleaner look-and-feel, Visual Analyzer that brings Tableau-style reporting to OBIEE users along with another new feature called “data-mashups”,   enables users to upload spreadsheets of their own data to combine with their main curated datasets.  Let me guide you to install 12c on linux and it will be the even easy on windows environment as well.
Steps to install OBIEE 12c are the following:
1.       Review system certification
2.       Install database for repository (or use existing)
3.       Download software distributives
4.       Install
5.       Configure
Review system certification
You can find a certification matrix here. Download "System Requirements and Supported Platforms for Oracle Fusion Middleware 12c (12.2.1)" and ensure your system is certified and patch level is appropriate. Right now certified OSes are Oracle Linux/Redhat Linux 6/7, SLES 11, HP-UX 11.31, IBM AIX 7.1, MS Windows Server 2012/2012 R2, Oracle Solaris 11 (both Sparc and x86_64).
Install database for repository (or use existing)
As for the previous release, OBIEE need a database to store a repository. You will find a list of certified Databases in the same "System Requirements and Supported Platforms for Oracle Fusion Middleware 12c (12.2.1)" document. Right now certified databases are Oracle 12.1.0.1+/11.2.0.4+, IBM DB2 10.5 and MS SQL Server 2012.
Here goes the first difference from 11g. You don't need to download and run RCU before the installation. RCU is bundled with an OBIEE installer. And you have another new option: required repository schemas could be created automatically during a configuration process.
Download software distributives
Before you start you need to download the following distributives:
1.       Java Development Kit (JDK 8)
2.       Oracle Weblogic Server 12c (Fusion Middleware Infrastructure 12.2.1.0.0)
3.       OBIEE 12c
Right now OBIEE 12c is published only on OTN: download page. This page has links to all required distributives for all platforms. The latest version on eDelivery is 11.1.1.9.0.
After downloading and unpacking distributives, you'll get four files.

Install
Installation consists of four main steps:
1.       Install JDK
2.       Install required OS packages
3.       Install FMW infrastructure
4.       Install OBIEE software

Install JDK 8
JDK installation is pretty easy, and I'm sure will cause no problems.

After installation is done, please check the version of java as below.


The second and the third steps have GUI, so you may need to setup X11-forward.
.

Install required OS packages
You also need the xdpyinfo package used by OUI.

OUI says which packages are needed:
?
1
2
3
4
5
6
7
8
9
10
11
12
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
While we don't need this packages at this step, it's a good time to install them and don't think about it anymore.
?
1
sudo yum install compat-libcap1 compat-libstdc++-33 libgcc libstdc++ libstdc++-devel sysstat gcc gcc-c++ make glibc glibc-devel libaio

Install Oracle Fusion Middleware Infrastructure
This part of the installation is very easy and fast. The only decision you need to make is to choose an installation directory (ORACLE_HOME) on the third step. This directory will be used for OBIEE installation. After a full installation (including OBIEE), this directory size on my server is 11G.


The GUI will popup and the window as shown below:

Choose install directory (ORACLE_HOME).












Install OBIEE software
Run the installer



    
    Click ok and you see the below screen
.

Select previously created ORACLE_HOME






Once installation is completed successfully then we need to start configuring as same like obiee11g.
Configure OBIEE
The script for configuring an OBIEE is located in $ORACLE_HOME/bi/bin directory. In my case, ORACLE_HOME is a/u03/oracle/Oracle/Middleware/Oracle_Home directory (was created during an FMW installation).


The configuration script is called config.sh, just like it was in 11g.

Run this script.

Clik ok/next  in step1 and then

Define  (weblogic) password.


Define parameters for repository schemas. As an alternative, you can run RCU located in$ORACLE_HOME/oracle_common/bin directory. Using of an RCU gives you more flexibility (you can define tablespaces, for example, or prepare scripts for a DBA if you don't have DBA privileges).

By default it will take 9500 – 9999, you can change the port numbers according to your requirement

If this is fresh install please select the first option, if you want to migrate from 11g, you have to use the BI Application Bundle jar file to export from 11g to 12c
You can check the oracle doc for more information on migrating from 11g to 12c with bundle jar file


Review and save ports and URLs as they differ from 11g. 



Wait until the process is finished.it takes almost 45 min – 1hr .please be patient to get it completed. If it fails in between, please review the error in the log as given in the above log location, troubleshoot or try to restart the config process once again.


At the end, you will  see the login form. Please note that URL port is changed from 9704 to 9502 .

URL for new Visual Analyzer is different: http://<your_host>:9502/va.

OBIEE 12c Analytics Page:



 OBIEE Visual Analyzer page:

Default entry points
WebLogic Console
http://<your_host>:9500/console
Fusion Middleware Control
http://<your_host>:9500/em
BI Publisher
http://<your_host>:9502/xmlpserver
Visual Analyzer
http://<your_host>:9502/va
BI Analytics
http://<your_host>:9502/analytics
BI Admin tool ODBC port
9514


Enjoy 12c Installation!!!J


Thanks

Saleem Syed (SS)