OBIEE 10G - Linux OEL 5 x86 Installation version 10.1.3.4.1

Download the media part V16379-01 “Oracle Business Intelligence Suite Enterprise Edition 10.1.3.4.1 for Linux x86 (Red Hat / Oracle Enterprise)”

Copy it to a temporay directory, unzip and untar it

[obi@oel11g tmp]$ unzip V16379-01.zip[obi@oel11g tmp]$ cd Media[obi@oel11g Media]$ tar -xf biee_linux_x86_redhat_101341_1of1.tar

Restrictions on Linux

Component Restrictions

Only the following components are available under Linux:

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

Oracle Business Intelligence Publisher

The Administration Tool is available only for Windows operating systems

The repository (.rpd) file can be created and modified only using the Oracle Business Intelligence Administration Tool, which is available only for Windows operating systems.

Linux Pre-configuration

Create the installation directories and the User ID

Choose a user ID that can run all Oracle Business Intelligence processes. You may need to contact your UNIX Administrator to create this user ID. You cannot install Oracle Business Intelligence as the user root

The installation script’s default installation directories are /usr/local/OracleBI and /usr/local/OracleBIData

Creation of the install group

[root@oel11g ~]# groupadd oinstall

Creation of the OBI User (obi/obi)

[root@oel11g ~]# /usr/sbin/useradd obi -g oinstall[root@oel11g ~]# passwd obiChanging password for user obi.New UNIX password:BAD PASSWORD: it is WAY too shortRetype new UNIX password:passwd: all authentication tokens updated successfully.

Creation of the OBI directories

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

where

Linux - chown: Change owner to the user obi

chmod 775: Everything is allowed for the owner and read and execute access are allowed for everyone

Make sure that /dev/random and /dev/urandom are available

Oracle BI Presentation Services requires these pseudo random-number generator devices.

[root@oel11g ~]# cd /dev[root@oel11g dev]# ls *randomrandom  urandom

Set the File Handle Limit parameter

Set the hard and soft limit to the OBI user by modifying the file limits.conf such as for a database installation:

obi                 soft    nofile  1024obi                 hard    nofile  65536

The maximum File-descriptor must be at least 10240

To discover the file-descriptor settings, run the command ulimit -a

Or set file-descriptor using the command ulimit -n 10240

[root@oel11g dev]# ulimit -a|grep openopen files                      (-n) 1024

Environment Variable

You can set them in the .bash_profile shell startup script of the obi user.

# File Descriptor Limitulimit -n 10240# Java HomeJAVA_HOME=/usr/java/jdk1.5.0_22export JAVA_HOME# Local BinaryPATH=$PATH:$HOME/bin# OBI Setup ScriptPATH=$PATH:/usr/local/OracleBI/setupexport PATH# Database ParametersORACLE_HOME=/u01/app/oracle/product/11.2.0/db_1export ORACLE_HOMETNS_ADMIN=$ORACLE_HOME/network/adminexport TNS_ADMINPATH=$ORACLE_HOME/bin:/opt/bin:$PATHexport PATHLD_LIBRARY_PATH=$ORACLE_HOME/lib32:$LD_LIBRARY_PATHexport LD_LIBRARY_PATH

The OBIEE install guide suggests to place the database variable in the shell script OracleBI_Home/setup/user.sh (Locating the Database Setup Script Under UNIX - p126).

You can also in this script seen a lot of code to set environment variable for all others Unix plateform.

Verification of the shell

You must use bash (Bourne-Again Shell) when running Oracle BI scripts under Linux systems.

[root@oel11g dev]# echo $SHELL/bin/bash

Pre-configuration check with the UnixChk.sh Script

UnixChk.sh is a script for UNIX-based installations (including Linux). In order to make sure that the installation machine has all the necessary requirements for a successful installation, run this UNIX check script to check the prerequisites. The script is lightweight and easy to use, and checks for the following conditions:

Supported operating system

Required patches and filesets (if applicable)

Supported configurations

Adequate disk space

User is not root

The UnixChk.sh script is installed in the installer directory containing setup.sh and setup.jar.

Example:

To get the help

