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 2147483648²
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

#cd /u01/stage/R12/startCD/Disk1/rapdiwiz
#./rapidwiz

Perform the installation as shown below

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 ...

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

Oracle Apps DBA

Tuesday, 24 June 2014

Installation of Oracle EBS 12.1.1 and upgrade to 12.1.3

1) SYSTEM REQUIREMENTS

1.1) Space required

We might get following errors:

Apache: libdb.so.2 errors after Linux Upgrade to Redhat 5U7 (5.7) :

Forms errors we may face.

No comments:

Post a Comment