All Things Oracle Business Intelligence and more: OBIEE 12c installation steps

Friday, October 23, 2015

OBIEE 12c installation steps

As you probably already know from the blogosphere and twitter, Oracle released OBIEE12c today right before OOW15. This is a quick post to document the software installation in Windows 7 . The software is available on OTN:

http://www.oracle.com/technetwork/middleware/bi-enterprise-edition/downloads/business-intelligence-2717951.html

As indicated on the OTN download page, the installation order is following:

A. Download and install JDK 1.8 from this link, the current release is JDK-8u65

B. Download and install the Web Logic server; installation will be covered in this post

fmw_12.2.1.0.0_infrastructure_Disk1_1of1.zip

C. Download and install Oracle Business Intelligence 12c (12.2.1.0.0) consisting of 2 zip file

fmw_12.2.1.0.0_bi_windows64_Disk1_1of2.zip
fmw_12.2.1.0.0_bi_windows64_Disk1_2of2.zip

D. Download and Install Oracle Business Intelligence Developer Client Tool (12.2.1.0.0) for LINUX installations.

Install Fusion Middleware 12c Infrastructure

this can be accomplished in Windows from the command prompt by issuing:

a. Java –jar fmw_12.2.1.0.0_infrastructure.jar

Search for Fusion Middleware patches

2. Step 2: unzip the two zip file, you should end up with one executable and a folder named Disk2

Install OBIEE 12c by running the setup executable

Following are few screen shots, one thing to note is that the installation has been simplified; in this release, one type of installation is available: Enterprise installation. Another major departure from 11g is the deprecation of the OPMN service.

Specify the previously created Oracle_Home

Configure OBIEE 12c

Navigate to Oracle_Home/bi/bin

and run the configuration script: config.cmd in Windows.

Create the BIPLATFORM schemas, the simplest option is to create new schemas on the fly; one can also using existing schemas created with the RCU.In 12c, the RCU is located in [ORACLE_HOME]\oracle_common\bin

Specify the applications port range

Specify that to install: sample application, existing BI application or a clean slate.

Confirmation window

The configuration process starts; there are fewer steps than in 11g and the process runs much faster. One thing to note is that the “Retry” and “Continue” buttons are not available; in OBIEE 12c, the configuration steps cannot be retried. In the event of a failure, one will have to go through the process again (run RCU, clean up domain directory [ORACLE_HOME]/user_projects/domains/bi similar to the 11g Software Only installation and run the configuration steps.

As mentioned previously, the configuration steps run much faster; once it reaches 100%, there is particular step (Start All Servers) that take a relatively long time;

if all goes well

One thing to note at least on 2 similar Windows installation is that the “Oracle Business Intelligence Enterprise Edition” folder that we are accustomed to is not created in the “Program Folder”.

Here is the new exciting OBIEE 12c home page (technically the Oracle Visual Analyzer is the new home page), cleaner user interface based on Oracle Alta UI and dare I say Tableau-like!