BI Publisher 11.1.1.6.0 Software Installation

Prerequisites:  Linux environment setup and Oracle Database 11g

Description: This guide will show you how to install BI Publisher 11.1.1.6.0 on a Linux 64 bit environment. Here is an overview of the "Software Only" type installation path:

1. Install Java. 
2. Install WebLogic 10.3.6.
3. Create BI Publisher schemas with Repository Creation Utility 11.1.1.6.0.
4. Install BI Publisher.
5. Configure BI Publisher.

Downloads: You can download BI Publisher 11.1.1.6.0 here. The others can be downloaded from Oracle Software Delivery Cloud. You may use a different version of Java as long as the Business Intelligence Suite 11.1.1.6.0 certification matrix is fulfilled.

1. Java (jdk-7u45-linux-x64.gz)
2. WebLogic 10.3.6 (V29856-01.zip)
3. RCU 11.1.1.1.6.0 (V29674-01.zip)
4. BI Publisher
• bi_linux_x86_111160_64_disk1_1of2.zip
• bi_linux_x86_111160_64_disk1_2of2.zip
• bi_linux_x86_111160_64_disk2_1of2.zip
• bi_linux_x86_111160_64_disk2_2of2.zip
• bi_linux_x86_111160_64_disk3.zip

References:  BI Publisher Documentation Library

Oracle Java Installation
Extract jdk-7u45-linux-x64.gz to oracle home directory. You may specify a different Java installation directory as long as you adjust your bash profile accordingly.

tar -xvf jdk-7u45-linux-x64.gz -C /home/oracle/

Add JAVA_HOME and the path of your java bin directory in your bash profile. Export the environment variables.

JAVA_HOME=/home/oracle/jdk1.7.0_45
PATH=$JAVA_HOME/bin:$PATH
ORACLE_HOME=/home/oracle/app/oracle/product/11.2.0/dbhome_1
ORACLE_SID=orcl

export JAVA_HOME PATH ORACLE_HOME ORACLE_SID

Validate Java installation.

which java #Make sure this is pointing to the correct Java
java -version #Make sure if Java is working

WebLogic 10.3.6 Installation
Extract V29856-01.zip. A wls1036_generic.jar file should have been created. Execute the jar file.

unzip V29856-01.zip
java -jar wls1036_generic.jar

The screen shots given below will walk you through the installation wizard.

Welcome

MW_HOME Directory: /home/oracle/Oracle/Middleware

Uncheck "I wish to receive ..."

Check "I wish to ..."

Select Typical

Select your Java directory

Leave values to default

Click Next

Installation

Uncheck "Run Quickstart" and click Done

BI Schemas Creation
If you are using jdk1.7.0_45 and running through the wizard, you will need a different java version because the combo boxes in the wizard does not display any values. I will be using jdk1.6.0_45 to run the wizard.

Extract V29674-01.zip. A "rcuHome" directory should have been created. Change the JRE_DIR variable in the "rcuHome/bin/rcu" script to point your jdk1.6.0_45 directory. Execute the rcu script and follow the screen shots given below.

Welcome: RCU 11.1.1.6.0

Select Create

Specify database environment

Select Oracle Business Intelligence

Schema Password

Click Next

Click OK

Create BIPLATFORM and MDS Schema

BI Publisher Installation
Extract the bi zip files. A "bishiphome" directory with 5 Disk directories inside should have been created after unzipping all five zip files. Run the "bishiphome/Disk1/runInstaller" script to start installing.  Follow the screen shots given below.

Side Note: On redhat-6 or above OS, you have to modify "bishiphome/Disk1/stage/prereq/linux64/refhost.xml" to include a prerequisite check for your OS version. You can copy or replace the redhat-5 prerequisite checks. After that you need to change the the VERSION value and the i386 packages to i686.   

Welcome

Skip Security Updates

Select Software Only Install

Fix any prerequisite checks.
I was missing compat-libcap1.x86_64 package. 

Middleware Home: /home/oracle/Oracle/Middleware

Uncheck "I wish to receive ..."

[Optional]: Save response file

Software Installation

[Optional]: Save summary file

BI Publisher Configuration
A WebLogic domain will created and configured on this phase. The domain will have BI Publisher installed in it. Navigate to "/home/oracle/Oracle/Middleware/Oracle_BI1/bin" directory and execute "config.sh" script. Follow the screen shots given below.

Welcome

Prerequisite Checks

WebLogic Domain and User Creation

Leave to default values

Select components. You CANNOT add on components later on.

BI_PLATFORM Schema

MDS Schema

Default Ports: WebLogic = 7001 and BI Publisher = 9704
To specify ports, modify "bishiphome/Disk1/stage/Response/staticports.ini"
and select that file on this for "Specify Ports ..." option. Make sure to uncomment.

Uncheck "I wish to ..."

[Optional]: Save response file

Configuration

[Optional]: Save summary file

  
Validate BI Installation
After installation, the webLogic AdminServer and the BI managed servers are started. Go to "http://<HOSTNAME>:<Port>/xlmpserver" (E.g. http://localhost:9704/xmlpserver/).

BI Publisher Login

BI Publisher Home Page