Upgrading EBS R12.1.1 to R12.1.3

1. Normally when you install EBS 12.1.1 with rapidwiz you will get the following technology versions:

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

2. Prerequisite Steps:

   - It is advisable to complete all of the following three steps before attempting to apply the 12.1.3 Release Update Pack.

   a) Upgrade database version to 11.2.0.3

   - After Upgrade following Initialization Parameters should be modified:

SQL> alter system set "_disable_fast_validate"=TRUE SCOPE=BOTH;
SQL> alter system set "_pga_max_size"=104857600 scope=both;
SQL> alter system set recyclebin=off scope=spfile;
SQL> shut immediate;
SQL> startup

   b) Upgrade forms 10.1.2 to the latest version:

   - 10.1.2 Oracle Home version should be = 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.

   - You can check Oracle Home version with the following from Apps Tier as applmgr:

$ $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"

   c) Upgrade iAS 10.1.3 to the latest version:

   - 10.1.3 Oracle Home version should be >= 10.1.3.4 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 version with the following from Apps Tier as applmgr:

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

   e) Apply Applications patch (AD.B.Delta.3) 9239089 patch and follow the instructions in the patch readme file. This is the prereq for EBS upgrade patch(RUP).

   f) Compile APPS Schema:

Run adadmin > Compile/Reload Applications Database Entities menu > Compile APPS schema.

3. Apply 12.1.3 Release Update Patch (RUP) 9239090

4. Use AutoPatch to apply the latest consolidated online help Patch 9239095 and follow the instructions in the patch readme file.

5. Post Upgrade Steps:

   a) Apply the latest consolidated online help patch 9239095, 9400185

   b) Apply Patch 9817770.

   c) Apply Patch 8919491 - R12.ATG_PF.B.delta.3

   d) Apply mandatory Patch 9966055.

   e) Download and apply database patch 19393542 for your appropriate DB level.

   f) Apply Patch 21314548 - R12.AD.B.DELTA.7 PATCH

   g) Apply Patches - 17385991, 9888158, 9583541, 11866699, 12917273, 9951283, 9951284 (Use admrgpch)

   h) Run autoconfig on application tier:

$ cd $ADMIN_SCRIPTS_HOME
$ ./adautocfg.sh

   i) Create appsutil on the 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

   j) Run AutoConfig on the Database Node:

$ cd $ORACLE_HOME/appsutil/bin
$ ./adconfig.sh

  k) Modify Initialization Parameters back to their original values on the database:

SQL> alter system set "_disable_fast_validate"=FALSE SCOPE=BOTH;
SQL> alter system set recyclebin=off scope=spfile;
SQL> shut immediate;
SQL> startup;

  l) Database tier and application tier:

 Run adpreclone.pl on the database tier and the application tier. Since updates included in Oracle E-Business Suite Applications Technology Release 12.1.3    (R12.ATG_PF.B.delta.3) were applied to the system, you must run the adpreclone again in order to apply the updates to the clone directory structures used during cloning.

perl adpreclone.pl dbTier
perl adpreclone.pl appsTier

  m) Disable the maintenance mode.

$ adadmin defaultsfile=$APPL_TOP/admin/$TWO_TASK/adalldefautls.txt logfile=adadmin.log menu_option=DISABLE_MAINT_MODE workers=2

  n) Start application services.