Oracle BI Apps 11.1.1.8 Installation Guide/Tutorial

Oracle BI Apps 11.1.1.8 Installation Guide Tutorial

1. Pre Reqs of Oracle BI Apps 11.1.1.8 Installation
2. Oracle Database 11.2.0.4 Installation Steps
3. RCU Installation Steps

1. Pre Reqs of Oracle BI Apps 11.1.1.8 Installation

Check RPMs using below command

rpm –qa | grep <rpm name>
If any one is not installed then install using below command
rpm -ivh (rpm name)

Below is the list of RPMs for Linux 6 64 Bit

• ·         binutils-2.20.51.0.2-5.11.el6 (x86_64)
• ·         compat-libcap1-1.10-1 (x86_64)
• ·         compat-libstdc++-33-3.2.3-69.el6 (x86_64)
• ·         compat-libstdc++-33-3.2.3-69.el6.i686
• ·         gcc-4.4.4-13.el6 (x86_64)
• ·         gcc-c++-4.4.4-13.el6 (x86_64)
• ·         glibc-2.12-1.7.el6 (i686)
• ·         glibc-2.12-1.7.el6 (x86_64)
• ·         glibc-devel-2.12-1.7.el6 (x86_64)
• ·         glibc-devel-2.12-1.7.el6.i686
• ·         ksh
• ·         libgcc-4.4.4-13.el6 (i686)
• ·         libgcc-4.4.4-13.el6 (x86_64)
• ·         libstdc++-4.4.4-13.el6 (x86_64)
• ·         libstdc++-4.4.4-13.el6.i686
• ·         libstdc++-devel-4.4.4-13.el6 (x86_64)
• ·         libstdc++-devel-4.4.4-13.el6.i686
• ·         libaio-0.3.107-10.el6 (x86_64)
• ·         libaio-0.3.107-10.el6.i686
• ·         libaio-devel-0.3.107-10.el6 (x86_64)
• ·         libaio-devel-0.3.107-10.el6.i686
• ·         make-3.81-19.el6
• ·         sysstat-9.0.4-11.el6 (x86_64)

Unix ODBC RPMs

·         unixODBC-2.2.14-11.el6 (x86_64) or later

·         unixODBC-2.2.14-11.el6.i686 or later

·         unixODBC-devel-2.2.14-11.el6 (x86_64) or later

·         unixODBC-devel-2.2.14-11.el6.i686 or later

Below BI Apps two RPMS are enough 

a.      libXp-1.0.2-2.1.el6.x86_64

b.      libXi1.7.2-2.2.el6.x86_64

Complete list is given below:

libXau-1.0.6 (i686), libXcb-1.8 (i686), libX11-1.5 (i686), libXext-1.3 (i686), libtool-ltdl-2.2 (i686), ncurses-libs-5.7 (i686), readline-6.0 (i686), libICE-1.0 (i686), libuuid-2.17 (i686), libSM-1.2 (i686), libXt-1.1 (i686)

1. Install Sun (Oracle) JDK 1.6.0_45 64-bit for Linux
2. Chmod +x jdk-6u45-linux-x64-rpm.bin
3. sh jdk-6u45-linux-x64-rpm.bin

Check and Update Kernel Parameters if necessary

Parameter	Minimum Value	File
semmsl semmns semopm semmni	250 32000 100 128	/proc/sys/kernel/sem
shmall	2097152	/proc/sys/kernel/shmall
shmmax	Minimum: 536870912 Maximum: A value that is 1 byte less than the physical memory Recommended: More than half the physical memory See My Oracle Support Note 567506.1 for additional information about configuring shmmax.	/proc/sys/kernel/shmmax
shmmni	4096	/proc/sys/kernel/shmmni
file-max	6815744	/proc/sys/fs/file-max
ip_local_port_range	Minimum: 9000 Maximum: 65500	/proc/sys/net/ipv4/ip_local_port_range
rmem_default	262144	/proc/sys/net/core/rmem_default
rmem_max	4194304	/proc/sys/net/core/rmem_max
wmem_default	262144	/proc/sys/net/core/wmem_default
wmem_max	1048576	/proc/sys/net/core/wmem_max
aio-max-nr	1048576 Note: This value limits concurrent outstanding requests and should be set to avoid I/O subsystem failures.	/proc/sys/fs/aio-max-nr

Check Kernel Parameters using below mentioned commands table

Parameter	Command
semmsl, semmns, semopm, and semmni	# /sbin/sysctl -a | grep sem This command displays the value of the semaphore parameters in the order listed.
shmall, shmmax, and shmmni	# /sbin/sysctl -a | grep shm
file-max	# /sbin/sysctl -a | grep file-max
ip_local_port_range	# /sbin/sysctl -a | grep ip_local_port_range
rmem_default	# /sbin/sysctl -a | grep rmem_default
rmem_max	# /sbin/sysctl -a | grep rmem_max
wmem_default	# /sbin/sysctl -a | grep wmem_default
wmem_max	# /sbin/sysctl -a | grep wmem_max

