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:

o must know on how to start and stop the database

o 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 LinuxBefore 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 PreparationThis 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:5options 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 65535fi

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 128fs.file-max = 65536net.ipv4.ip_local_port_range = 9000 65500net.core.rmem_default = 1048576net.core.rmem_max = 1048576net.core.wmem_default = 262144net.core.wmem_max = 262144net.ipv4.tcp_wmem = 262144 262144 262144net.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

argccg++ldkshmakeX Display Server

binutils-2.17.50.0.6-2.el5compat-libstdc++-33-3.2.3-61elfutils-libelf-0.125-3.el5elfutils-libelf-devel-0.125gcc-4.1.1-52gcc-c++-4.1.1-52glibc-2.5-12glibc-common-2.5-12glibc-devel-2.5-12glibc-headers-2.5-12libaio-0.3.106libaio-devel-0.3.106libgcc-4.1.1-52libstdc++-4.1.1libstdc++-devel-4.1.1-52.e15make-3.81-1.1sysstat-7.0.0compat-dbunixODBC-2.2.11unixODBC-devel-2.2.11libXp-1.0.0-8libXp-develcompat-libgcc-296openmotif21-2.1.30-11.EL5.i386.rpm  <<-- Must be the versionxorg-x11-libs-compat-6.8.2-1.EL.33.0.1.i386.rpm <<-- Must be the versioncompat-libstdc++-egcscompat-libcwaitcompat-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.xAs 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/binmkdir -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/bincp -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/stagezip -uv dboh0_appsutil appsutil/bin/adgetlnxver.shcd $STAGE_TOP/oraApps/Disk5/appl/stagezip -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 databaseaddbctl.sh database startup shutdown scriptaddlnctl.sh database listener Script

Sequence for Oracle database startup and shutdown

1. Shutdown databaseaddbctl.sh stopaddlnctl.sh stop

2. Start databaseaddlnctl.sh startaddbctl.sh start

Start / Shudown application

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

Sequence for Oracle Application startup and shutdown

1. Shutdown applicationadstpall.sh Stop

2. Start Applicationadstrtal.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.logappltop 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