Contact us

Install Oracle Applicarion 11.5.10.2 on Oracle Enterprise Linux 5.2

This is just my personal experience in installing Oracle Application R12.0.4 and is not intended as a replacement of the original Oracle Application documentation. A brief summary are as follows:

  1. Install the Operating System.
  2. Prepare the Operating system prior to installation of Oracle Database and Application.
  3. Install Oracle
  4. Maintenance:
    • must know on how to start and stop the database
    • must know on how to start and stop the application

Requirements:
Oracle Enterprise Linux Operationg System you download the software here.
Oracle Application 11.5.10.2 you download the software here.

Installing Oracle Enterprise Linux

Before installing Oracle Application we need to select a host operating system for our database and application. For our documentation Oracle Enterprise Linux a clone of RHEL will be selected as host operating system for our oracle database and application.

Desktop Environments
- GNOME Desktop Environment

Applications
- Editors
- Graphical Internet
- Text-based Internet

Developement
- Developement Libraries
- Development Tools
- GNOME Software Developement
- Legacy Software Developement
- X Software Developement

Servers
- DNS Name Server
- FTP Server
- Printing Support

Base System
- Administration Tools
- Base
- Java
- Legacy Software Support
- System Tools
- X Windows System

*** After boot ***
* Firewall
- Disabled
* SELinux
- Disabled
* Kdump
- Don't check the box

Operating System Preparation

This will focus on the preparation of Oracle Application in operating system tier. Not configuring the operating system tier may cause performance issue on database after installation of the Oracle Application. So please take note on the configuration of the operating system tier for database optimal performance.

DNS resolver parameters

Append to file /etc/resolv.conf

options attempts:5
options timeout:15

Append to /etc/security/limits.conf

* hard nofile 65535
* soft nofile 4096
* hard nproc 16384
* soft nproc 2047

Add the following line in the /etc/pam.d/login file

session required pam_limits.so

Add the following lines to the /etc/profile

if [ $USER = "oracle" ]; then
ulimit -u 16384
ulimit -n 65535
fi

Modifying the Port Range Values

Append the following to /etc/sysctl.conf

# From Oracle Document ID: 419646.1

kernel.shmmni = 4096
kernel.sem = 250 32000 100 128
fs.file-max = 65536
net.ipv4.ip_local_port_range = 9000 65500
net.core.rmem_default = 1048576
net.core.rmem_max = 1048576
net.core.wmem_default = 262144
net.core.wmem_max = 262144
net.ipv4.tcp_wmem = 262144 262144 262144
net.ipv4.tcp_rmem = 4194304 4194304 4194304

Setting the Environment

Perform the following tasks to set the environment before you run Rapid Install.

1. For Oracle Enterprise Linux 5 and Red Hat Enterprise Linux 5 only :

# ln -s /usr/bin/ld215 /usr/bin/ld

Download and apply the OS library patch 6078836 from OracleMetaLink and create the following symbolic link:

# ln -s /usr/lib/libdb.so.2 /usr/lib/libdb.so.3

Create Oracle users

[root @localhost]# groupadd -g 9910 dba
[root @localhost]# useradd -u 9910 -g 9910 applmgr <-- application user   
[root @localhost]# useradd -u 9911 -g 9910 oracle  <-- database user

Software Requirements

ar
gcc
g++
ld
ksh
make
X Display Server

binutils-2.17.50.0.6-2.el5
compat-libstdc++-33-3.2.3-61
elfutils-libelf-0.125-3.el5
elfutils-libelf-devel-0.125
gcc-4.1.1-52
gcc-c++-4.1.1-52
glibc-2.5-12
glibc-common-2.5-12
glibc-devel-2.5-12
glibc-headers-2.5-12
libaio-0.3.106
libaio-devel-0.3.106
libgcc-4.1.1-52
libstdc++-4.1.1
libstdc++-devel-4.1.1-52.e15
make-3.81-1.1
sysstat-7.0.0
compat-db
unixODBC-2.2.11
unixODBC-devel-2.2.11
libXp-1.0.0-8
libXp-devel
compat-libgcc-296
openmotif21-2.1.30-11.EL5.i386.rpm  <<-- Must be the version
xorg-x11-libs-compat-6.8.2-1.EL.33.0.1.i386.rpm <<-- Must be the version
compat-libstdc++-egcs
compat-libcwait
compat-oracle-el5

Completing Preinstallation Tasks

