Oracle Applications Upgrade from 12.1.1 to 12.1.3 ( With Database 11.1.0.7 )

Oracle Applications Upgrade from 12.1.1 to 12.1.3 ( With Database 11.1.0.7 )

The below steps outline the step by step actions to upgrade Oracle applications from 12.1.1 to 12.1.3

Bring down all the services and Take cold backup of the instance (Recommended)

Step.1
Modify Initialization Parameters:

_disable_fast_validate=TRUE
recyclebin=off
_pga_max_size

Use the following command to change the mentioned  parameters:

SQL> alter system set recyclebin=off scope=spfile;
System altered.
SQL> alter system set "_disable_fast_validate"=TRUE SCOPE=spfile;
System altered.
SQL> alter system set "_pga_max_size"=104857600 scope=spfile;

If you don't change the _pga_max_size to greater than 104857600. You may get the following error during upgrade.
ORA-04030: out of process memory when trying to allocate 822904 bytes
(pga heap,kco buffer)
ORA-07445: exception encountered: core dump [dbgtfdFileWrite()+48]
SIGSEGV] [ADDR:0xFFFFFFFF7FFC1C88] [PC:0x1063BD2D0] [Address not mapped
to object]

Step.2
Apply Database Patches
Please check and apply the below database patches.
For all UNIX/Linux platforms
7111245
7211965
7330434
7486407
7627743
7639602
7684818
8199107
8639653
8940108
9026927
9066130
9554727
9743057

For Linux x86-64, patch 7319922 contained within 7684818 was packaged incorrectly.

The new version of patch 7319922 has to be applied. Perform the following instructions:
Go to the 11.1.0.7 $ORACLE_HOME/inventory/oneoffs/7319922 directory.
Run "opatch rollback -id 7319922" to rollback patch 7319922.
Download the new version of patch 7319922 on My Oracle Support.
Go to the patch 7319922 directory.
Run "opatch apply"

Step.3
Techstack Upgrade:
A)Verify the 10.1.3.X  Oracle Home version and the required version is 10.1.3.4 or higher <Use Document 454811.1> (for

10.1.3.5 ) or <Document 728531.1> (for 10.1.3.4 ) to upgrade it

TO check the versions perform the below
----------------------------------------
cd $INST_TOP/ora/10.1.3
. ./$CONTEXT_NAME.env
$ORACLE_HOME/OPatch/opatch lsinventory -detail -invPtrLoc $ORACLE_HOME/oraInst.loc | egrep 'Oracle Application Server 10g|
Patch of Oracle Application Server 10g'
Note: Oracle Application Server 10g signifies the Base Install and
Patch of Oracle Application Server 10g signifies the Patchset on top of it
Example:
$ORACLE_HOME/OPatch/opatch lsinventory -detail -invPtrLoc $ORACLE_HOME/oraInst.loc | egrep 'Oracle Application Server 10g|
Patch of Oracle Application Server 10g'
Oracle Application Server 10g                                    10.1.3.0.0
Patch of Oracle Application Server 10g                           10.1.3.4.0

B)Verify the 10.1.2.X  Oracle Home version and the required version is 10.1.2.3 <Use Document 437878.1 to upgrade it.>

TO check the versions perform the below
----------------------------------------
Log-out and Re-Login, before performing the following steps.

$ORACLE_HOME/OPatch/opatch lsinventory -detail -invPtrLoc $ORACLE_HOME/oraInst.loc | egrep 'Oracle Application Server 10g|
Patch of Oracle Application Server 10g'
Note: Oracle Application Server 10g signifies the Base Install
Patch of Oracle Application Server 10g signifies the Patchset on top of it
Example:
$ORACLE_HOME/OPatch/opatch lsinventory -detail -invPtrLoc $ORACLE_HOME/oraInst.loc | egrep 'Oracle Application Server 10g|

Patch of Oracle Application Server 10g'
Oracle Application Server 10g                                    10.1.2.0.2
Patch of Oracle Application Server 10g                           10.1.2.3.0

Step.4
Applications upgrade

a)Apply R12.AD.B.DELTA.3 <Patch 9239089>

Usage:
------
1.Create $ORACLE_HOME/appsutil/admin on the database server.
2.Copy adgrants.sql (UNIX) from this patch directory to $ORACLE_HOME/appsutil/admin.
3.Set the environment to point to ORACLE_HOME on the database server.
4.Use SQL*Plus to run the script:
$ sqlplus /nolog
SQL> @$ORACLE_HOME/appsutil/admin/adgrants.sql APPLSYS

Apply the below patches using adpatch options:

-Enable maintenance mode

adpatch defaultsfile=$APPL_TOP/admin/$TWO_TASK/adalldefaults.txt logfile=u9239089.log patchtop=/software/patches/9239089 driver=u9239089.drv workers=10

Apply u9239089.drv of the patch using adpatch

Apply  u9239090.drv of the patch using adpatch

Apply the latest consolidated online help

Apply u9239095.drv of the patch using adpatch

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 u9817770.drv of the patch using adpatch
   
Apply mandatory Patch 9966055 (9966055:R12.FND.B [TRANSLATED VERSION OF FNDSCSGN NOT LAUNCHED].)

Apply  u9966055.drv of the patch using adpatch

Step.5
Run autoconfig on both tiers:

Application tier:
-----------------
$cd $ADMIN_SCRIPTS_HOME
$adautocfg.sh
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:
--------------
Copy or FTP the appsutil.zip file to the <RDBMS ORACLE_HOME>.
$cd $ORACLE_HOME
$unzip -o appsutil.zip
Run AutoConfig on the Database Node:
$cd $ORACLE_HOME/appsutil/scripts
$adautocfg.sh

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

Step.7
Modify Initialization Parameters and bounce database

-remove entry _disable_fast_validate=TRUE
-set recyclebin=ON
-Disable maintenance mode

Step.8
Start Applications and Perform a health check of the instance.

cd $ADMIN_SCRIPTS_HOME
sh adstrtal.sh apps/apps

SQL> select release_name from fnd_product_groups;
RELEASE_NAME
-------------
12.1.3

Reference Metalink Document:
Oracle E-Business Suite Release 12.1.3 Readme [ID 1080973.1]
Database Preparation Guidelines for an E-Business Suite Release 12.1.1 Upgrade [ID 761570.1]
Database Initialization Parameters for Oracle Applications Release 12 [ID 396009.1] Oracle® E-Business Suite Upgrade Guide