[obi@oel11g Oracle_Business_Intelligence]$ ./UnixChk.sh --helpUsage: UnixChk.sh [-b] [-s | <Oracle_BI_install_dir>]    -b    Check build requirements in addition to runtime requirements    -s    Skip installation directory checks?    If neither -s nor <OracleBI_install_dir> are specified, this script assumes      <OracleBI_install_dir> = /usr/local/OracleBI

To test the installation under the obi user for the directory /usr/local/OracleBI

[obi@oel11g Oracle_Business_Intelligence]$ ./UnixChk.sh -b /usr/local/OracleBI   SUCCESS!! - This machine is configured for Oracle BI EE 10.1.3.3.2

Installation

If you plan to install the Oracle BI Server and Oracle BI Presentation Services on two separate machines, read this article before selecting the component that you want : Installing Oracle BI Components on Different Machines

As the Java Development Kit 1.5.0 or greater installation location and all its files and subdirectories must have the writable user or user group permissions for the user installing Oracle Business Intelligence, run the following as root:

chmod -R 777 /usr/java/jdk1.5.0_22

To run the Oracle BI Installer in graphics mode under Linux:

Set the DISPLAY variable using one of the shell commands shown in the following table, if you plan to install OBIEE in graphic mode (no need in console mode).Shell Command Syntax C setenv DISPLAY=”<IP_address>”:0.0 Korn and bash export DISPLAY=”<IP_address>”:0.0

Change directory to the installation directory.

Run the installer :

in graphics mode, use the following command: ./setup.sh

in console mode (text), use the following command: ./setup.sh -consoleThe meanings and default for each screen and prompt for complete Oracle BI EE Infrastructure installation in graphics mode are listed in this Table.

The instructions for a console mode installation are in this topic : Complete Oracle BI Installation (Linux) in Console Mode

Provide the requested input for each screen.

Installation Location: /usr/local/OracleBI

Data Location: /usr/local/OracleBIData

Installation Type: Basic

Set up type: Complete

JDK Location: /usr/java/jdk1.5.0_22

Administrator Credential : oc4jadmin/oc4jadmin

Language: English

To continue to the next screen, click Next. To return to a previous screen, click Back.

To view the help page for each screen, click Help.

In Console Mode, the summary :

Oracle Business Intelligence 10.1.3.4.1 will be installed in the followinglocation:/usr/local/OracleBIwith the following features:Oracle Business Intelligence JDBC DriverOracle Business Intelligence Systems ManagementOracle Business Intelligence ServerOracle Business Intelligence Cluster ControllerOracle Business Intelligence SchedulerOracle Business Intelligence ClientOracle Business Intelligence Presentation ServicesOracle Business Intelligence Presentation Services Plug-in and BI OfficeOracle Business Intelligence Publisherfor a total size: 2626.9 MBPress 1 for Next, 2 for Previous, 3 to Cancel or 4 to Redisplay [1] Installing $L(com.siebel.analytics.install.AnyStringConstants,InstallConfig.ProductName) $P(SiebelAnalyticsProductBean.productNumber). Pleasewait...|-----------|-----------|-----------|------------|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 BusinessIntelligence 10.1.3.4.1.

Restore the JDK directory permission as root:

chmod -R 755 /usr/java/jdk1.5.0_22

Post Installation Tasks

Memory Allocation for OC4J

Allocate enough memory in Oracle Containers for Java (OC4J) for running Oracle BI Publisher.

To allocate additional memory for OC4J:

Stop OC4J, using the Stop OC4J command :

OracleBI_HOME/oc4j_bi/bin/oc4j -stop

Navigate to OracleBI_HOME/oc4j_bi/bin.

Edit the oc4j.cmd file to start OC4J with more memory.

Allocate a minimum of 256 MB of memory by increasing the permanent generation memory to 128m in addition to the regular heap size.

Find the following line:

  set JVMARGS=-Djava.library.path=D:\OracleBI\server\Bin;D:\OracleBI\web\bin -DSAROOTDIR=D:\OracleBI -DSADATADIR=D:\OracleBIData %OC4J_JVM_ARGS%

