Useful tips for installation of Oracle Business Intelligence on a Linux machine

obiee-linuxThis guide assumes you already have installed Oracle on your Linux machine and you now want to install Oracle Business Intelligence. It also assumes you are working on a 64-bit Linux machine. Before proceeding to the installation of OBIEE do the following:

 

 

 

 

Tip #1

– Open your terminal window and type: “sqlplus / as sysdba”

– Wait for a while and type “startup”

– Type “exit” in your terminal and again type “lsnrctl start”. ————————————————————————————————————

When you reach the point for Database Connection Details in Repository Creation Utility (RCU) do the following:

Tip #2 rcu-connection-details

Host Name: localhost

Port: 1521

Search for file called “tnsnames.ora” in you Oracle installation folder, something like (/oracle/app/oracle/product/11.2.0/db_1/network/admin) and fill in Service Name: appropriately.

Username: sys

Password: The password used when installing Oracle. ————————————————————————————————————

After installing RCU, proceed to the Oracle Business Intelligence Enterprise Edition (OBIEE) installation.
Before you do the installation follow the tip below:

Tip #3

Search for file called “ORAPARAM.ini” in a location like “bishiphome/Disk1/install/linux64″ and append the following line:

JRE_MEMORY_OPTIONS=” -mx1024m -XX:MaxPermSize=1024m”

This will prevent the installation from hanging and finally failing. It is very frustrating to fail, uninstall and start the process again! So make sure you do this step before installation. ————————————————————————————————————

When you reach the point where OneOff Patches are being installed (Step 13 of 15), follow the tip below:

Tip #4

Search for file called “ORAPARAM.ini” in a location like “OBIEEMIDDLEWARE/Oracle_BI1/oui” and append

JRE_MEMORY_OPTIONS=” -mx1024m -XX:MaxPermSize=1024m”

This will allocate sufficient memory to Java when config.bat file is executed (Step 14 of 15). obiee-step14 ————————————————————————————————————

After installing OBIEE you have to make sure that the following links are working:

WebLogic Console
http://[hostname]:7001/console obiee-weblogic-console

Oracle Enterprise Manager
http://[hostname]:7001/em obiee-enterprise-manager

Business Intelligence Enterprise Edition
http://[hostname]:9704/analytics obiee-enterprise-edition

For these to work follow the tip below:

Tip #5

Open Terminal

1) go to OBIEEMIDDLEWARE/wlserver_10.3/server/bin type “./startNodeManager.sh”

2) go to OBIEEMIDDLEWARE/Oracle_BI1/products/Essbase/aps/deployments/Weblogic/7.0 type “./startWebLogic.sh”

3) Check in and verify that bi_server1 is running obiee-bi_server1

Express Yourself

*