Tuesday 12 May 2015

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.1Opens a new window 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.
Posted by at No comments:
Subscribe to: Posts (Atom)