2. Installation and configure OBIEE 12c

Oracle BI 12c Installation and Configuration Guide for Linux x86-64

Introduction

Oracle Business Intelligence Enterprise Edition (OBIEE) 12c has been available for some time now, bringing significant changes to the installation process compared to its predecessor, OBIEE 11g. This comprehensive guide provides step-by-step instructions for installing and configuring OBIEE 12c on Linux x86-64 systems.

Prerequisites and Downloads

Before beginning the installation, you'll need to download the following components from Oracle Technology Network (OTN):

Required Software

• JDK 8 (version 1.8.0_40 or higher)

• WebLogic Server (included in the infrastructure installation)

• Fusion Middleware Infrastructure 12c (12.2.1.0.0)

  • fmw_12.2.1.0.0_infrastructure_Disk1_1of1.zip

• Oracle Business Intelligence 12c (12.2.1.0.0)

  • fmw_12.2.1.0.0_bi_linux64_Disk1_1of2.zip

  • fmw_12.2.1.0.0_bi_linux64_Disk1_2of2.zip

Step 1: Configure Java Environment

After installing JDK 8, set up the necessary environment variables:

bash

export JAVA_HOME=/usr/java/jdk1.8.0_65
export PATH=$JAVA_HOME/bin:$PATH

For permanent configuration, add these variables to your shell profile (e.g., .bash_profile or .bashrc).

Step 2: Install Oracle Fusion Middleware Infrastructure 12c

The Infrastructure installation provides the foundation for OBIEE 12c and includes WebLogic Server.

Installation Process

1. Extract the downloaded archive:

   bash

   unzip -q fmw_12.2.1.0.0_infrastructure_Disk1_1of1.zip

2. Launch the installer:

   bash

   $JAVA_HOME/bin/java -d64 -jar fmw_12.2.1.0.0_infrastructure.jar

3. Follow the installation wizard:

   • Click Next on the welcome screen

   • Choose Skip Auto Updates and click Next

   • Specify the Fusion Middleware Home location (e.g., /app/oracle/obiee12c)

   • Select Fusion Middleware Infrastructure with Examples if you want to explore sample applications

   • Verify system configuration checks pass successfully

   • Click Install to begin the installation

   • Click Finish to complete the process

Step 3: Install Oracle Business Intelligence 12c

Important Note: OPMN (Oracle Process Manager and Notification Server) is deprecated in OBIEE 12c and is no longer used in Oracle Fusion Middleware.

Installation Process

1. Navigate to your download directory:

   bash

   cd /home/oracle/obiee12c

2. Extract both BI installation files:

   bash

   unzip -q fmw_12.2.1.0.0_bi_linux64_Disk1_1of2.zip
   unzip -q fmw_12.2.1.0.0_bi_linux64_Disk1_2of2.zip

3. Launch the BI installer:

   bash

   ./bi_platform-12.2.1.0.0_linux64.bin

4. Follow the installation wizard:

   • Click Next on the welcome screen

   • Choose Skip Auto Updates and click Next

   • Specify the same Fusion Middleware Home location used in Step 2

   • Select BI Platform with Samples if you want to explore sample applications

   • Verify system configuration checks pass successfully

   • Click Install to begin the installation

   • Click Finish to complete the process

Step 4: Repository Creation Using RCU

The Repository Creation Utility (RCU) is now integrated into the software installation, eliminating the need for a separate download.

Database Requirements

• Oracle Database 11g R2 (11.2.0.4) or higher

• For Oracle Database 12c, Oracle recommends using container database architecture as non-container architecture is deprecated

Running RCU

1. Navigate to the RCU location:

   bash

   cd /app/oracle/obiee12c/oracle_common/bin
   ./rcu

2. Follow the RCU wizard:

   • Click Next on the welcome screen

   • Select Create Repository and choose System Load and Product Load (requires DBA privileges)

   • Enter Oracle database connection details

   • Click OK when prerequisite checks complete

   • Specify a prefix for schemas (default: DEV)

   • Provide passwords for schemas to be created

   • Click Create to confirm schema creation

   • Click Close to exit RCU

Step 5: Configure OBIEE 12c

Running the Configuration Utility

1. Navigate to the BI configuration directory:

   bash

   cd /app/oracle/obiee12c/bi/bin
   ./config.sh

Configuration Wizard Steps

1. Component Selection: Select Business Intelligence Enterprise Edition (and optionally other components)

2. System Checks: Verify all checks pass successfully

3. Domain Configuration: Specify details for the BI domain to be created

4. Schema Selection: Choose Use existing schemas (created earlier with RCU)

5. Port Configuration: Use default values or customize as needed

6. Sample Selection: Choose SampleAppLite if desired

7. Configuration: Click Configure (this process may take some time)

8. Completion: Click Next and then Finish to complete configuration

9. Save Log: Save the installation log file for future reference

Post-Configuration

After successful configuration, a browser window will automatically open, allowing you to log in to OBIEE.

Service Management Commands

The following scripts are located in <OBIEE_HOME>/user_projects/domains/bi/bitools/bin:

• Start services: ./start.sh

• Check status: ./status.sh

• Stop services: ./stop.sh

Conclusion

You have now successfully installed and configured Oracle Business Intelligence 12c on a Linux x86-64 system. The new installation process, while different from 11g, is streamlined and integrated, with RCU now being part of the core installation rather than a separate utility. Remember to use the container database architecture when working with Oracle Database 12c, and always save your configuration logs for troubleshooting purposes.

---

Note: Oracle recommends using Oracle Database 11g R2 (11.2.0.4) or higher, and for Database 12c, the container database architecture is strongly recommended.