1. Oracle Database 11.2.0.4 Installation Steps

1.       Login with oracle user

2.       Unzip media zip files in a directory

a.       Unzip –o <filename>

3.       

4.       Check Oracle ODBC RPMs

5.       Check Oracle User’s Primary Group is OINSTALL

6.       Update kernel parameters

7.       Update /etc/sysctl.conf

a.       Kernel.shmmax =                            Half the size of RAM

b.      Kernel.shmmni = 4096

c.       Net.core.rmem_max = 4194304

d.      Net.core.rmem_default= 262144

e.                     

8.       No need to update /etc/resolve.conf

9.       Update limits.conf

Uncheck Security update screen

Skip Software Updates

Create and configure database

System Class ->Server Class

Single Instance database installation

Advanced Install

English

Enterprise Edition

Installation Location

Oracle Base: /do1/OBI_Home/oracle

Software Location: /do1/OBI_Home/oracle/product/11.2.0

General Processing

Database Administrator Group: DBA

Database Operator (OSOPER) Group(Optional):

Database Installation Completed

Add entry in listener.ora file

Fusion Middleware Repository Creation Utility (RCU)

Make Directory in obie_rcu/d01/BIAppsMedia/

unzip rcuhome zip file in the folder obie_rcu folder

cd rcuHome/bin

./rcu

Welcome

Create

Database connection details

Host Name:BIApps

Port: 1521

Servicename: TESTBI

Userame: sys

Password: Manager123

Role: SYSDBA

Select Components

Create a new prefix: OBI

As Commeon Schema

                AS Meta Data Services

Oracle Business Intelligence

                Business Intelligence Plateform

Schema Passwords

Biapps123

Map Tablespace

Make tablespace to 100MB

Summary

Create

Completion Summary

Install OBIEE

Make Direcotor in /d01/OBI_Home with the name OBIEE

Unzip files in the new created folder

cd disc1

./runInstaller

Skip

Enterprice install

Prerequiste checks

Create New BI System

Username: weblogic

Password: Oracle123

Domain Name: <Leave it default>

Do not scale out

Specify Install Location

Oracle Middleware Home Location: /d01/OBI_Home/OBIEE

Leave other fields to default

Configure Components

Leave all checkbox checked

BIPlateform Schema

Database Type: Oracle Database

Connection String: BIAPPS:1521:TESTBI

BIPlateform schema username: OBI_BIPLATEFORM

BIPlateform schema Password: Biapps123

MDS Schema

UserName : OBI_MDS

Password: Biapps123

Configure Ports

Auto port configuration

Security Update

Uncheck I wish to receive

Summary

Click Install

Check from the url:

http://bitest.ifl.net:9704/analytics

http://192.168.1.33:9704/analytics/        

5. Upgrade Weblogic Server to 10.3.6

We have installed weblogic 10.3.5 with OBIEE installation now we just need to upgrade using below mentioned path. If we install OBIEE with Simple Option selected and do not install weblogic then we have to use V29856-01 from edelivery.oracle.com for fresh install. Refer to the document: e51478 Point No. 3.2.6

Download upgrade patch No. 13529623 whose file name will be: p13529623_1036_Generic.zip

Unzip path file $ unzip -o p13529623_1036_Generic.zip

Copy the wls1036_generic.jar file in the oracle/home/oracle/opt/OBI_Home/BIAPPs/Oracle_BI1/jdk/bin folder

Java –jar wls1036_generic.jar

GUI Screens

Press Next

Check use an existing middle ware home

Uncheck receive email and next

Leave uncheck Oracle Coherence

6. Install Oracle Data Integrator (ODI)

Unzip v37390-01 1 and 2 files

Go to disk1 cd disk1

./runInstaller –jreLoc /home/oracle/opt/OBI_Home/BIApps/oracle_BI1/jdk

Select Installation Type

Pre requisite Checks

Installation Location

Application Server

Skip Repository Configuration

Installation Summary

Installation Progress

Run BI Apps RCU

Refer Section 3.3.2 of e51478 document

Download V44918-01.zip file

Extract it

cd BIappsRCU

./rcu

If you see error executing, backup existing rcu and edit rcu file and change JRE_DIR as given below commenting existing parameter

##JRE_DIR=$ORACLE_HOME/jdk/jre

JRE_DIR=/usr/java/jdk1.6.0_45/jre

Database Connection Details

Select all Components

Manage Table Spaces

Summary

Press Create Button

Run BI Apps RCU second time (Optional)

Database Connection Details

Select Components

