Thursday, December 10, 2009

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.

7 comments:

Tom said...

NOT that it is a big deal, but so that I don't go insane and disturb the OCD side of me, make hard 65536 :)

oraclenerd said...

I did that on purpose...I read somewhere (yes, dangerous) that you shouldn't allow it to go to the max. But I'll side with you on this...next time I'll use the max available.

Anonymous said...

Nice run through.

If you're interested, there's a good explanation of the difference between running OC4J and OAS ("Basic" vs "Advanced" in the install respectively) here.
In essence, OC4J is fine for sandbox but at most prod sites OAS would probably be preferred.

ObPlug: this all changes in 11g :-)

Oh, and once you start playing and debugging, check out the diagram on p16 of the deployment guide. It illustrates all the ports and connectivity between the services and is invaluable!

oraclenerd said...

@rnm1978

Didn't I tell you I had been reading all of your stuff? In fact, I think I read every single article in the OBIA and OBIEE categories. :)

I went on to read that one on 11g as well. WebSphere huh? I guess I better get a head start on it. I know it's integrated with JDeveloper, I just haven't had the need to fire it up yet.

I'm fortunate that I've worked with both OC4J and OAS in the past. Knowing that I can use the admin.jar to change the oc4jadmin password is always a savior.

Thanks for the diagram...that's pretty awesome, lays things out very nicely. Might becomes it's own post soon.

Unknown said...

Hi,

Thanks its very helpfull post sctually i'm installing RHEL 5.3 but still it is helpfull. I'm resolved my issue and i'm installed successfully on my env with your post.

Thnaks,
Srikanth

Simon P said...

Hi,

Thanks for all your great advice on installing ebs/obieee and literally everything i need to know.

Could you help by advising of any documentation to install this version of obiee on OEL 5.4 with an instance of EBS 12.1.1 Vision on the same box?

Thanks

oraclenerd said...

@Simon P

Glad all those things helped out.

I don't believe you would need to do anything else to get OBIEE installed on the same machine as EBS. You might confirm that there are no port conflicts, but off the top of my head, I can't think of any.

You may also want to create a separate user (say, obiee) to manage the OBIEE stuff.