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
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
No comments:
Post a Comment