Rittman Mead - Delivered Intelligence

Ok, so I tried running the OBIEE installer again, this time choosing only BI Server option. When I read through the install.log I noticed that it was complaining about that the UnixChk.sh didn’t exist. The reason for that was simple, I had renamed it when I was writing the previous post. I renamed the file back to the original name (and made sure it did run successfully) then the actual installation ran fine. This was odd. The script was not used during the startup of the installer nor for any the various screens I was shown, but actually after the installation started.

Here we can see the successful installation screens:

And then on with the show.

First I tried starting the nqsserver. After a few failed tries, I narrowed the solution down to these steps

oracle@borg:~/product/obiee10.1.3.2.1/OracleBI/server$ export JAVA_HOME=/usr/lib/jvm/java-6-sun
oracle@borg:~/product/obiee10.1.3.2.1/OracleBI/server$ export SAROOTDIR=/home/oracle/product/obiee10.1.3.2.1/OracleBI
oracle@borg:~/product/obiee10.1.3.2.1/OracleBI/server$ export LD_LIBRARY_PATH=$SAROOTDIR/server/Bin
oracle@borg:~/product/obiee10.1.3.2.1/OracleBI/server$ export SADATADIR=/home/oracle/product/obiee10.1.3.2.1/OracleBIData
oracle@borg:~/product/obiee10.1.3.2.1/OracleBI/server$ export SATEMPDIR=/home/oracle/product/obiee10.1.3.2.1/OracleBIData/tmp
oracle@borg:~/product/obiee10.1.3.2.1/OracleBI/server$ Bin/nqsserver
Oracle BI Server starting...
rm: cannot remove `/home/oracle/product/obiee10.1.3.2.1/OracleBIData/tmp/nQS_*.TMP': No such file or directory
nqsserver: Oracle BI Server started. Version: 10.1.3.2.1.070411.1900.


Later on I found the actual startup scripts, located in the $SAROOTDIR/setup/ directory, called run-sa.sh. Keep in mind that I have never ever installed the OBIEE on Linux before.

Moving on … And then the oc4j container. Here I did have some more problems, since the container simply refused to start, stating that the
oc4jadmin wasn’t configured properly.

oracle@borg:~/product/obiee10.1.3.2.1/OracleBI/oc4j_bi/bin$ ./oc4j -start
Starting OC4J from /home/oracle/product/obiee10.1.3.2.1/OracleBI/oc4j_bi/j2ee/home ...
07/05/05 14:15:15 Error initializing server: OC4J administrator account is not configured correctly. Please make sure that at least one administration account is created and configured correctly.
07/05/05 14:15:15 Fatal error: server exiting


I found a thread at the Oracle Forums that helped here. I had to add my hostname with IP to the /etc/hosts file. Probably due to the fact that my home network isn’t properly configured for the nslookup and the dhcp

oracle@borg:~/product/obiee10.1.3.2.1/OracleBI/oc4j_bi/bin$ ./oc4j -start
Starting OC4J from /home/oracle/product/obiee10.1.3.2.1/OracleBI/oc4j_bi/j2ee/home ...
07/05/05 15:00:15 Oracle Containers for J2EE 10g (10.1.3.1.0) initialized

Now that I am satisfied that the server as well as the oc4j components are well installed, I restart the installer

oracle@borg:~/RH_Linux/Server/Oracle_Business_Intelligence$ ./setup.sh

and this time I choose the Presentation Services option .

After the installation, you must start the BI server as well as the SAW server (Presentation Server):

oracle@borg:~/product/obiee10.1.3.2.1/OracleBI/setup$ ./run-sa.sh start
Oracle BI Server startup initiated.
Please wait for a while for the Oracle BI Server to completely start.
Execute the following command to check the Oracle BI Server logfile and see if it started.
tail -f /home/oracle/product/obiee10.1.3.2.1/OracleBI/server/Log/NQServer.log
oracle@borg:~/product/obiee10.1.3.2.1/OracleBI/setup$ tail -3 /home/oracle/product/obiee10.1.3.2.1/OracleBI/server/Log/NQServer.log
[58002] Query Cache loaded with 0 entries from saved cache files.
2007-05-05 15:38:45
[43030] : Oracle BI Server started. Version: 10.1.3.2.1.070411.1900.
oracle@borg:~/product/obiee10.1.3.2.1/OracleBI/setup$ ./run-saw.sh start
Oracle BI Java Host startup initiated.
Please check '/home/oracle/product/obiee10.1.3.2.1/OracleBIData/web/log/javahost.out.log' for Oracle BI Java Host startup details.
Please go to the '/home/oracle/product/obiee10.1.3.2.1/OracleBIData/web/log/javahost' directory for Oracle BI Java Host log files after starting up.
Oracle BI Presentation Services startup initiated.
Please go to the '/home/oracle/product/obiee10.1.3.2.1/OracleBIData/web/log' directory for Oracle BI Presentation Services log files.


Bob’s your uncle! Log in to the Dasboard and start playing! http://borg.starfleet.fed:9704/analytics/saw.dll?Answers

Posted in Linux, Oracle BI Suite EE | 5 Comments »