Oracle Business Intelligence Enterprise Edition 12c Installation Overview

Pre requistics
  1. 64 bit OS is must
  2. Loopback adapter settings
  3. Make sure you unzip the downloaded setup files in the same machine where you’re intended to install obiee. I saw few issues when extracted file is brought from 2008 r2 to win8.
  4. Decide user with whom you’re proceeding with installations and ensure oraInventory access.
  5. Windows Firewall set to Off
  6. JDK 1.8.0_51+
  7. Oracle Database 11.2.0.4+ or 12.1.0.1+;
Downloading Software

For downloading required software(s) https://www.oracle.com/technetwork/middleware/bi-enterprise-edition/downloads/business-intelligence-2717951.html.
Below is the list of software to be downloaded:

  1. Java Developers Kit 8 (JDK8)
    • Download For Linux and Microsoft Windows
  2. Web Logic Server
    • Download Generic (1.4 GB)
  3. Oracle Business Intelligence 12c (12.2.1.0.0)
    • for Microsoft Windows x86-64-bit:
    • Download File 1 (1.4 GB)
    • Download File 2 (1.8 GB)
  4. Oracle Business Intelligence Developer Client Tool (12.2.1.0.0)
    • Download for Microsoft Windows x86-64-bit (676 MB)
Installation of OBIEE 12c

This installation is divided in to 4 parts as below :

  1. Installing Weblogic 12c : Install Oracle Fusion Middleware Infrastructure (no configuring domain for infrastructure)
  2. Installing Oracle BI 12c
  3. Configuring RCU : run rcu part of /oracle_common/bin to create schema required
    • Set BI_PRODUCT_HOME env variable for ex: C:\oracle\product\Middleware\Oracle_Home\bi
  4. Configuring OBIEE 12c Configure obiee standard topology using 12c configuration assistant

Leave a Comments

Your browser doesn't support the canvas element - please visit in a modern browser.

(new shape)

Configuring RCU

Overall Steps

  1. Installing Weblogic 12c : Install Oracle Fusion Middleware Infrastructure (no configuring domain for infrastructure)
  2. Installing Oracle BI 12c
  3. Configuring RCU : run rcu part of /oracle_common/bin to create schema required
  4. Configuring OBIEE 12c Configure obiee standard topology using 12c configuration assistant
Configuring RCU Now Goto obiiee12c
D:\OBIEE12C\Middleware\Oracle_Home\oracle_common\bin There you the RCU setup File obiiee12c
obiiee12c
obiiee12c
obiiee12c
obiiee12c
obiiee12c
obiiee12c
obiiee12c
obiiee12c
obiiee12c
obiiee12c
obiiee12c

Now move to step : Configuring OBIEE 12c Configure obiee standard topology using 12c configuration assistant

Leave a Comments

Your browser doesn't support the canvas element - please visit in a modern browser.

(new shape)

Installing Weblogic 12c

Overall Steps

  1. Installing Weblogic 12c : Install Oracle Fusion Middleware Infrastructure (no configuring domain for infrastructure)
  2. Installing Oracle BI 12c
  3. Configuring RCU : run rcu part of /oracle_common/bin to create schema required
  4. Configuring OBIEE 12c Configure obiee standard topology using 12c configuration assistant

Extract the file so that you have fmw_12.2.1.0.0_infrastructure.jar

obiiee12c
obiiee12c

Click Next

obiiee12c

Click Next

obiiee12c

Specify the OBIEE Location Path

obiiee12c

Click Next

obiiee12c

Click Next

obiiee12c

Check the Checkbox

obiiee12c

Click Yes

obiiee12c

Click Install

obiiee12c

Click Next

obiiee12c
obiiee12c
obiiee12c

Now move to step :Installing Oracle BI 12c

Leave a Comments

Your browser doesn't support the canvas element - please visit in a modern browser.

(new shape)

Migrating From OBIEE 11g to 12c in Windows

Migrating From OBIEE 11g to 12c in Windows

What you need to know before we begin:
OBIEE 12c has already been installed and configured, therefore our bi-migration-tool.jar file has been generated. Also, this example is migrating from an OBIEE 11.1.1.9 release.

Overview steps

  1. Create the Export Bundle
  2. Import the Export Bundle

Before you procced keep below paths handy:

obiiee12c
Create the Export Bundle

The export bundle is a .jar file that consists of metadata information from the 11g Oracle home.

Navigate to location [ORACLE_HOME]\bi\migration-tool\jlib location

obiiee12c

Copy "bi-migration-tool.jar" to folder name "migration"

1. From the command line enter into above folder path (this should be where your bi-migration-tool.jar file is located)

2. Run the following command to generate the export bundle

java -jar bi-migration-tool.jar out <oracle 11g home> <domain home> <output export bundle path>

Where :

  • out is telling the migration tool to lierform the export operation
  • <oracle 11g home> is the Oracle BI home directory
  • <domain home> is the 11g domain directory
  • is the location where you want the export bundle. NOTE: the file must have a .jar extension

Example : java -jar bi-migration-tool.jar out E:\donot_delete_server\Oracle11\Middleware\Oracle_BI1 E:\donot_delete_server\Oracle11\Middleware\user_projects\domains\bifoundation_domain E:\Migration\My11gExport.jar

obiiee12c
If everything is successful you will receive an Export succeeded message from the command prompt and you should be able to locate your export file in the location specified in the previous command. obiiee12c
Import the Export Bundle

Again, 12c has been installed and configured, so our domain and BI instance have already been created. With that in mind, we will be using the BI Migration script to import the export bundle. You can use the BI 12c Configuration Assistant to reference the export bundle if you’re configuring 12c for the first time.

1. You should be in the same file location as before:

2. Run the following command:

java -jar bi-migration-tool.jar in <12c Oracle Home> <12c domain home> <export bundle> <service instance name>

Where
  • in tells the migration tool to perform an import operation
  • e:\obiee12c\middleware\oracle_home is the Oracle Home
  • e:\obiee12c\middleware\oracle_home\user_projects\domains\bat_domain is the 12c domain directory
  • e:\11g\11gexport.jar is the previously created export bundle
  • ssi is the BI service instance

Example : java -jar bi-migration-tool.jar in E:\donot_delete_server\Oracle12\product\Oracle_Home E:\donot_delete_server\Oracle12\config\domains\bi E:\Migration\My11gExport.jar ssi

obiiee12c

3. You will be prompted to enter the RPD password

obiiee12c

4. If the migration is successful you will receive a Migration action succeeded message

obiiee12c

To verify login to OBIEE 12c and you should see your dashboards, subject areas, etc that have been imported from your 11g.

obiiee12c

Leave a Comments

Your browser doesn't support the canvas element - please visit in a modern browser.

(new shape)

Configuring OBIEE 12c Configure obiee standard topology using 12c configuration assistant

Overall Steps

  1. Installing Weblogic 12c : Install Oracle Fusion Middleware Infrastructure (no configuring domain for infrastructure)
  2. Installing Oracle BI 12c
  3. Configuring RCU : run rcu part of /oracle_common/bin to create schema required
  4. Configuring OBIEE 12c Configure obiee standard topology using 12c configuration assistant
Now goto D:\OBIEE12C\Middleware\Oracle_Home\bi\bin obiiee12c
Click Config.exe obiiee12c
obiiee12c
obiiee12c
obiiee12c
obiiee12c
obiiee12c
obiiee12c
obiiee12c
obiiee12c
obiiee12c
obiiee12c
obiiee12c
obiiee12c
obiiee12c
obiiee12c
obiiee12c

Leave a Comments

Your browser doesn't support the canvas element - please visit in a modern browser.

(new shape)