In this line, between the variables -DSADATADIR=D:\OracleBIData and %OC4J_JVM_ARGS%, add the following text:

  -XX:MaxPermSize=128m -Xmx512m

Save oc4j.cmd.

Starting Oracle BI

Shell scripts

Oracle BI uses shell scripts located in the directory OracleBI_HOME/setup to set environment variables and run specific component shell commands.

The main administration scripts (scripts which call other scripts) are:

oc4j (start OC4J)

run-sa.sh (calls user.sh and starts the Oracle BI Server)

run-saw.sh (calls saw.sh and starts the Oracle BI Presentation Services.)

run-sch.sh (for BI Scheduler)

run-ccs.sh (for the Cluster Controller)

sa-cli.sh (Sets up the environment for running the Oracle BI Client)

The scripts details are listed on this page: Scripts for Korn, Bourne, or Bash Shells.

Under Linux, no initialization process is necessary.

The order in which the services are stopped, then restarted, is important. Use the following sequence to start the OBI Component:

OC4J

Oracle Business Intelligence Server service.

Oracle Business Intelligence Presentation Services service.

Oracle Business Intelligence Scheduler Server service.

Then to start, launch the script in this order

oc4j startrun-sa.sh startrun-saw.sh startrun-ccs.sh start

And to stop:

run-ccs.sh stoprun-saw.sh stoprun-sa.sh stopoc4j -shutdown -port 23791 -password oc4jadmin

Testing the Oracle BI Client

To test the Oracle BI Client :

Run Oracle BI Client by opening another session.

From the setup directory OracleBI_HOME/setup, run the shell command:

.sa-cli.sh

To test the client/server connectivity, run the command:

nqcmd

If the test is successful, press the Enter key several times to quit nqcmd.

Support

BI Publisher Performance - JDK version 1_5_0_7

This issue applies to Versions 10.1.3.3, 10.1.3.3.1, 10.1.3.3.2, 10.1.3.3.3, 10.1.3.4, and 10.1.3.4.1.

There is a bug in Java SE Development Kit (JDK) 5.0 version 1_5_0_7 that impacts the performance of Oracle BI Publisher. For better performance, upgrade to JDK 5.0 update 11 (1_5_0_11). Download and install this update from the following location:

http://java.sun.com/javase/downloads/index_jdk5.jsp

After installing the JDK update, you must modify the OC4J start-up script or batch file to point to the new JDK location.

To modify the OC4J start-up script:

1. On Windows, open <OracleBI>\oc4j_bi\bin\oc4j.cmd for editing. On Linux or UNIX machines, open $OracleBI\setup\oc4j.sh for editing.
2. Set the JAVA_HOME variable to point to the new JDK location. For example, JAVA_HOME=D:\Program Files\Java\jdk1.5.0_11.

If you installed Oracle BI Presentation Services using the Basic Install option on the machine where JDK has been updated, then you must modify the instanceconfig.xml file to point to the new JDK location:

To modify the instanceconfig.xml file:

1. Open the <OracleBIData>/web/config/instanceconfig.xml file for editing.
2. Set the JavaHome parameter to the point to the new JDK location. For example, <JavaHome>D:\Program Files\Java\jdk1.5.0_11</JavaHome>.

How to check that a service is running?

With Linux - ps (process statut)

[root@oel11g ~]#  ps -ef|grep sawserverobi       5102     1  0 15:16 pts/3    00:00:00 /bin/sh /usr/local/OracleBI/setup/sawserver.shobi       5109  5102  0 15:16 pts/3    00:00:08 /usr/local/OracleBI/web/bin/sawserverroot      5984  4661  0 15:39 pts/2    00:00:00 grep sawserver[root@oel11g ~]#  ps -ef|grep nqsserverobi       5081     1  0 15:16 pts/3    00:00:12 /usr/local/OracleBI/server/Bin/nqsserver -quietroot      6001  4661  0 15:40 pts/2    00:00:00 grep nqsserver

If you have only the grep line, the service doesn't run

Documentation / Reference

Oracle Business Intelligence Infrastructure Installation and Configuration Guide