Select an existing prefix

Choose remaining two components

                Oracle Business Integration Application Components

                Oracle Data Integration Master and Work Repository

Schema Passwords

Custom Variable

Give the value of the .dmp files folder path. Do not include the name of the .dmp file in the directory path.

Map Tablespaces

GO with the default values

Summary

Press the create button

Install Oracle BI Apps

Refer Section 3.3.3 of Document e51478

cd BIAppsMedia\BIApps

Unzip file V44887.zip

unzip –o v44887.zip

cd disk1

./runInstaller .jreLoc /d01/OBI_Home/OBIEE/Oracle_BI1/jdk

Welcome

Click Next

Pre Requisite Checks

Click next

Installation Location

Oracle Middleware Home: /d01/OBIE_Home/OBIEE

Oracle Home Directory: Oracle_BI1 (Use Existing, Do not create new)

Click Next

Summary

Patches

Unzip V44890 1 and 2 files and V44897-01.zip file

ShutdownWebLogicAdministrationServer,ManagedServer,andNodeManager. Shut down BI processes using Oracle Process Manager and Notification Server (OPMN).

Make changes in apply_patches_import.txt file as mentioned below

ORACLE_HOME=/home/oracle/opt/OBI_Home/BIAPPS/Oracle_BI1

MW_HOME=/home/oracle/opt/OBI_Home/BIAPPS

COMMON_ORACLE_HOME=/home/oracle/opt/OBI_Home/BIAPPS/oracle_common

WL_HOME=/home/oracle/opt/OBI_Home/BIAPPS/wlserver_10.3

##SOA_HOME=/scratch/aime/work/mw_home/Oracle_SOA1

ODI_HOME=/home/oracle/opt/OBI_Home/BIAPPS/Oracle_ODI1

##SKIP_BITECH_PATCHES=false

# Optionally Required WINDOWS_UNZIP_TOOL_EXE - If platform is windows, then specify unzip tool exe with complete path

# Currently only two tools : Winzip command line and 7-Zip command line are supported tools.

# Eg for Winzip tool - c:{PathSep}Program Files{PathSep}WinZip{PathSep}wzunzip.exe

# Eg for 7-Zip tool - c:{PathSep}Program Files{PathSep}7-Zip{PathSep}7z.exe

##WINDOWS_UNZIP_TOOL_EXE=

# Required WORKDIR - An existing writable directory to create logs and temp patch files

WORKDIR=/home/oracle/opt/temp

# Required PATCH_ROOT_DIR - Path of patch directory till the release patch-set folder which is inside patches4fa/dist.

# i;e the patch-set folder for a particular release to apply patch from

# eg; /scratch/aime/tmp/ps1/biappsshiphome/patches4fa/dist/ps6rc3

PATCH_ROOT_DIR=/home/oracle/soft/BI11gEE/BIapps/patches

Exceute below mentioned command:

perl APPLY_PATCHES.pl /home/oracle/opt/OBI_Home/BIAPPS/Oracle_BI1/biapps/tools/bin/apply_patches_import.txt

Review log file for patch status

Cd /home/oracle/OBI_Home/Temp

vi biappshiphome_generic_patches.log

vi

Bounce with biapps.sh script

Check from console Upgrade is done

http://<ipaddress>:7001/em

http://<ipaddress>:7001/console

http://<ipaddress>:9704/analytics

It should be 11.1.1.7.131017

Update ATG Lite

Section 3.3.5 of the guide e51478

Command to execute:

Go to folder: /home/oracle/opt/OBI_Home/BIApps/Oracle_BI1/biapps/tools/lib

Execute:

 jave –jar biappsrepositoryutil.jar upgradeATG bi.oracle.home=/home/oracle/opt/OBI_Home/BIApps/Oracle_BI1 work.dir= db.conn.sid.url=bitest.ifl.net:1521:TESTBI biacomp.user= biacomp.password= atg.db.seed.url= db.sys.user=sys db.sys.password=Manager123

Update FSM

Section 3.3.6 of the guide e51478

Go to folder: /home/oracle/opt/OBI_Home/BIApps/Oracle_BI1/biapps/tools/lib

Command for IFL Test Server

[oracle@BITEST lib]$ java -jar biappsrepositoryutil.jar upgradeFSM bi.oracle.home=/home/oracle/opt/OBI_Home/BIAPPS/Oracle_BI1 work.dir=/home/oracle/opt/temp biacomp.user=OBI_BIACOMP biacomp.password=Biapps123 db.conn.sid.url=bitest.ifl.net:1521:TESTBI fsm.db.seed.url=bitest.ifl.net:1521/TESTBI db.sys.user=sys db.sys.password=Manager123

Example from Document

