Installing OBIEE on 64 Bit Redhat Linux 5.5 The Big Picture


Unfortunately, installing OBIEE on 64 bit Redhat Linux 5.5 is neither simple or straightforward. It is a complex multistep process. Usually requiring that you read dozens of documents and webpages, sometimes for one detail alone.

Here is the big picture, or  high level steps on what to do. And some detail, on a few of the gotchas I had.

For more gory details, you can see:

Oracle’s online document:
http://docs.oracle.com/cd/E14571_01/doc.1111/e14770/biee.htm

And, the 120 page installation document from Oracle: e10539.pdf
Oracle Fusion Middleware
Installation Guide for Oracle Business Intelligence
11g Release 1 (11.1.1)
E10539-02

And the many other links referenced below.

Prerequisites:

A Linux server, with lots of memory, disk space, and CPU power
Redhat Linux 5.5 installed on the server. Install -every- package on the DVD.

Steps:

Read the OBIEE certification matrix
Download the appropriate software
Double check that the Linux installation has the required packages
Install the Oracle database software, if it is not installed already
Install Java JDK, 64 bit
Create a database for the repository
Run the Repository Creation Utility (RCU)
Install WebLogic with generic .jar
Install OBIEE as “software only”
Run configuration assistant to configure OBIEE
Write scripts to start and stop OBIEE

First, check the OBIEE certification matrix, and compare it to your environment. This can keep you busy for a while. I used: bi-11gr1certmatrix-166168.xls

You will need to download multiple pieces of software.

Oracle database 11G for Redhat 5.5
Java JDK, 64 bit
Repository Creation Utility (RCU)
Oracle Fusion Middleware / Weblogic
OBIEE 64 bit for Redhat 5.5


Make sure have you have all the required packages installed on Redhat linux. When I install Redhat, I install every package on the DVDs, to prevent having to find and install them later.

Notes on port conflicts:

If you already are running other applications on this server, you will need to be aware of port conflicts. I was already running Oracle Apps R12 on the same machine. So, before the actual install, I started all the processes for Oracle Apps R12 to ensure that there would be no port conflicts. If the port is not available, the installer will intelligently choose another port. At least we don’t have to that manually.

Install the Oracle database software, if it is not installed already.

Install the JDK, 64 bit

The Java JDK is important.

I used:
jdk-6u26-linux-x64-rpm.bin

