Saturday, June 8, 2013

Oracle BI Publisher 11g Enterprise Installation on Linux

Version: Oracle Business Intelligence 11.1.1.5.0 (64-Bit)
Description: A guide that demonstrates how to install Oracle BI Publisher on Oracle Linux 6.3. This will only go through the enterprise installation, which is an all in one package install (includes WebLogic installation, WebLogic domain creation, and BI installation and configuration).
Prerequisites:
  1. Static IP Address (Must also be included in the /etc/hosts file)
  2. JRockit Installation
  3. Oracle Database 11g

Bits
Oracle Business Intelligence Download Link

For Linux x86-64 bit, you need to download six files.
  • bi_linux_x86_111150_64_disk1_1of2.zip
  • bi_linux_x86_111150_64_disk1_2of2.zip
  • bi_linux_x86_111150_64_disk2_1of2.zip
  • bi_linux_x86_111150_64_disk2_2of2.zip
  • bi_linux_x86_111150_64_disk3_1of2.zip
  • bi_linux_x86_111150_64_disk3_2of2.zip
After unzipping the files mentioned above, a "bishiphome" directory should have been created for you. This directory should contain six "Disk" directories.

You will also need the Repository Creation Utility 11.1.1.5.0. The download should be on the same page as the BI Publisher bits. Although there is only 32-bit version, this is sufficient for the BI schema creation.
  • ofm_rcu_linux_11.1.1.5.0_disk1_1of1.zip
After unzipping this file, a "rcuHome" directory should have been created for you.

BI Publisher Schema Creation
  • Navigate to "rcuHome/bin" directory.
  • Give yourself write permission on the rcu script.
  • Search for the "JRE_DIR" variable in the rcu script and modify to point to your java jre path. Then save.
  • E.g. JRE_DIR=/home/oracle/java/jrockit64/jre
  • Execute the rcu script.
The screenshots given below will walk you through this process.

This is the Welcome page for Repository Creation Utility.
Welcome Page


Create and load component schema into the database.
Step 1: Create Repository


You will need to specify your database connection information. The schema will be created on this database. Make sure your database user has the necessary privileges to perform SQL Data Definition Language (DDL) operations.
Step 2: Database Connection Details


Specify the prefix to be used for your new schema. The Metadata Services and Business Intelligence Platform components are required for the BI Publisher.
Step 3: Select Components
-Metadata Services
-Business Intelligence Platform


This sets the passwords for the new Schema. I prefer to use the same password for all the schema.
Step 4: Schema Passwords


This associates your schemas with tablespaces.
Step 5: Map Tablespaces


This is a summary of all configurations made on the new schemas.
Step 6: Summary


A completion summary of your new schemas.
Step 7: Completion Summary



BI Publisher Installation and Configuration
Modify the "refhost.xml" file located in "bishiphome/Disk1/stage/prereq/linux64" to include the lines given below. Place these lines below the "CERTIFIED_SYSTEMS" tag.

