Contact us

R12.1 Installation | Database on remote NFS storage

This is just my personal experience in installing Oracle Application R12.1 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

Resource Materials

Document id: 761564.1 <-- OS PREPARATION
Document id: 798258.1 <-- latest rapid install patch
Part No. E12842-02 <-- ORACLE APPLICATION INSTALLATION

These are our monut points

/u01 - local FS
/u02 - NFS mount FS

Requirements

Oracle Enterprise Linux Operationg System you download the software here.
Oracle Application R12.1 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

kernel.sem = 256 32000 100 142
fs.file-max = 131072
kernel.shmall = 2097152

# Half the size of the physical memory (in bytes)
kernel.shmmax = 2147483648

kernel.shmmni = 4096
kernel.msgmax = 8192
kernel.msgmnb = 65535
kernel.msgmni = 2878
net.core.rmem_max = 4194304
net.core.wmem_max = 262144
net.core.wmem_default = 262144
net.core.rmem_default = 262144
net.ipv4.ip_local_port_range = 10000 65000

Package requirements

binutils-2.17.50.0.6-6.0.1.i3862
compat-glibc-2.3.4-2.26
gcc-4.1.2-14.el5
gcc-c++-4.1.2-14.el5
glibc-2.5-123
glibc-common-2.5-123
glibc-devel-2.5-12
libgcc-4.1.2-14.el53
libstdc++-devel-4.1.2-14.el5
libstdc++-4.1.2-14.el53
make-3.81-1.13
gdbm-1.8.0-26.2.13
libXp-1.0.0-8.1.el5
libaio-0.3.106-3.23
libgomp-4.1.2-14.el5
sysstat-7.0.0-3.el5
compat-libstdc++-296-2.96-138
compat-libstdc++-33-3.2.3-61
elfutils-libelf-devel-0.125
elfutils-libelf-devel-static-0.125
libaio-devel-0.3.106
unixODBC-2.2.11
unixODBC-devel-2.2.11
kernel-headers-2.6
compat-db
compat-libstdc++-egcs
compat-libcwait
compat-oracle-el5
openmotif21-2.1.30-11.EL5.i3861
xorg-x11-libs-compat-6.8.2-1.EL.33.0.1.i386

Notes:

- Download packages that are not included with the distribution at Oracle WebSite.
- Openmotif package version must be 2.1.30 other version will not work.
- GNU linker (ld) version 2.17 provided by Oracle is required for relinking the modules in Advanced Planning & Scheduling (MSC, MSO, MSR).

Software library Reqiurements

ar
gcc
g++
ld
ksh
make
X Display Server

Setting the Environment

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

PATCH FOR HTTP

Download and apply the patch 6078836 from OracleMetaLink to fix an issue with the Oracle HTTP Server bundled with the E-Business Suite technology stack. Perform the following command as root on your system for patch installation.

- user: root
- unzip p6078836_101330_LINUX.zip
- cd 6078836
- chmod 755 libdb.so.2
- cp libdb.so.2 /usr/lib

Link to Motif library for Oracle Application Server 10.1.2

# unlink /usr/lib/libXtst.so.6
# ln -s /usr/X11R6/lib/libXtst.so.6.1 /usr/lib/libXtst.so.6

Note:

If ldconfig is ran then it overides the link above thus needs to re link it after running the command.

Installing Oracle Application R12.1

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

We need to assume that you are using the following partitions

/u01 - locally partitioned during installation
/u02 - locally created directory wherein we will mount our remotely shared disk space.

First is we need to determine the shared name from our remote storage. We need to execute this command

showmount -e <nfs shared storage server>

Then mount it using this command

mount -o rw,bg,hard,nointr,tcp,vers=3,timeo=600,rsize=32768,wsize=32768,actimeo=0,suid <nfs shared storage server>:/vol/oracle_u02 /u02

Now we are ready to install Oracle Application EBS R12.1

