A couple of days ago Oracle released a highly anticipated Oracle Business Intelligence 12c (12.2.1.0.0). I've spent a couple of days installing it on an Oracle Linux 7 server. I can't say that it was flawless. An installation process was terminated few times without clear description what was wrong. I don't know yet all of tricks and pitfalls and this guide is only the first version. I've managed to do it, but I don't sure I can repeat it anytime.

This post is about a Linux installation procedure only. You can read about Windows 7 installation here OBIEE - Installing OBIEE 12c on my Windows box. From my point of view, there is no significant difference.

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 needs 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 12

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.

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.

I haven't found a list of required packages in the official documentation (wasn't trying hard enough?). But fortunately, OUI says which packages are needed:

Update December 30, 2015 Required packages and a ton of useful information for all supported platforms are in the documentation here. Thanks to Jeremy Harms

binutils-2.23.52.0.1  
compat-libcap1-1.10  
compat-libstdc++-33-3.2.3 for x86_64  
compat-libstdc++-33-3.2.3 for i686  
gcc-4.8.2  
gcc-c++-4.8.2  
glibc-2.17 for x86_64  
glibc-2.17 for i686  
glibc-devel-2.17 for x86_64  
libaio-0.3.109 for x86_64  
libaio-devel-0.3.109 for x86_64  
libgcc-4.8.2 for x86_64  
libgcc-4.8.2 for i686  
libstdc++-4.8.2 for x86_64  
libstdc++-4.8.2 for i686  
libstdc++-devel-4.8.2 for x86_64  
ksh  
make-3.82  
ocfs2-tools-1.8.0  
sysstat-10.1.5  
numactl-2.0.9 for x86_64  
numactl-devel-2.0.9 for 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.

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.




Choose install directory (ORACLE_HOME).







Install OBIEE software

Run the installer



Select previously created ORACLE_HOME






Configure OBIEE

The script for configuring an OBIEE is located in $ORACLE_HOME/bi/bin directory. In my case, ORACLE_HOME is /u03/oracle/Oracle/Middleware/Oracle_Home directory (was created during an FMW installation).

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

Run this script.


Define a superuser (weblogic) password.

Define parameters for repository schemas. As an alternative, you can run RCU located in $ORACLEHOME/oraclecommon/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).


Review and save ports and URLs as they differ from 11g. I've placed a table with default ports at the end of this post.



Wait until the process is finished. Have patience, this process isn't fast. During my experiments, configuration failed few times on different steps of the configuration process. As I've said before, I don't know why yet.

If you are lucky enough, you'll get the end, and see the login form. Please note that URL is the same as it was in 11g, but the port is changed from 9704 to 9502.

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


Default entry points

WebLogic Consolehttp://<your_host>:9500/console
Fusion Middleware Controlhttp://<your_host>:9500/em
BI Publisherhttp://<your_host>:9502/xmlpserver
Visual Analyzerhttp://<your_host>:9502/va
BI Analyticshttp://<your_host>:9502/analytics
BI Admin tool ODBC port9514

linux installation obiee obiee 12c


Andrew Fomin Profile Picture
Andrew Fomin

OBIEE specialist since 2007 and Oracle Discoverer before. DWH architect, BI enthusiast, blogger. Lazy cats owner. All opinions are my own and not the views of my employer.


Additional Posts
Share This Post
Twitter Google+ Pinterest Facebook
comments powered by HyperComments