For Oracle Enterprise Linux 5, Red Hat Enterprise Linux 5 users, the LD_ASSUME_KERNEL environment variable should be unset before starting the installation. The installation fails when the LD_ASSUME_KERNEL variable is set by the adgetlnxver.sh file during the course of the installation. Patch 6365595 contains the fix for adgetlnxver.sh file. The procedure below is a guideline for replacing the adgetlnxver.sh file in the Oracle Applications 11i shiphome.

Create Stage Area and patch for RHEL 5.x

As root please append this to your .bashrc

export KSH_VERSION='@(#)PD KSH v5.2.14 99/07/13.2'
export STAGE_TOP=/u01/Stage11i

Create the following directories in the stage area.

mkdir -p $STAGE_TOP/oraDB/Disk3/db/stage/appsutil/bin
mkdir -p $STAGE_TOP/oraApps/Disk5/appl/stage/bin

Copy the adgetlnxver.sh file in the patch 6365595 to the following directories created in earlier step.

cp -p 6365595-location/ad/bin/adgetlnxver.sh $STAGE_TOP/oraDB/Disk3/db/stage/appsutil/bin
cp -p 6365595-location/ad/bin/adgetlnxver.sh $STAGE_TOP/oraApps/Disk5/appl/stage/bin

Update the zip archive with the fix (adgetlnxver.sh file).

cd $STAGE_TOP/oraDB/Disk3/db/stage
zip -uv dboh0_appsutil appsutil/bin/adgetlnxver.sh
cd $STAGE_TOP/oraApps/Disk5/appl/stage
zip -uv ad_CORE bin/adgetlnxver.sh

Install

Follow Part No. B19296-03

Post install

Apply patch 6365595

Maintenance

NOTE: <SID>: Oracle System ID(UPPER CASE)
<sid>: Oracle System ID(lower case)

Set the proper environment

# Add to bashrc for application user
. /<install-path>/<sid>/<sid>appl/APPS<SID_hostname>.env
. /<install-path>/<sid>/<sid>appl/APPSORA.env

# Add to bashrc for database user
. /<install-path>/<sid>/<sid>db/9.2.0/<SID_hostname>.env

Start and shutdown scripts

# Start / Shutdown database
addbctl.sh database startup shutdown script
addlnctl.sh database listener Script

Sequence for Oracle database startup and shutdown

1. Shutdown database
addbctl.sh stop
addlnctl.sh stop

2. Start database
addlnctl.sh start
addbctl.sh start

Start / Shudown application

adstpall.sh Stop All Middle/Application Tier
adstrtall.sh Start All Middle/Application Tier

Sequence for Oracle Application startup and shutdown

1. Shutdown application
adstpall.sh Stop

2. Start Application
adstrtal.sh Start

Maintenance: Scripts

start_application:
/<install-path>/<sid>/<sid>comn/admin/scripts/<SID_hostname>/adstrtal.sh apps/apps

stop_application:
/<install-path>/<sid>/<sid>comn/admin/scripts/<SID_hostname>/adstpall.sh apps/apps

start_oracle:
/<install-path>/<sid>/<sid>db/9.2.0/appsutil/scripts/<SID_hostname>/addbctl.sh start
/<install-path>/<sid>/<sid>db/9.2.0/appsutil/scripts/<SID_hostname>/addlnctl.sh start LISTENER

stop_oracle:
/<install-path>/<sid>/<sid>db/9.2.0/appsutil/scripts/<SID_hostname>/addbctl.sh stop
/<install-path>/<sid>/<sid>db/9.2.0/appsutil/scripts/<SID_hostname>/addlnctl.sh stop LISTENER

Log files

database logfile - /<sid>/<sid>db/9.2.0/appsutil/log/<SID_hostname>/02271009.log
appltop logfile -  /<sid>/<sid>appl/admin/<SID_hostname>/log/02271009.log

TURN OFF AUTHENTICATION

To access dev60cgi/f60cgi authentication must be turned off:
java oracle.apps.fnd.security.AdminAppServer apps/apps_password AUTHENTICATION OFF DBC=$FND_SECURE/<sid>.dbc

java oracle.apps.fnd.security.AdminAppServer apps/apps AUTHENTICATION OFF DBC=/<sid>/<sid>appl/fnd/11.5.0/secure/<SID_hostname>/<sid>.dbc

You may now access http://<hostname.domain>:<port>/dev60cgi/f60cgi

NOTE:

If errors from discovery are found pleaes read 313418.1 and 564174.1 to upgrade discovery. Upgrading the database to 10gR2 please see document id 362203.1

That's it hope you learned some. Feel free to contact the author any time.

Bookmark and Share RSS News Feed