chmod -v a+x jdk-6u*
mode of `jdk-6u26-linux-x64-rpm.bin’ retained as 0755 (rwxr-xr-x)

cd /tmp/java

./jdk-6u26-linux-x64-rpm.bin &

rpm -qa –qf “%{NAME}-%{VERSION}-%{RELEASE}_%{ARCH}.rpm \n ” | grep “java” | sort

bsh-javadoc-1.3.0-9jpp.1_x86_64.rpm
gcc-java-4.1.2-48.el5_x86_64.rpm
java-1.4.2-gcj-compat-1.4.2.0-40jpp.115_x86_64.rpm
java-1.4.2-gcj-compat-devel-1.4.2.0-40jpp.115_i386.rpm
java-1.4.2-gcj-compat-devel-1.4.2.0-40jpp.115_x86_64.rpm
java-1.4.2-gcj-compat-src-1.4.2.0-40jpp.115_x86_64.rpm
sun-javadb-client-10.6.2-1.1_i386.rpm
sun-javadb-common-10.6.2-1.1_i386.rpm
sun-javadb-core-10.6.2-1.1_i386.rpm
sun-javadb-demo-10.6.2-1.1_i386.rpm
sun-javadb-docs-10.6.2-1.1_i386.rpm
sun-javadb-javadoc-10.6.2-1.1_i386.rpm
xmlrpc-javadoc-2.0.1-3jpp.1_x86_64.rpm

rpm -qa –qf “%{NAME}-%{VERSION}-%{RELEASE}_%{ARCH}.rpm \n ” | grep “jdk” | sort

jdk-1.6.0_26-fcs_x86_64.rpm
ldapjdk-4.18-2jpp.3.el5_x86_64.rpm

—-

Create a database for the repository.

On my server, Oracle Apps R12 is already running, in its own database. However, I created a separate database and schemas for the repository.

Decide on a good database name for the repository. I used the ORACLE_SID: STOREHOUSE

./dbca &

After creating the database, ensure the listener is configured, and there is connectivity to the database.

Run the Repository Creation Utility (RCU)

A few notes on the RCU. The RCU creates schemas in the repository. The RCU files used for the installation, do not need to stay permanently on the server. Once installed, it looks like they can be deleted.

Even though you are running on 64 bit Redhat, the RCU is 32 bit. One thing I could not find in the documentation, was which unix user should own the RCU files. I used “oracle”, which also owned the database.

For more detail, see:
http://docs.oracle.com/cd/E12839_01/doc.1111/e14259/rcu.htm

mkdir /rcu
chown oracle:dba /rcu

Copy the zip file to this directory and unzip it.

cp /download/rcu/ofm_rcu_linux_11.1.1.5.0_disk1_1of1.zip /tmp/rcu
cd /tmp/rcu
unzip ofm_rcu_linux_11.1.1.5.0_disk1_1of1.zip

export RCU_HOME=/rcu/rcuHome

cd $RCU_HOME/bin

pwd
/rcu/rcuHome/bin

./rcu &

Go through the screens. I created all the schemas that were possible.

RCU will create multiple tablespaces and users/schemas. When it gets to Portal, it will utilize a lot of CPU

—-
Install WebLogic

There are lots of caveats and gotchas with Weblogic.  I installed the file: wls1035_generic.jar

http://onlineappsdba.com/index.php/2011/05/01/obiee-11g-installation-high-level-steps/

Install WebLogic using 64 bit JDK (Use steps mentioned here ). Make sure you install correct weblogic version i.e. use 10.3.3 weblogic for 11.1.1.3 OBIEE. DO NOT install weblogic 10.3.2 or 10.3.4 weblogic with 11.1.1.3 OBIEE

http://docs.oracle.com/cd/E22289_01/html/821-1274/installing-oracle-wls.html
Note – You must install Oracle WebLogic Server as the same user who installed Oracle Unified Directory.

Decide on a directory for weblogic. I used /middleware.

mkdir /middleware
chown oracle:dba /middleware

Turned out that the WebLogic Server I’m using, 10.3.5.0, wants the java version, 1.6.0, or above. My server was defaulting to 1.4.2. Which is odd, since I had just installed the latest JDK.

java –version
java version “1.4.2″

which java
/usr/bin/java

rpm -qa –qf “%{NAME}-%{VERSION}-%{RELEASE}_%{ARCH}.rpm \n ” | grep -i -e “java” -e “jdk” | sort

jdk-1.6.0_26-fcs_x86_64.rpm

Find it:

find / -type f -iname “java”


/usr/java/jdk1.6.0_26/jre/bin/java
/usr/java/jdk1.6.0_26/bin/java

file /usr/java/jdk1.6.0_26/bin/java

/usr/java/jdk1.6.0_26/bin/java: ELF 64-bit LSB executable, AMD x86-64, version 1 (SYSV), for GNU/Linux 2.4.0, dynamically linked (uses shared libs), for GNU/Linux 2.4.0, not stripped

/usr/java/jdk1.6.0_26/bin/java -version

java version “1.6.0_26″
Java(TM) SE Runtime Environment (build 1.6.0_26-b03)
Java HotSpot(TM) 64-Bit Server VM (build 20.1-b02, mixed mode)

Change the path for java:

JAVA_HOME=/usr/java/jdk1.6.0_26
export JAVA_HOME
echo $JAVA_HOME

PATH=$JAVA_HOME/bin:$PATH;
export PATH
echo $PATH

Try again:

java -Xms1024m -Xmx1024m -jar wls1035_generic.jar -log=/tmp/weblogic/wls_install.log -log_priority=debug &

[oracle@black weblogic]$ Extracting 0%……………………………………………………………………………………….100%
Dec 18, 2011 9:25:08 PM java.util.prefs.FileSystemPreferences$2 run
INFO: Created user preferences directory.

Proceed through the GUI.

Use middleware home:
/middleware

Bypass security updates.
Install everything.
Use Sun jdk

Proceed

Seems to hang at: Create uninstaller. 68%
But it proceeds and finishes.

Weblogic administration is very complex. Too much information for here.

—-

Install OBIEE as “software only”

From the Oracle online docs on OBIEE,
http://docs.oracle.com/cd/E14571_01/doc.1111/e14770/biee.htm

Section 53.4.1 Simple Install and Enterprise Install are Not Supported on Linux x86-64 and Microsoft Windows x64
—> Use Software Only install option instead. <—-
Post installation, configure with generic Oracle WebLogic Server and 64-bit JDK.

I worked with these 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

Copy the files to a temporary install directory.
cp bi_linux_x86_111150* /tmp/obieeinstall

Unzip the files:

unzip bi_linux_x86_111150_64_disk1_1of2.zip &
rm bi_linux_x86_111150_64_disk1_1of2.zip &

Before you proceed with the install, you will need to know the location of the directory, oraInventory, and the file, oraInst.loc. If it does not exist here: /etc/oraInst.loc, you will probably have some trouble.

You may in fact have multiple directories and files on the server. Find them. If there are multiple files, make your best decision as to which is the correct one.

find / -type f -iname “oraInst.loc”
find / -type d -iname “oraInventory”

export ORACLE_SID=STOREHOUSE
set | grep “ORACLE”

pwd
/tmp/obieeinstall/bishiphome/Disk1
./runInstaller &

—-

Run configuration assistant to configure OBI

The installation will create a script to configure OBIEE
/middleware/Oracle_BI1/bin/config.sh

export ORACLE_SID=STOREHOUSE
set | grep “ORACLE”

Set weblogic environment variables.
. /middleware/wlserver_10.3/server/bin/setWLSEnv.sh

cd /middleware/Oracle_BI1/bin/
./config.sh &

Remember to save the user, password, domain, the web address to login, etc.

—-

Write scripts to start and stop OBIEE. Which is material for another post.

—-

Useful links:

Big picture/High Level:

http://docs.oracle.com/cd/E14571_01/doc.1111/e14770/biee.htm
https://forums.oracle.com/forums/thread.jspa?messageID=10027505&#10027505
http://onlineappsdba.com/index.php/2011/05/01/obiee-11g-installation-high-level-steps/
http://wentari.blogspot.com/2010/08/obiee-11g-installation-on-linux.html

These OBIEE installs use a virtual machine.
http://ram-obi.blogspot.com/2011/10/obiee11g-installtion-on-oel-55.html
http://www.oramoss.com/wiki/index.php/Install_OBIEE_11.1.1.3.0_on_Oracle_Enterprise_Linux_5.5_with_Oracle_11gR2_RDBMS
http://gerardnico.com/wiki/dat/obiee/installation_11.1

Weblogic:

https://forums.oracle.com/forums/thread.jspa?threadID=2155038
http://middlewaremagic.com/weblogic/?p=2731
http://oracleinstall.wordpress.com/2011/07/14/oracle-data-integrator-11g-installation-linux/
http://docs.oracle.com/cd/E21764_01/doc.1111/e14142/guimode.htm
http://docs.oracle.com/cd/E22289_01/html/821-1274/installing-oracle-wls.html
http://docs.oracle.com/cd/E17904_01/wls.htm

OBIEE:

http://obieeelegant.blogspot.com/2011/09/obiee-11g-111150-software-only.html

About these ads

Leave a Reply

Please log in using one of these methods to post your comment:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s

%d bloggers like this: