EBS -- 12.1.1 to 12.1.3 Upgrade Steps

Normally when you install EBS 12.1.1 with rapidwiz you have the following;

12.1.1 version of EBS.

11.1.0.7 version of Oracle Database.

10.1.3.4 Oracle Home for Oracle IAS

10.1.2.3 Oracle Home for Oracle tools(reports & forms)

In this documents, you can find the steps needed to upgrade EBS version from 12.1.1 to 12.1.3.

Note that, in our installations, we always install 12.1.1 and upgrade it to 12.1.3.. So if the customer requests a db upgrade , we upgrade the database from 11.1.0.7 to 11.2.0.3 just after 12.1.3 upgrade.

• Stop application services.
• Apply necessary database patches(if not applied)

For all UNIX/Linux platforms

* 7111245

* 7211965

* 7330434

* 7486407

* 7627743

* 7639602

* 7684818

* 8199107

* 8639653

* 8940108

* 9026927

* 9066130

* 9554727

* 9743057

* 7319922 (rollback ad reapply if applied already..)

You can use the following method to apply (rollback) patches ..

cd to Patch unzipped_location;

to rollback -> opatch rollback -id PATCH_ID

to apply  -> opatch apply

• Following  Initialization Parameters should be modified  in spfile/pfile before the upgrade;

_disable_fast_validate=TRUE
recyclebin=off

• 10.1.3 Oracle Home version should be >= 10.1.3.4 and 10.1.2 Oracle Home = 10.1.2.3 before the upgrade.Note that if you install 12.1.1 with rapidwiz, these requirements become already met, but you can check to be sure, anyways.

You can check Oracle Home versions with the following;

To check 10.1.3 home version;

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

You need to look the following line in the opatch output:

 "Patch of Oracle Application Server 10g signifies the Patchset on top of it"

To check 10.1.2 home version;
relogin to the operating system with application owner os user. (to source the apps env file.. This is required to ensure the environment is set for the 10.1.2 oracle home)

$ORACLE_HOME/OPatch/opatch lsinventory -detail -invPtrLoc $ORACLE_HOME/oraInst.loc | egrep 'Oracle Application Server 10g|Patch of Oracle Application Server 10g'

You need to look the following line in the opatch output:

 "Patch of Oracle Application Server 10g signifies the Patchset on top of it"

• Apply Applications patch (ad.b.delta.3) 9239089 patch .  This patch is the prereq of EBS upgrade patch.

To apply 9239089 do the following;

Create $ORACLE_HOME/appsutil/admin on the database server.

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 APPLSYS

Apply u9239089.drv of the patch using adpatch

• Apply Oracle E-Business Suite Release 12.1.3 (9239090 )
• Apply the latest consolidated online help (9239095, this is a post requirement)
• Apply Patch 9817770 (this is a post requirement)
• Apply mandatory Patch 9966055 (this is a post requirement)
• Apply hrglobal.drv (note that if you will apply a post patch that requires hrglobal.drv , you can skip this step as you will need to apply hrglobal.drv later..
• Run autoconfig on application tier
• Create appsutil on one of apps server and copy it to db tier

$perl $AD_TOP/bin/admkappsutil.pl --> this will create appsutil.zip
Copy or FTP the appsutil.zip file to the RBMS ORACLE_HOME
cd $ORACLE_HOME
unzip -o appsutil.zip

• Run AutoConfig on the Database Node.

• Modify Initialization Parameters back to their original values.

_disable_fast_validate=FALSE
recyclebin=ON

• Start application services