OBIEE: Install on OEL 5.4

I've had a fun week installing this on OEL. Six times I've started and stopped because it would just sit there and hang.

I had it installed a few weeks ago, but if memory serves me, I let it run overnight and everything was up and running. I blew that one away so I could get some more practice (and I wanted to write it up).

I'll post on the problems later (thanks Tom!) but for now, these are the steps I took to install OBIEE 10.1.3.4 on Oracle Enterprise Linux 5, Update 4.

For the uninitiated (i.e. Linux n00bs), it is no where near as "difficult" as installing the database. No creating "extra" users or groups...pretty much just rock 'n roll.

I've already created a new VM with a user "oracle." Halfway through (this whole process) I thought about using "oraclebi" or something different as I will be installing 11gR2 on this machine, but I got lazy. Once the VM was created the very first thing I did was install Java 6 (1.6_0.17 or something) SDK with Java EE. I won't go through that installation, but you do need to remember, if you are new to Linux, that you must change the permissions on the .bin file to make it executable.

Java is installed.

Next up, I need to make sure the open-files parameter for ulimit is at or above 10240. How do you do that? With some help from a friend, I logged in as root and edited the /etc/security/limits.conf file. I added the following lines:

#<domain>      <type>  <item>         <value>
#

#*               soft    core            0
#*               hard    rss             10000
#@student        hard    nproc           20
#@faculty        soft    nproc           20
#@faculty        hard    nproc           50
#ftp             hard    nproc           0
#@student        -       maxlogins       4
*       soft    nofile  10240
*       hard    nofile  63536
# End of file

Now logged in as oracle, I issue the ulimit -a command to see what the current setting is (should be 10240 as I specified that as the minimum (soft))

[oracle@localhost OracleBI]$ ulimit -a
core file size          (blocks, -c) 0
data seg size           (kbytes, -d) unlimited
scheduling priority             (-e) 0
file size               (blocks, -f) unlimited
pending signals                 (-i) 20479
max locked memory       (kbytes, -l) 32
max memory size         (kbytes, -m) unlimited
open files                      (-n) 10240
pipe size            (512 bytes, -p) 8
POSIX message queues     (bytes, -q) 819200
real-time priority              (-r) 0
stack size              (kbytes, -s) 10240
cpu time               (seconds, -t) unlimited
max user processes              (-u) 20479
virtual memory          (kbytes, -v) unlimited
file locks                      (-x) unlimited

How did I know to do this? It's in the docs, page 46 or so.

I also need to add 2 directories:

[root@localhost ]# mkdir /usr/local/OracleBI
[root@localhost ]# mkdir /usr/local/OracleBIData

Then change the ownership of those directories to oracle

[root@localhost ]# chown oracle /usr/local/OracleBI
[root@localhost ]# chown oracle /usr/local/OracleBIData

OK, we're cooking now. Wait, need to change the permissions on the location of the SDK you just installed. OBIEE provides you with a script to do this (and one to reverse it), but I just

[root@localhost ]# chmod ugo+rwx /opt/SDK -R

Yes, I opened it up to the world...this is just a sandbox. I can do what I want. Obviously not recommended for production purposes.

Almost there. Navigate to your unzipped/untarred location which for me is /obiee:

[oracle@localhost ]$ cd /obiee/RH_Linux/Server/Oracle_Business_Intelligence
[oracle@localhost ]$ls -ltr
total 882548
-rwxrwxrwx 1 oracle root          12 Dec 10 01:45 media.inf
-rwxrwxrwx 1 oracle root        2460 Dec 10 01:45 setup.sh
-rwxrwxrwx 1 oracle root        6395 Dec 10 01:45 license.xml
drwxrwxrwx 4 oracle root        4096 Dec 10 01:45 Config
-rwxrwxrwx 1 oracle root   859572849 Dec 10 01:47 setup.jar
-rwxrwxrwx 1 oracle root       48675 Dec 10 01:47 UnixChk.sh
drwxrwxrwx 2 oracle root        4096 Dec 10 01:47 help
-rwxrwxrwx 1 oracle root         108 Dec 10 01:47 version.txt
drwxrwxrwx 3 oracle root        4096 Dec 10 01:47 script
-rwxrwxrwx 1 oracle root    43145508 Dec 10 01:47 Linux.bin
drwxrwxrwx 3 oracle root        4096 Dec 10 01:47 doc

First up, run the UnixChk.sh to make sure we've got everything.

[oracle@localhost Oracle_Business_Intelligence]$ ./UnixChk.sh 
SUCCESS!! - This machine is configured for Oracle BI EE 10.1.3.4  

