INSTALLATION OF R12.1.1 ON OEL 5 UPDATE 7
1) SYSTEM REQUIREMENTS
1.1) Space required
The minimum required installation size of Oracle E-Business
Suite R12.1.1 is:
90 GB for a fresh install with
a production database:
Application tier file system – 35 GB
Database tier file system – 55 GB
1.2) Users and Group
creation
groupadd -g 500 dba
useradd -g dba -d /home/oracle oracle
1.3) Directory
Structure and permissions
mkdir /u01/oracle/UAT
chown –R oracle:dba
/u01/oracle/UAT/
1.4) Packages and Patch required
Packages
The following maintenance tools must be installed on all
machines, and their locations specified both in the PATH of the account that
runs Rapid Install and in the PATH of the accounts that will own the database
tier and application tier file systems.
·
ar
·
gcc
·
g++
·
ld
·
ksh
·
make
·
X Display Server
VERIFICATION :
[root@orauat ~]# which ar
/usr/bin/ar
[root@orauat ~]# which gcc
/usr/bin/gcc
[root@orauat ~]# which g++
/usr/bin/g++
[root@orauat ~]# which ld
/usr/bin/ld
[root@orauat ~]# which ksh
/bin/ksh
[root@orauat ~]# which make
/usr/bin/make
The following packages (or versions of packages) are not part of the OS
distribution media and must be downloaded separately (from
http://oss.oracle.com/projects/compat-oracle/files/Enterprise_Linux/ for both
Oracle Linux 5 and RHEL 5) and installed manually:
·
openmotif22-2.2.3-18.i386.rpm
( openmotif21-2.1.30-11.EL5.i386 or higher)
[root@orauat ~]# rpm -qa|grep -i openmotif
openmotif22-2.2.3-18
·
xorg-x11-libs-compat-6.8.2-1.EL.33.0.1.i386
·
perl 5.0053 or higher ( check by ' perl -v ' what is the
version isntalled )
[root@orauat ~]# perl -v
This is perl, v5.8.8 built for x86_64-linux-thread-multi
The following packages
must be installed from the Oracle Linux 5 or RHEL 5 distribution media:
·
gcc-4.1.2-14.el5.x86_64
·
gcc-c++-4.1.2-14.el5.x86_64
·
glibc-2.5-18.i686 (32-bit)
·
glibc-2.5-18.x86_64
·
glibc-common-2.5-18.x86_64
·
glibc-devel-2.5-18.i386 (32-bit)
·
glibc-devel-2.5-18.x86_64
·
libgcc-4.1.2-14.el5.i386
·
libgcc-4.1.2-14.el5.x86_64
·
libstdc++-devel-4.1.2-14.el5.i386
·
libstdc++-devel-4.1.2-14.el5.x86_64
·
libstdc++-4.1.2-14.el5.i386
·
libstdc++-4.1.2-14.el5.x86_64
·
make-3.81-1.1.x86_64
·
gdbm-1.8.0-26.2.1.i386
·
gdbm-1.8.0-26.2.1.x86_64
·
libXp-1.0.0-8.1.el5.i386
·
libXp-1.0.0-8.1.el5.x86_64
·
libaio-0.3.106-3.2.i386
·
libaio-0.3.106-3.2.x86_64
·
libgomp-4.1.2-14.el5.x86_64
·
sysstat-7.0.0-3.el5.x86_64
·
util-linux-2.13-0.45.el5.x86_64
·
compat-libstdc++-296-2.96-138.i386
·
compat-libstdc++-33-3.2.3-61.i386
Additionally, the
following RPMs are required for an 11gR1 Database (which is bundled with the
12.1.1 release) on the database tier:
·
compat-libstdc++-33-3.2.3-61.x86_64
·
elfutils-libelf-devel-0.125-3.el5.x86_64
·
elfutils-libelf-devel-static-0.125-3.el5.x86_64
·
libaio-devel-0.3.106-3.2.x86_64
·
unixODBC-2.2.11-7.1.i386
·
unixODBC-devel-2.2.11-7.1.i386
·
unixODBC-2.2.11-7.1.x86_64
·
unixODBC-devel-2.2.11-7.1.x86_64
·
kernel-headers-2.6.18-8.el5.x86_64
>> To install a
new package use command
rpm -ivh package.rpm
>> To check
availability of the package
rpm -qa package.rpm
JDK 6 is bundled with
Oracle E-Business Suite version 12.1.1 and is NOT REQUIRED to be installed
separately.
1.5) Configure
kernel parameters
Set using the following entry in the /etc/sysctl.conf file:
kernel.sem = 256 32000 100 142
|
kernel.shmmax
|
Half the
size of the physical memory (in bytes), and at least 21474836482
|
|
kernel.shmmni
|
4096
|
|
kernel.msgmax
|
8192
|
|
kernel.msgmnb
|
65535
|
|
kernel.msgmni
|
2878
|
|
fs.file-max
|
131072
|
|
|
|
|
net.core.rmem_default
|
262144
|
|
net.core.rmem_max
|
4194304
|
|
net.core.wmem_default
|
262144
|
|
net.core.wmem_max
|
262144
|
1.5.2) Edit /etc/security/limits.conf
vi /etc/security/limits.conf
Add the below entries
* hard nofile 65536
* soft nofile 4096
* hard nproc
16384
* soft nproc
2047
1.5.3) Edit /etc/resolv.conf
Two Domain Name System (DNS) resolver parameters (timeout and
attempts) are set by default to low values when the operating system is
installed. These low values may cause attempted network connections to an
Oracle database to fail. If this happens, add or update the following entries
to these minimum settings in the /etc/resolv.conf file on each server node.
options attempts:5
options timeout:15
1.5.4) Verify /etc/hosts
Verify that the /etc/hosts
file is formatted as follows:
127.0.0.1
localhost.localdomain localhost
[ip_address]
[node_name].[domain_name] [node_name]
192.168.125.66
orauat.transworld.co orauat
1.5.5) Verify /etc/sysconfig/network
Verify that the /etc/sysconfig/network file is formatted as
follows:
HOSTNAME=[node_name].[domain_name]
1.5.6) Verify /etc/sysconfig/networking/profiles/default/network
If the /etc/sysconfig/networking/profiles/default/network file
exists, remove it.
1.5.7) Run sysctl -p
After editing the files, use the "sysctl -p" command
or restart the system to invoke the new settings.
1.6.1) Link to Motif library in Oracle Application
Server 10.1.2 (on Oracle Linux 5 and RHEL 5 only)
Perform the following command (as root on your system) to update
a required link to a Motif library prior to relinking or patching the 10.1.2
Application Server Oracle Home:
#
unlink /usr/lib/libXtst.so.6
# ln -s /usr/X11R6/lib/libXtst.so.6.1 /usr/lib/libXtst.so.6
Creating Stage area
There are
two ways we can create stage for R12
1. Stage using script adautostage.pl from start here CD
2. Manual
stage - create directories and copy media as listed below
Create /u01/stage/R12
and copy all R12 software zip files in it
Login as root
user and run rapidwiz from the staging
#cd /u01/stage/R12/startCD/Disk1/rapdiwiz
#./rapidwiz
Perform the
installation as shown below
v
We
might get following errors:
Apache: libdb.so.2 errors
after Linux Upgrade to Redhat 5U7 (5.7) :
Error
[applprod@oraclerh5pw7 scripts]$ ./adapcctl.sh
status
You are running adapcctl.sh version
120.7.12010000.2
Checking status of OPMN managed Oracle HTTP
Server (OHS) instance ...
Processes in Instance:
PROD_oraclerh5pw7.oraclerh5pw7.home.co.za
---------------------------------+--------------------+---------+---------
ias-component
| process-type |
pid | status
---------------------------------+--------------------+---------+---------
OC4JGroup:default_group
| OC4J:oafm |
16329 | Alive
OC4JGroup:default_group |
OC4J:forms | 16256
| Alive
OC4JGroup:default_group |
OC4J:oacore | 16030 |
Alive
HTTP_Server
| HTTP_Server
| N/A | Down
adapcctl.sh: exiting with status 0
adapcctl.sh: check the logfile
/u01/PROD/inst/apps/PROD_oraclerh5pw7/logs/appl/admin/log/adapcctl.txt for more
information ...
[applprod@oraclerh5pw7 scripts]$ ./adapcctl.sh
start
You are running adapcctl.sh version
120.7.12010000.2
Starting OPMN managed Oracle HTTP Server
(OHS) instance ...
opmnctl: opmn is already running.
opmnctl: starting opmn managed processes...
================================================================================
opmn id=oraclerh5pw7.home.co.za:6220
0 of 1 processes
started.
ias-instance
id=PROD_oraclerh5pw7.oraclerh5pw7.home.co.za
++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
--------------------------------------------------------------------------------
ias-component/process-type/process-set:
HTTP_Server/HTTP_Server/HTTP_Server/
Error
--> Process
(index=1,uid=18825576,pid=17159)
failed to
start a managed process after the maximum retry limit
Log:
/u01/PROD/inst/apps/PROD_oraclerh5pw7/logs/ora/10.1.3/opmn/HTTP_Server~1.log
adapcctl.sh: exiting with status 0
adapcctl.sh: check the logfile
/u01/PROD/inst/apps/PROD_oraclerh5pw7/logs/appl/admin/log/adapcctl.txt for more
information ...
[applprod@oraclerh5pw7 scripts]$
--------
11/09/08 09:33:49 Start process
--------
/u01/PROD/inst/apps/PROD_oraclerh5pw7/ora/10.1.3/Apache/Apache/bin/apachectl
startssl: execing httpd
/u01/PROD/apps/tech_st/10.1.3/Apache/Apache/bin/httpd:
error while loading shared libraries: libdb.so.2:
cannot open shared object file: No such file or directory
Solution:
On Redhat 5.5, libdb.so.2 was provided by
compat-db-4.1.25-9 (x86_64) and compat-db-4.1.25-9 (i386), which were also
upgraded when Linux was upgraded, but libdb.so.2 is not provided anymore by the
upgraded version of lobdb
[applprod@oraclerh5pw7 scripts]$ rpm -qa
--queryformat "%{NAME}-%{VERSION}-%{RELEASE} (%{ARCH})\n" | grep
compat-db
compat-db-4.2.52-5.1 (x86_64)
compat-db-4.2.52-5.1 (i386)
[applprod@oraclerh5pw7 scripts]$ rpm -ql
compat-db-4.2.52-5.1 | grep libdb
/lib64/libdb-4.1.so
/lib64/libdb-4.2.so
/lib64/libdb_cxx-4.1.so
/lib64/libdb_cxx-4.2.so
/lib/libdb-4.1.so
/lib/libdb-4.2.so
/lib/libdb_cxx-4.1.so
/lib/libdb_cxx-4.2.so
[applprod@oraclerh5pw7 scripts]$
[root@oraclerh5pw7 ~]# rpm -q --whatprovides
libdb.so.2
no package provides libdb.so.2
[root@oraclerh5pw7 ~]#
On a working box, it shows the older version
of compatdb provides this libdb.so.2
/home/asbi/scripts >rpm -q --whatprovides
libdb.so.2
compat-db-4.1.25-9
/home/asbi/scripts >
Solution:
Install this RPM for your O/S version, to get
libdb.so.2 back in place again:
rpm -Uhv db1-1.85-8.i386.rpm
OR, do the below softlink
ln -s /usr/lib/libgdbm.so.2.0.0
/usr/lib/libdb.so.2
Implementation:
[root@oraclerh5pw7 repo]# ls -l
/usr/lib/libgdbm.so.2
lrwxrwxrwx 1 root root 16 Jun 7
16:16 /usr/lib/libgdbm.so.2 -> libgdbm.so.2.0.0
[root@oraclerh5pw7 repo]# ln -s
/usr/lib/libgdbm.so.2 /usr/lib/libdb.so.2
[root@oraclerh5pw7 repo]#
Test:
Forms errors we may face.
FRM-92101 there was a failure in form Server startup
There was on error in accessing ERP Forms though all
per-requisites exists on the system.
I've encountered this issue on freshly configured system.
In earlier post I've discussed about this issue:
This issue will solved only if yo will Install same version
of openmotif as mentioned in Installation document. If you have higher version
of rpm then its simply not going to workout.
Required version of openmotif rpm - openmotif21-2.1.30-11.EL5.i386.rpm
Actual version exists on system - openmotif22-2.2.3-18.EL5.i386.rpm
If you do not want to Install the old version of rpm and want to access the
forms using the same rpm "openmotif22-2.2.3-18.EL5.i386.rpm" then
this is the post/article which you're looking for :
Formerrormessage:
Application Error log:
12/03/24 13:56:12.509 formsweb:
Forms session <1> aborted: runtime process failed during startup with
errors /u01/applR12/PR
ODERP/apps/tech_st/10.1.2/bin/frmweb:
error while loading shared libraries: libXm.so.2: cannot open shared object
file: No s
uch file or directory
12/03/24 13:56:12.510 formsweb:
Forms session <1> exception stack trace:
oracle.forms.engine.RunformException:
Forms session <1> failed during startup: no response from runtime process
at
oracle.forms.servlet.RunformProcess.connect(Unknown Source)
at
oracle.forms.servlet.RunformProcess.dataToRunform(Unknown Source)
at
oracle.forms.servlet.RunformSession.dataToRunform(Unknown Source)
at
oracle.forms.servlet.ListenerServlet.doPost(Unknown Source)
at
javax.servlet.http.HttpServlet.service(HttpServlet.java:763)
at
javax.servlet.http.HttpServlet.service(HttpServlet.java:856)
at com.evermind[Oracle Containers for
J2EE 10g (10.1.3.4.0) ].server.http.ServletRequestDispatcher.invoke(ServletReq
uestDispatcher.java:713)
at com.evermind[Oracle Containers for
J2EE 10g (10.1.3.4.0) ].server.http.ServletRequestDispatcher.forwardInternal(S
ervletRequestDispatcher.java:370)
at com.evermind[Oracle Containers for
J2EE 10g (10.1.3.4.0) ].server.http.HttpRequestHandler.doProcessRequest(HttpRe
questHandler.java:871)
at com.evermind[Oracle Containers for
J2EE 10g (10.1.3.4.0) ].server.http.HttpRequestHandler.processRequest(HttpRequ
estHandler.java:453)
at com.evermind[Oracle Containers for
J2EE 10g (10.1.3.4.0) ].server.http.AJPRequestHandler.run(AJPRequestHandler.ja
va:313)
at com.evermind[Oracle Containers for
J2EE 10g (10.1.3.4.0) ].server.http.AJPRequestHandler.run(AJPRequestHandler.ja
va:199)
at
oracle.oc4j.network.ServerSocketReadHandler$SafeRunnable.run(ServerSocketReadHandler.java:260)
at com.evermind[Oracle Containers for
J2EE 10g (10.1.3.4.0) ].util.ReleasableResourcePooledExecutor$MyWorker.run(Rel
easableResourcePooledExecutor.java:303)
at
java.lang.Thread.run(Thread.java:619)
12/03/24 14:02:56.466 formsweb:
10.1.3.4.0 Stopped
Its looking for the library file "libXm.so.2" in /usr/lib which does
not exists on the server.
The rpm openmotif22-2.2.3-18.EL5.i386.rpm will deliver the higher version of
library file then expected:
[root@erpappl2 lib]# ls -l libXm.so*
lrwxrwxrwx 1 root root 14 Mar 24 14:22 libXm.so ->
libXm.so.4.0.1
lrwxrwxrwx 1 root root 14 Mar 24 14:22 libXm.so.3 ->
libXm.so.3.0.2
-rwxr-xr-x 1 root root 2542828 Jun 6 2007
libXm.so.3.0.2
lrwxrwxrwx 1 root root 14 Mar 24 14:22 libXm.so.4 ->
libXm.so.4.0.1
-rwxr-xr-x 1 root root 2637260 Nov 3 2010
libXm.so.4.0.1
If we Install rpm openmotif21-2.1.30-11.EL5.i386.rpm then it will generate
library libXm.so.2.
Solution:
copy library file
[root@erpappl2 root]#cd /usr/lib
[root@erpappl2 lib]#cp libXm.so.3.0.2 libXm.so.2.0.2
create link
[root@erpappl2 lib]#ln -s libXm.so.2.0.2 libXm.so.2
After modification restart your middle tiers your forms access should work as
expected with no more error messages.
UPGRADATION OF R12.1.1 to R12.1.3
Download
and unzip the below patches
p9239090_R12_LINUX_4of6.zip
p9239090_R12_LINUX_5of6.zip
p9239090_R12_LINUX_6of6.zip
p9239095_R12_GENERIC.zip
p9817770_R12.ATG_PF.B_R12_LINUX.zip
p9239089_R12.AD.B_R12_LINUX.zip
p9239090_R12_LINUX_1of6.zip
p9239090_R12_LINUX_2of6.zip
p9966055_R12.FND.B_R12_GENERIC.zip
p9239090_R12_LINUX_3of6.zip
Enable
maintenance mode using adadmin
Apply Patch 9239089
Pre-
install steps
Create
$ORACLE_HOME/appsutil/admin on the database server.
mkdir -p
$ORACLE_HOME/appsutil/admin
Copy
adgrants.sql (UNIX) from this patch directory to
$ORACLE_HOME/appsutil/admin.
Set the
environment to point to ORACLE_HOME on the database server.
Use
SQL*Plus to run the script:
$ sqlplus
/nolog
SQL>
@$ORACLE_HOME/appsutil/admin/adgrants.sql APPS
Apply patch 9239089 using adpatch
utility
Apply patch 9239090 using adpatch
utility
Prereq
patch - R12.AD.B.delta.3 (9239089) - already applied
Apply patch
9239095 - Oracle E-Business Suite Online Help for 12.1.3 Release Update Pack
Post-Update
Steps
Apply
post-install Oracle E-Business Suite Applications Technology patches.
(Required)
Apply
mandatory Patch 9817770 (9817770:R12.ATG_PF.B [POST-R12.ATG_PF.B.DELTA.3
CONSOLIDATED PATCH].)
Apply
mandatory Patch 9966055 (9966055:R12.FND.B [TRANSLATED VERSION OF
FNDSCSGN
NOT LAUNCHED].)
Disable the maintenance mode
Update database tier nodes with the
Oracle E-Business Suite Release 12.1.3 code level.
After you
have upgraded to Oracle E-Business Suite Release 12.1.3, perform the following
post-update steps to update all database tier nodes with the code level,
provided by Oracle E-Business Suite Release 12.1.3:
Application
tier:
As the oracle
user, run the environment file
Run
AutoConfig on the APPL_TOP
Run the
admkappsutil.pl utility to create the file appsutil.zip in the
<INST_TOP>/admin/out
directory.
perl
$AD_TOP/bin/admkappsutil.pl
Database
tier:
As the
ORACLE user, run the environment file
cd
<RDBMS ORACLE_HOME>
Copy or FTP
the appsutil.zip file to the <RDBMS ORACLE_HOME>
Uncompress
appsutil.zip under the <RDBMS ORACLE_HOME>
cd
<ORACLE_HOME>
unzip appsutil.zip
• Run
AutoConfig on the <RDBMS ORACLE_HOME>
perl
$ORACLE_HOME/appsutil/bin/adbldxml.pl
cd
$ORACLE_HOME/appsutil/bin/
sh
adconfig.sh
Database
tier and application tier:
Re-run
adpreclone.pl on the database tier and the application tier. Since updates
included in Oracle E-Business Suite Release 12.1.3 were applied to the system,
adpreclone must be run again to apply the updates to the clone directory
structures that were used during cloning.
perl
adpreclone.pl dbTier
perl adpreclone.pl
appsTier
Start the application services
cd
$ADMIN_SCRIPTS_HOME
sh
adstrtal.sh apps/apps
verify the application version
SQL>
select release_name from fnd_product_groups;
RELEASE_NAME
--------------------------------------------------
12.1.3
