Install Oracle Applicarion R12.0.4 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:
- Install the Operating System.
- Prepare the Operating system prior to installation of Oracle Database and Application.
- Install Oracle
- 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 R12.0.4 you download the software here.
My test server specifications:
DELL SC440
- Processor = Intel Core 2 Duo 2Ghz
- RAM = 2gigs
- HDD = 250 GB
- Optical drive = DVD combo
Installing Oracle Enterprise Linux
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
DNS resolver parameters
Append to file /etc/resolv.conf
options attempts:5
options timeout:15
NOTE:
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!
Append to /etc/security/limits.conf
* hard nofile 65535
* soft nofile 4096
* hard nproc 16384
* soft nproc 2047
Link to Motif library for Oracle Application Server 10.1.2
[root @localhost]# unlink /usr/lib/libXtst.so.6
[root @localhost]# ln -s /usr/X11R6/lib/libXtst.so.6.1 /usr/lib/libXtst.so.6
Create Systems User for Oracle Application use
[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
Kernel Parameters
kernel.sem = 256 32000 100 142
kernel.shmmni = 4096
kernel.msgmni = 2878
fs.file-max = 65536
net.ipv4.ip_local_port_range = 10000 65000
net.core.rmem_default = 262144
net.core.rmem_max = 262144
net.core.wmem_default = 262144
net.core.wmem_max = 262144
Oracle Applications R12 OS Level Patch
Download and install patch 6078836 from metalink
Oracle Application R12 installation
[root@oracle etc]# /u01/StageR12/startCD/Disk1/rapidwiz/rapidwiz
Oracle Application Software Requirements
- ar
- gcc
- g++ <-- not default
- ld <-- version 2.17 provided by oracle must be installed for relinking modules
- ksh
- make
- X Display Server
- openmotif21-2.1.30 <-- must have the correct version
- xorg-x11-libs-compat <<-- not default :
- binutils
- compat-glibc
- gcc
- gcc-c++
- glibc
- glibc-common
- glibc-devel
- libgcc
- libstdc++-devel
- libstdc++
- gdbm
- libXp <<-- not default :: Location = <DVD>/Server/
- libaio
- libgomp
- sysstat <<-- not default :: Location = <DVD>/Server/
- compat-libstdc++-296
- compat-libstdc++-33
After installing the packages please run ldconfig -v
Link to Motif library for Oracle Application Server 10.1.2
[root @localhost]# unlink /usr/lib/libXtst.so.6
[root @localhost]# ln -s /usr/X11R6/lib/libXtst.so.6.1 /usr/lib/libXtst.so.6
Post installation
NOTE: <SID>: Oracle System ID(UPPER CASE)
<sid>: Oracle System ID(lower case)
Append to application applmgr .bashrc
. /<installed-path>/<sid>/apps/apps_st/appl/APPS<SID_hostname>.env
. /<installed-path>/<sid>/apps/apps_st/appl/<SID_hostname>.env
# Append to oracle user's .bashrc
. /<install-path>/<sid>/db/tech_st/10.2.0/<SID_hostname>.env
Maitenance
# Start EBS
/<install-path>/<sid>/inst/apps/<SID_hostname>/admin/scripts/adstrtal.sh apps/apps
# Stop EBS
/<install-path>/<sid>/inst/apps/<SID_hostname>/admin/scripts/adstpall.sh apps/apps
# Start Database
/<install-path>/<sid>/db/tech_st/10.2.0/appsutil/scripts/<SID_hostname>/addbctl.sh start
# Start listener
/<install-path>/<sid>/db/tech_st/10.2.0/appsutil/scripts/<SID_hostname>/addlnctl.sh start <sid>
# Stop listener
/<install-path>/<sid>/db/tech_st/10.2.0/appsutil/scripts/<SID_hostname>/addlnctl.sh stop <sid>
# Sop Database
/<install-path>/<sid>/db/tech_st/10.2.0/appsutil/scripts/<SID_hostname>/addbctl.sh stop
# Database logs
tail -f /<install-path>/<sid>/db/tech_st/10.2.0/admin/<SID_hostname>/bdump/alert_<sid>.log
That's it! Oracle Application R12 is now installed and is ready for testing.
NOTE:
If you are unable to login from http://host-name.domain-name:PORT/dev60cgi/f60cgi please do
java oracle.apps.fnd.security.AdminAppServer apps/apps_password AUTHENTICATION OFF DBC=$INST_TOP/appl/fnd/12.0.0/secure/<sid>.dbc
You may now login to
http://host-name.domain-name:PORT/dev60cgi/f60cgi
Click here for updates on Oracle Applications setup and issue resolution.
