Monday, June 4, 2012

How to: Complete OBIEE 10g installation Part 2 and 3 - Oracle Analytics Server & Presentation Services

In our last how-to post we covered the first step of installing OBIEE 10g on linux , Configuration of JDK for Oracle Business Intelligence

This post will focus on steps 2 and 3 below:


1) Configuration of JDK for Oracle Business Intelligence  - COMPLETE
2) Set up of the Oracle Business Intelligence Server
3) Set up of the Oracle Business Intelligence Presentation Services

4) Set up of the Oracle Business Intelligence Client Tool set

In Step 1 we:

1) configured JDK for our redhat linux box
2) created applicable usernames and groups
3) granted directory permissions to specific folders
4) created environmental variables needed for OBIEE 10g installation.


Do not continue unless you have completed the above steps, as they are pre-requisites for Steps 2 and 3.


Step 1 : Modification of bash shell script to include Oracle Environmental Variables


The OBIEE 10g installation is going to look for the following variables in your bash profile:

1) $JAVA_HOME
2) $PATH  - modified to include your OBI Set up folder

We created the $JAVA_HOME variable in step 1, so let's go ahead and modify our bash shell script to include the OBI Set up folder for the $PATH variable

For user account OBI, run the following command in terminal:

vi ~/.bash_profile
 
modify the bash shell start up script to include 

# OBI Setup Script
PATH=$PATH:/usr/local/OracleBI/setup
export PATH
 
Also, set the file descriptor limit to 10240 
 
# File Descriptor Limit
ulimit -n 10240 


Here is a VI review guide incase your VI skills are a little rusty: http://www.washington.edu/computing/unix/vi.html 


Step 2: Create installation folders & grant required access

Oracle Analytics Server uses /usr/local/setup/OracleBI and /usr/local/setup/OracleBIData for installation and execution. We need to create those folders and grant our user obi read write access:

Log into your root/super user account or have the sys admin execute the following commands:
 

mkdir -p /usr/local/OracleBIchown -R obi:oinstall /usr/local/OracleBIchmod -R 775 /usr/local/OracleBImkdir -p /usr/local/OracleBIDatachown -R obi:oinstall /usr/local/OracleBIDatachmod -R 775 /usr/local/OracleBIData

Step 3: Confirm /dev/random and /dev/urandom are available

Oracle BI  Presentation Services requires pseudo random number generation devices. Confirm your system has urandom and random installed:

In terminal, run the following command:

[cookjohn@local]/usr/local/OracleBI/setup% cd /dev
[cookjohn@local]/dev% ls *random


You should see the following output:

random  urandom


Step 4: Download Oracle BI Suite EE 10.1.3

Navigate to http://www.oracle.com/technetwork/middleware/bi-enterprise-edition/downloads/business-intelligence-10g-165415.html 

and download x86 (Red Hat Linux / Oracle Enterprise Linux)

Then extract the file to your /tmp folder. You should have 2 folders:

drwxrwxr-x  3    59934 oinstall       4096 May 24 10:40 Server
drwxrwxr-x  5    59934 oinstall       4096 May 24 10:41 Server_Ancillary


Using your root/super user account, execute (or have the sys admin) the following commands:


chown -R obi:oinstall /tmp/Server
chmod -R 775 /tmp/Server
chown -R obi:oinstall /tmp/Server_Ancillary
chmod -R 775 /tmp/Server_Ancillary
 
Step 5: Run final compatibility check with UnixChk.sh

Oracle created a script which will determine if you've successfully completed all of the pre-work needed for installation.
In terminal, run the following command:

./UnixChk.sh -b /usr/local/OracleBI 
 
You should get the following output: 
 
SUCCESS!! - This machine is configured for Oracle BI EE 10.1.3.3.2 

Step 6: Proceed with installation

Congratulations, you've completed all of the required pre-work needed to install OBIEE! Let's get started! Navigate to your /usr/local/OracleBI/setup folder and run the following command:


./setup.sh -console

You will be asked to identify your java directory, installation type and installation folder.
Here are the details:

  • Installation Location: /usr/local/OracleBI
  • Data Location: /usr/local/OracleBIData
  • Installation Type: Basic
  • JDK Location: /usr/java/jdk1.5.0_22

     
 FYI: Basic vs Advanced Installation Primer:

Basic installation uses the J2EE Application Server rather than the Oracle Application Server. If you want to utilize single sign on, select Advanced.

In terminal, your summary should be as follows:

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] 


|-----------|-----------|-----------|------------|
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.
 

 
Step 7: Start Services

Now that you've installed OBIEE Server & Presentation services, you need to activate it by running the following scripts from your /usr/local/OracleBI/setup folder:

./oc4j -start # starts Oracle Application Server
./run-sa.sh start # starts BI server
./run-saw.sh start # starts presentation server
./run-ccs.sh start  # Oracle BI Cluster Controller
 
 
To shutdown the server, you need to run the commands in the opposite order:
 
./run-ccs.sh stop
./run-saw.sh stop
./run-sa.sh stop
./oc4j -shutdown -port 23791 -password oc4jadmin 
 
Step 8: Log into Answers

Navigate to your web server's root directory and append :9704/analytics/saw.dll?Dashboard to it. For example, if your web server is http://www.example.com , your url would be : http://www.example.com:9704/analytics/saw.dll?Dashboard


















Default user/pass is : Administrator/Administrator
You can access Oracle Enterprise Manager 10g by appending :9704/em/ to your web server's root directory
In Summary, we :


1) Configured JDK for OBIEE
2) Created the appropriate installation folders
3) Created required environmental variables
4) Confirmed the system had appropriate random number generation scripts
5) Modified the file descriptor limit
6) Validated our configuration using Oracle's UnixChk script
7) Installed OBIEE 10G Server & Presentation Services using the basic installation method (Java instead of Oracle's Application Server)
8) Determined the process for starting and stopped services
9) Validated installation by navigation to the default Answers & Oracle Enterprise Manager 10g URLs.

Excellent job if you've made it this far. If you've been paying attention, you'll notice that only server side components have been installed. We still need to install the Client tools which allow us to modify the repository and remotely connect to the linux box. Stay tuned!
 
keywords : obiee 10g installation, obiee 10g linux, obiee 10g server installation process, obiee 10g configuration, obiee install linux