Please follow the steps in installign oracle application using Part No. E12842-02
Take note on the location of the Database tier. Database tier must reside on /u02 and application tier must be installed on /u01. Also take note of the permissions of each folder/directory.

Opatch

If you have issues with Opatch you may reffer to document id: 437026.1

opatch lsinventory -invPtrloc <path to oraInst.loc>

Access Applet

http://<hostname>.domain-name:8000/forms/frmservlet

Environment Variables

Application Tier

. /u01/application/<SID>/apps/apps_st/appl/admin/adovars.env
. /u01/application/<SID>/inst/apps/<SID>_<hostname>/ora/10.1.2/<SID>_<hostname>.env
. /u01/application/<SID>/inst/apps/<SID>_<hostname>/ora/10.1.3/<SID>_<hostname>.env
. /u01/application/<SID>/apps/apps_st/appl/APPS<SID>_<hostname>.env
export PATH=/u01/application/<SID>/apps/tech_st/10.1.3/OPatch/:$PATH

Database Tier

. /u02/oracle/<SID>/db/tech_st/11.1.0/<SID>_<hostname>.env
export PATH=/u02/oracle/<SID>/db/tech_st/11.1.0/OPatch:$PATH

Start Application Script

#!/bin/bash
if [[ $EUID -ne 9910 ]]; then
echo "This script must be run as application user" 1>&2
exit 1
fi
echo "Starting Oracle Application service..."
/u01/application/PROD/inst/apps/PROD_production/admin/scripts/adstrtal.sh apps/apps

Stop Application Script

#!/bin/bash
if [[ $EUID -ne 9910 ]]; then
echo "This script must be run as application user" 1>&2
exit 1
fi
echo "Ready to stop Oracle application"

/u01/application/PROD/inst/apps/PROD_production/admin/scripts/adstpall.sh apps/apps

Stop Database Script

#!/bin/bash
if [[ $EUID -ne 9911 ]]; then
echo "This script must be run as oracle user" 1>&2
exit 1
fi
echo "Ready to stop database and listener"
sleep 2

/u02/oracle/PROD/db/tech_st/11.1.0/appsutil/scripts/PROD_production/addlnctl.sh stop PROD
/u02/oracle/PROD/db/tech_st/11.1.0/appsutil/scripts/PROD_production/addbctl.sh stop

 

Start Database Script

#!/bin/bash
if [[ $EUID -ne 9911 ]]; then
echo "This script must be run as oracle user" 1>&2
exit 1
fi
echo "Starting Oracle Database 11g"
sleep 2

/u02/oracle/PROD/db/tech_st/11.1.0/appsutil/scripts/PROD_production/addbctl.sh start

echo "Starting Oracle LISTENER"
sleep 2

/u02/oracle/PROD/db/tech_st/11.1.0/appsutil/scripts/PROD_production/addlnctl.sh start PsROD

Please run the script below as application user after a successful installation.

SQL> exec fnd_stats.gather_schema_statistics('ALL')

NOTES:

  • Oracle Application (E-Business Suite) may have issues at some point. In application tier, concurrent request might be very slow, application it self may be very slow, and multiple instances of Standard Manager might that are not defined are present. In database tier, looking at alert.log we may find TNS issues followed by "ORA-609 : opiodr aborting process unknown ospid".

    To solve this issues please check if the DNS IP address entries of resolv.conf can be ping. Replace all entries that cannot be ping with a good DNS IP address then re-test the issue. Application tier and database tier must be shutdown before doing the re-test.

    That's it!
  • Install binutils from Oracle website to prevent future issues when patching the application and database tiers. Please check document id 751250.1 and 402310.1 for additional information.
CHANGELOG:

October 2, 2009 - Added exec to tweak Oracle Application for faster query.
September 7, 2009 - Added note regarding ORA-609
February 19, 2010 - noted to install binutils found in Oracle website.


Bookmark and Share RSS News Feed