java -jar biappsrepositoryutil.jar upgradeFSM bi.oracle.home==/home/oracle/opt/OBI_Home/BIApps/Oracle_BI1/ work.dir===/home/oracle/opt/temp biacomp.user=OBI_BIACOMP biacomp.password=password db.conn.sid.url=<host>:<database port>:<SID> fsm.db.seed.url=<host>:<database port>/<ServiceName> db.sys.user=sysuser db.sys.password=password

3.3.7 ConfiguringOracleBIApplications

Go to folder: /home/oracle/opt/OBI_Home/BIApps/Oracle_BI1/biapps/tools/bin

MDS Schema

MDS password from the OBI Installation time

3.3.8 BIApplication Components

3.3.9 InstallingODIStudio

3.3.9.2 Configuring User Access for ODI Studio

Copy cwallet.sso and jps-config-jse.xml from:

<MW_Home>/user_projects/domains/bifoundation_domain/odi-client-config/embedded

To:

<ODI_Home>/oracledi/client/odi/bin

Edit <ODI_Home>/oracledi/client/odi/bin/odi.conf by updating the JPS configuration file name as follows:

AddVMOption -Doracle.security.jps.config=./jps-config-jse.xml

Perform steps 1 and 2 on all instances of ODI Studio.

If the BIApplicationsAdministrator password or any ODI users' passwords were changed, administrators need to regenerate security files and redistribute the files to all instances of ODI Studio.

To regenerate security files: 1. Execute the wlst.sh script:

ORACLE_HOME/common/bin/wlst.sh <MW_Home>/Oracle_ BI1/bifoundation/install/createJPSArtifactsODI.py embedded --ADMIN_USER_NAME <Administrator> --DOMAIN_HOSTNAME <Hostname> --DOMAIN_PORT 7001 --DOMAIN_HOME_ PATH <MW Home>/user_projects/domains/bifoundation_domain

WhereADMIN_USER_NAME is the WebLogic Server administrator user. The updated JPS configuration file and credential wallet are created at location:

<MW_Home>/user_projects/domains/bifoundation_domain/odi-client-config/embedded

2. Copy these updated files to <ODI_Home>/oracledi/client/odi/bin on all ODI Studio instances.

Installing and Configuring Oracle BI Applications

Installing and Setting Up Oracle BI Applications 3-21

3. Make sure that the odi.conf file is edited correctly, as described in step 2 in the previous procedure for configuring user access for ODI Studio. The odi.conf file is located in <ODI_Home>/oracledi/client/odi/bin.

Cold Backup

Take a cold backup to secure your work.

Stop biapps

Shutdown db

Stop listener

Restart Machine

Make Backup folder

Change ownership and chmod

Tar –xzf <filename.tar.gz> /home/oracle/opt/OBI_Home

3.3.11 Copy Source file

Copy source files  BI_Oracle_Home/biapps/Oracle_BI1/biapps/etl directoryin a directory other than oracle home like u01/app/etl

4.1 Setting the Business Analytics Warehouse Connection in Oracle Data Integrator

Login to ODI Studio

Connect to Repository

User Name: biapps

Passowrd: biapps123

Select topology tab

Expand Technologies and then file

Double click biapps_dw_file

BIAPPS_DW_FILE./home/oracle/opt/OBI_Home/BIAPPS/Oracle_BI1/biapps/etl/...

Change Paths

For Configuration Manager

http://192.168.1.33:9704/biacm

Login: biapps

Password: biapps123

Click on Define New Business Intelligence Application Instance

Click on + icon

Product line Oracle E Business Suite

Choose product line version Release E Business Suite 12.1.3

Service instance name: <Sid name of test ebs machine>

Description: <test ebs Instance>

Data Source Number: 1

Click Next

Give Server name: EBSR 1213

Jdbc driver: oracle:jdbc:oracle

JDBC URL: Jdbc:oracle:thin:@prodtest:1526:prodtest

Database username: apps

Password: <apps user password>

Click on technology file system

ODI Server name: <ODI_Server>

Host name: BI Test <BI Server machine host name>

Path To File: ……………..data_files/src_files/EBS_12.1.3

Click on DONE

Click on Manage Business Intelligence Applications (Link on left side)

Select below mentioned modules

·         Oracle Financial analysis

·         Supply chain and order management analysis

·         Procurement and spend analytics

·         Oracle ales Analytics

·         Oracle manufacturing analytics

·         Oracle Enterprise Asset Management

·         Oracle Human Resource Analytics

Click Save

Click (Second Tab)

Click save

Managed Preferred Currency (Link on Left Side)

Pending

Manage Language Warehouse (Link on Left Side)

No Changes Required

Take back up of the repository stored in oracle_bi1 folder

Oracle BI Apps 11.1.1.8 Installation Guide Tutorial, Oracle BI Apps Tutorial 11.1.1.8.