Sweet.

I'm running this in console mode because I can't seem to run the GUI. Both xterm and xclock work, as suggested by the installation guide, but it still fails. I'll worry about the another day.

To install

[oracle@localhost Oracle_Business_Intelligence]$ ./setup.sh -console
InstallShield Wizard

Initializing InstallShield Wizard...

Preparing Java(tm) Virtual Machine...
...................................
...................................
...................................
...................................
...................................
...................................
...................................
...................................
...................................
...................................
...................................
...................................
...................................
...................................
...................................
...................................
...................................
...................................
...................................
...................................
...................................
............
-------------------------------------------------------------------------------
Please read the information below.

IMPORTANT!!! The complete installed Oracle BI EE suite requires at least 2.5 GB
of free disk space.

At least 200 MB of free disk space in the /tmp and /var/tmp directories is
required for installing Oracle BI EE.

Press 1 for Next, 3 to Cancel or 4 to Redisplay [1] 1

That "Preparing Java(tm) Virtual Machine" part is where it was hanging up before...it takes about 60 seconds to initialize.

Enter 1 and hit Enter.

-------------------------------------------------------------------------------
Oracle Business Intelligence Installation

Welcome. Oracle Business Intelligence will be installed.

Browse or Enter the Installation Location: [/usr/local/OracleBI] 


Browse or Enter the Data Location: [/usr/local/OracleBIData] 


Select the Installation Type:

[X] 1 - Basic: Minimum security. Installs Oracle Containers for J2EE (OC4J).
[ ] 2 - Advanced: Enhanced security. Requires Oracle Application Server
        10.1.3.1.0 or greater.

To select an item enter its number, or 0 when you are finished: [0] 

Just hit enter to accept the default (Basic)

Press 1 for Next, 2 for Previous, 3 to Cancel or 4 to Redisplay [1] 1

Enter 1 then Enter.

Choose the setup type that best suits your needs.

[X] 1 - Complete
        All Oracle Business Intelligence components will be installed.
                                                                                 
[ ] 2 - Oracle Business Intelligence Server
        Only server components will be installed. (Includes Oracle Business
        Intelligence Server, Cluster Controller, Scheduler, Systems Management.)
                                                                                 
[ ] 3 - Oracle Business Intelligence Presentation Services
        Only presentation services components will be installed. (Includes Oracle
        Business Intelligence Presentation Services, Presentation Services
        Plug-in, BI Office, Systems Management.)
                                                                                 
[ ] 4 - Oracle Business Intelligence Client Tools
        Only client components will be installed. (Includes Oracle Business
        Intelligence Client Tools.)
                                                                                 
[ ] 5 - Oracle Business Intelligence Publisher
        Oracle Business Intelligence Publisher will be installed.
                                                                                 
[ ] 6 - Custom
        The program will be installed with the features you choose.
        Recommended for advanced users.

To select an item enter its number, or 0 when you are finished: [0] 

Hit Enter for Complete, otherwise enter the number for your choice. Enter 1, Enter (Next).

Now you are prompted for the location of the SDK you just installed, enter it and hit Enter

-------------------------------------------------------------------------------
Java Development Kit (JDK) Location

Java Development Kit 1.5.0 or greater is required.

Browse or Enter the JDK Location (JAVA_HOME): [] /opt/SDK/jdk

Then enter your password, confirm it and hit "Next."

Set the password for the oc4jadmin administrator user. This password should be
used for any OC4J operations post-install. Remember the password because it
cannot be reset and will be used for uninstallation.

Administrator username:
oc4jadmin

Administrator password: 


Confirm password: 


Press 1 for Next, 2 for Previous, 3 to Cancel or 4 to Redisplay [1] 1

Error Message Language Selection...for me the default, hit Enter and then Next. Then Please wait...

Error Message Language Selection

A chosen component requires the selection of a language for presentation of
error messages. Please select one of the following languages:

[ ] 1  - Arabic
[ ] 2  - Chinese (Simplified)
[ ] 3  - Chinese (Traditional)
[ ] 4  - Croatian
[ ] 5  - Czech
[ ] 6  - Danish
[ ] 7  - Dutch
[X] 8  - English
[ ] 9  - Finnish
[ ] 10 - French
[ ] 11 - German
[ ] 12 - Greek
[ ] 13 - Hebrew
[ ] 14 - Hungarian
[ ] 15 - Italian
[ ] 16 - Japanese
[ ] 17 - Korean
[ ] 18 - Norwegian
[ ] 19 - Polish
[ ] 20 - Portuguese (Brazilian)
[ ] 21 - Portuguese (European)
[ ] 22 - Romanian
[ ] 23 - Russian
[ ] 24 - Slovak
[ ] 25 - Spanish
[ ] 26 - Swedish
[ ] 27 - Thai
[ ] 28 - Turkish