<OPERATING_SYSTEM>
<VERSION VALUE="6.3"/>
<ARCHITECTURE VALUE="x86"/>
<NAME VALUE="Linux"/>
<VENDOR VALUE="redhat"/>
<GLIBC ATLEAST="2.5-12">
</GLIBC>
<PACKAGES>
<PACKAGE NAME="binutils" VERSION="2.17.50.0.6" />
<PACKAGE NAME="compat-libstdc++-33" VERSION="3.2.3" ARCHITECTURE="x86_64" />
<PACKAGE NAME="compat-libstdc++-33" VERSION="3.2.3" ARCHITECTURE="i686" />
<PACKAGE NAME="elfutils-libelf" VERSION="0.125" />
<PACKAGE NAME="elfutils-libelf-devel" VERSION="0.125" />
<PACKAGE NAME="gcc" VERSION="4.1.1" />
<PACKAGE NAME="gcc-c++" VERSION="4.1.1" />
<PACKAGE NAME="glibc" VERSION="2.5-12" ARCHITECTURE="x86_64" />
<PACKAGE NAME="glibc" VERSION="2.5-12" ARCHITECTURE="i686" />
<PACKAGE NAME="glibc-common" VERSION="2.5" />
<PACKAGE NAME="glibc-devel" VERSION="2.5" ARCHITECTURE="x86_64" />
<PACKAGE NAME="glibc-devel" VERSION="2.5-12" ARCHITECTURE="i686" />
<PACKAGE NAME="libaio" VERSION="0.3.106" ARCHITECTURE="x86_64" />
<PACKAGE NAME="libaio" VERSION="0.3.106" ARCHITECTURE="i686" />
<PACKAGE NAME="libaio-devel" VERSION="0.3.106" />
<PACKAGE NAME="libgcc" VERSION="4.1.1" ARCHITECTURE="x86_64" />
<PACKAGE NAME="libgcc" VERSION="4.1.1" ARCHITECTURE="i686" />
<PACKAGE NAME="libstdc++" VERSION="4.1.1" ARCHITECTURE="x86_64" />
<PACKAGE NAME="libstdc++" VERSION="4.1.1" ARCHITECTURE="i686" />
<PACKAGE NAME="libstdc++-devel" VERSION="4.1.1" />
<PACKAGE NAME="make" VERSION="3.81" />
<PACKAGE NAME="sysstat" VERSION="7.0.0" />
</PACKAGES>
<KERNEL>
<!--
<PROPERTY NAME="semmsl" NAME2="semmsl2" VALUE="250" />
<PROPERTY NAME="semmns" VALUE="32000" />
<PROPERTY NAME="semopm" VALUE="100" />
<PROPERTY NAME="semmni" VALUE="128" />
<PROPERTY NAME="shmmax" VALUE="536870912" />
<PROPERTY NAME="shmmni" VALUE="4096" />
<PROPERTY NAME="shmall" VALUE="2097152" />
<PROPERTY NAME="file-max" VALUE="65536" />
<PROPERTY NAME="ip_local_port_range" ATLEAST="1024" ATMOST="65000" />
<PROPERTY NAME="rmem_default" VALUE="4194304" />
<PROPERTY NAME="rmem_max" VALUE="4194304" />
<PROPERTY NAME="wmem_default" VALUE="262144" />
<PROPERTY NAME="wmem_max" VALUE="262144" />
-->
<PROPERTY NAME="VERSION" VALUE="2.6.18"/>
<PROPERTY NAME="hardnofiles" VALUE="4096"/>
<PROPERTY NAME="softnofiles" VALUE="4096"/>
</KERNEL>
</OPERATING_SYSTEM>

Install the required packages:
  • yum install glibc-devel.i686
Execute the runInstaller script located in /bishiphome/Disk1/".
The screenshots given below will walk you through the installation and congiuration process.

This is the Welcome screen.
Step 1: Welcome


Skip software updates.
Step 2: Skip Software Updates


Select enterprise install. This installs binaries in an oracle home and configures working instances.
Step 3: Select Enterprise Install


This validates if your environment meets the necessary criteria to install BI Publisher.
Step 4: Prerequisite Checks


Enter the domain name of the new WebLogic domain and administrator credential to be created.
Step 5: Create New BI System


Specify installation location.
Step 6: Specify Installation Location
MW_HOME=/home/oracle/Oracle/Middleware
ORACLE_HOME=/home/oracle/Oracle/Middleware/Oracle_BI1
INSTANCE_HOME=/home/oracle/Oracle/Middleware/instances/instance1
INSTANCE_NAME=instance1


Select all the components to configure.
Step 7: Select all components


Enter your credentials for your BIPLATFORM schema.
Step 8: BIPLATFORM Schema


Enter your credential for your MDS schema.
Step 9: MDS Schema


Allow the wizard to auto-configure your ports. You can specify your own port with the other option. The other option requires use to create a config file. A sample config file should be in the install package.
Step 10: Configure Ports


Skip the security updates.
Step 11: Skip Security Updates


This is a summary of the configurations you have made in this install.
Step 12: Summary


It may take a while for installation to complete.
Step 13: Installation Progress


This creates a Weblogic instance domain for you as well as configuration for it.
Step 14: Configuration Progress


The summary provides useful URLs and information about your BI Publisher.
Step 15: Complete


Important URLs
WebLogic Console:  http://localhost:7001/console
Oracle Enterprise Manager:  http://localhost:7001/em
Business Intelligence Enterprise Edition: http://localhost:9704/analytics
Business Intelligence Publisher: http://localhost:9704/xmlpserver
Real-Time Decisions: http://localhost:9704/ui
Posted by at
Labels:

1 comment:

Subscribe to: Post Comments (Atom)