Background

This document was prepared for QNB to assist with installation procedure for Oracle Business Intelligence Applications. This document is meant for step-by-step installation process guide for OBIEE-BIAPPS Environment.

Software Installed

1. 11.2.0.3 Database

2. 11.2.0.1.0 32 Bit and 64 Bit Database Client

3. RCU 11.1.1.7

4. OBIEE 11.1.1.7.14

5. BIAPPS 7.9.6.4

6. Informatica 9.1.0 HF2 Server and Client

7. DAC 11.1.1.6.4 Server and Client

8. BI Developer Client

Server Hardware and Directory Locations

Server Details

OSRHEL 5.9 64 Bit

IP Address10.20.88.110

Host Nameli1hrbi01u.qnb.bnk

Directory Locations

DATABASEDirectory NameLocation

Oracle Home/u01/app/oracle/product/11.2.0.3

TNS_ADMIN/u01/app/oracle/product/11.2.0.3 /network/admin

OBIEEDirectory NameLocation

Middleware Home Directory/u02/app/Middleware

Domain Home Directory/u02/app/Middleware/user_projects/domains/bifoundation_domain

Weblogic Server Home/u02/app/Middleware/wlserver_10.3

Oracle BI Instance/u02/app/Middleware/instances/instance1

ETL (Informatica and DAC)

Directory NameLocation

Informatica Home/u02/app/ETL/Informatica

Domains File/u02/app/ETL/Informatica/domains.infa

Dac Home/u02/app/ETL/DAC/dac

Client Home/u02/app/DB_Client/11.2.0/client_1

Download Software

Software required is downloaded to Windows client machine and ftp to OBIEE and ETL Unix servers.

Download sites:

https://edelivery.oracle.com

https://support.oracle.com

OBIEE Software for Linux x86-64

RCU

Informatica and DAC

Download below software files for DAC and Informatica for Linux to Window machine.

Note: First we need to download the DAC and Informatica software to Windows machine, then unzip the files on Windows machine and copy the tar file to Linux machine and untar it on Linux machine.

BIAPPS 7.9.6.4

Software downloaded location in the server

Directory NameLocation

11.2.0.3 Database/u01/Softwares/Database_11g/database

11.2.0.1 DB Client/u01/Softwares/Database_Client/client

OBIEE 11.1.1.7 Software/u01/Softwares/OBIEE_Linux64/bishiphome

RCU 11.1.1.7/u01/Softwares/RCU_Linux64/rcuHome

Informatica Server/u01/Softwares/Informatica_910_Linux_64bit/910HF2_Server_Installer_linux-x64

Pre-Requisites

a. Kernel Version

2.6.32-100.0.19 or later

b. Unix Servers need below RPMs Installed (same or higher versions) on Red Hat 5.8

binutils-2.17.50.0.6compat-libstdc++-33-3.2.3compat-libstdc++-33-3.2.3 (32 bit)elfutils-libelf-0.125elfutils-libelf-devel-0.125gcc-4.1.2gcc-c++-4.1.2glibc-2.5-24glibc-2.5-24 (32 bit)glibc-common-2.5glibc-devel-2.5glibc-devel-2.5 (32 bit)ksh-20060214libaio-0.3.106libaio-0.3.106 (32 bit)libaio-devel-0.3.106libaio-devel-0.3.106 (32 bit)libgcc-4.1.2libgcc-4.1.2 (32 bit)libstdc++-4.1.2libstdc++-4.1.2 (32 bit)libstdc++-devel 4.1.2make-3.81sysstat-7.0.2openmotif-2.2.3openmotif22-2.2.3xorg-x11-utilsunixODBC-2.2.11 (32-bit) or laterunixODBC-devel-2.2.11 (64-bit) or laterunixODBC-2.2.11 (64-bit) or laterunixODBC-devel-2.2.11 (32-bit) or later

c. Unix Servers need below kernel parameters set in sysctl.conf

fs.aio-max-nr = 1048576fs.file-max = 6815744kernel.shmall = 2097152kernel.shmmax = 536870912kernel.shmmni = 4096kernel.sem = 250 32000 100 128net.ipv4.ip_local_port_range = 9000 65500net.core.rmem_default = 262144net.core.rmem_max = 4194304net.core.wmem_default = 262144net.core.wmem_max = 1048576

d. Unix Servers need below parameters in limits.conf

* soft nofile 4096 * hard nofile 65535

Install Database 11.2.0.3Install 11.2.0.4 Database Software

run ./runInstaller with oracle user from /u01/Software/Database_11g/database

Uncheck Security updates and click Next

Click Yes

Select Skip software updates and click Next

Select Install database software only option and click Next

Select Single instance database installation and click Next

Select Enterprise Edition and click Next

Provide Oracle base and Software location and click Next

Provide Inventory Directory location and Group Name as above and click Next

Click on Fix and Check Again to fix the failed parameters.

Execute the above script as root and then click Ok

Click on Install

Execute above scripts as root user and click OK

Click Close to complete the database software installation