To select an item enter its number, or 0 when you are finished: [0] 


Press 1 for Next, 2 for Previous, 3 to Cancel or 4 to Redisplay [1] 1

Please wait...

"Confirmation Screen", hit Next

-------------------------------------------------------------------------------
Oracle Business Intelligence 10.1.3.4.1 will be installed in the following
location:

/usr/local/OracleBI

with the following features:

Oracle Business Intelligence JDBC Driver
Oracle Business Intelligence Systems Management
Oracle Business Intelligence Server
Oracle Business Intelligence Cluster Controller
Oracle Business Intelligence Scheduler
Oracle Business Intelligence Client
Oracle Business Intelligence Presentation Services
Oracle Business Intelligence Presentation Services Plug-in and BI Office
Oracle Business Intelligence Publisher

for a total size:

 2626.9 MB

Press 1 for Next, 2 for Previous, 3 to Cancel or 4 to Redisplay [1] 1

Then the fun starts...

Installing $L(com.siebel.analytics.install.AnyStringConstants,
InstallConfig.ProductName) $P(SiebelAnalyticsProductBean.productNumber). Please
wait...


|-----------|-----------|-----------|------------|
0%         25%         50%         75%        100%
|||||||||||||||||||||||||||||||||||||||||||||||||||

Installing Oracle Business Intelligence 10.1.3.4.1. Please wait...
|||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||

Creating uninstaller...

Please wait...

-------------------------------------------------------------------------------
The InstallShield Wizard has successfully installed Oracle Business
Intelligence 10.1.3.4.1. Choose Next to continue the wizard.

Press 1 for Next, 3 to Cancel or 4 to Redisplay [1] 1

-------------------------------------------------------------------------------
Oracle Business Intelligence Installation Summary

The installation of Oracle Business Intelligence Enterprise Edition 10g
(10.1.3.4.1) was successful.

Access the Welcome Page at /usr/local/OracleBI/index_bi_ee.html

Oracle Containers for J2EE (OC4J) is automatically started at the end of
installation.

OC4J can be manually started by running the command:
 /usr/local/OracleBI/setup/oc4j -start

Press 1 for Next, 3 to Finish or 4 to Redisplay [1] 1
WARNING: could not delete locked file /tmp/ismp002/7262907
WARNING: could not delete locked file /tmp/ismp002
[oracle@localhost Oracle_Business_Intelligence]$ cd /usr/local/OracleBI

I skipped a Next there, I didn't think you would mind.

Total time for installation?



Your software is installed, now what?
Now you run and test it!

Three things I need to do to start it:
1. Start the Oracle BI Server (ra-sa.sh)
2. Start the Presentation Services (ra-saw.sh)
3. Start the OC4J instance (oc4j)

These files are located in /usr/local/OracleBI/setup

[oracle@localhost 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 /usr/local/OracleBI/server/Log/NQServer.log
[oracle@localhost OracleBI]$ tail -f /usr/local/OracleBI/server/Log/NQServer.log 
2009-12-10 11:21:53
     [36007] Loading repository /usr/local/OracleBI/server/Repository/samplesales.rpd.
2009-12-10 11:21:54
     [14055] Loading subject area: Sample Sales ...
2009-12-10 11:21:56
     [14056] Finished loading subject area: Sample Sales.
2009-12-10 11:21:56
     [58002] Query Cache loaded with 0 entries from saved cache files.
2009-12-10 11:21:56

Analytics

[oracle@localhost OracleBI]$ ./setup/run-saw.sh start
Oracle BI Java Host startup initiated.
Please check '/usr/local/OracleBIData/web/log/javahost.out.log' for 
Oracle BI Java Host startup details.
Please go to the '/usr/local/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 '/usr/local/OracleBIData/web/log' directory for 
Oracle BI Presentation Services log files.

And finally OC4J

[oracle@localhost OracleBI]$ ./setup/oc4j -start
Starting OC4J from /usr/local/OracleBI/oc4j_bi/j2ee/home ...

Maybe now it's a finally...and finally some pretty pictures.

OC4J Home


OC4J Admin Login


OC4J Admin


BI Publisher


Analytics


Next up, configuring data sources.