Blog | Feb 3, 2014

Learn E-Business Suite R12.2.3 Upgrade Steps from R12.2.2!!!

The fourth and the final of the series explains the E-Business Suite R12.2.3 Upgrade Steps from R12.2.2. The first starting step for this would be to apply Patch 17204589 (17204589:12.2.0) on the Run File System before proceeding to the next steps if you haven't already applied Consolidated Seed Table Upgrade Patch 17204589 (17204589:12.2.0).

Application tier technology patches must be applied to the patch file system. Refer to My Oracle Support Knowledge Document 1355068.1, Oracle E-Business Suite 12.2 Patching Technology Components Guide for instructions on how to apply technology patches. As you are already in an active adop patching cycle, you should not invoke any adop actions (for example: finalize, cutover, clean-up, fs_clone) as mentioned in the My Oracle Support Knowledge Document 1355068.1. These adop actions should be executed in later steps as mentioned in the document.

Again, synchronizing the file systems help the next online patching cycle complete faster.

Reference Notes #

Applying the 12.2.3 AD and TXK Release Update Pack (Doc ID 1586217.1)
Oracle E-Business Suite Release 12.2.3 Readme (1586214.1)
Oracle E-Business Suite Release 12.2: Online Patching FAQ(1583902.1)
Oracle Application Object Library(1381208.2)
Oracle Application Install(1381177.2)
Using the Online Patching Readiness Report in Oracle E-Business Suite Release 12.2(1531121.1)
Oracle E-Business Suite Release Notes, Release 12.2 (Doc ID 1320300.1)
==============================================

1) - Already at R12.2.2
2) - All Database prep patches applied
3) - Apply Consolidated Seed Table Upgrade Patch (Required)

If you haven't already applied Consolidated Seed Table Upgrade Patch 17204589 (17204589:12.2.0), then you must first apply Patch 17204589 (17204589:12.2.0) on the Run File System following the below instructions before proceeding with the next steps.

Note: If you have upgraded to Release 12.2.0 using Consolidated Upgrade Patch 17197281 [17197281:12.2.0 (CUP4)], then you can skip this step.
Stop all Application tier services on the Run File System.
UNIX

sh $ADMIN_SCRIPTS_HOME/adstpall.sh

Start up only the Weblogic AdminServer service on the Run File System.
UNIX

$ sh $ADMIN_SCRIPTS_HOME/adadminsrvctl.sh start

Apply the consolidated seed table upgrade Patch 17204589 (17204589:12.2.0) on the Run File system using adop hotpatch mode.

Moved patch p17204589_12.2.0_R12_GENERIC.zip and unzip at /u01/app/appti/TR122I/fs_ne/EBSapps/patch
$ adop phase=apply patches=17204589 hotpatch=yes
....
...
..
ply_20131216_202843/TR122I_nsmltcstrg02/log
      [EVENT]     [START 2013/12/16 20:46:59] Running cutover since in hotpatch mode
      [END   2013/12/16 20:47:05] apply phase
      [START 2013/12/16 20:47:05] Generating Post Apply Reports
        [START 2013/12/16 20:47:08] Generating AD_ZD_LOGS Report
            [EVENT]     Report: /u01/app/appti/TR122I/fs1/EBSapps/appl/ad/12.0.0/sql/ADZDSHOWLOG.sql
            [EVENT]     Output: /u01/app/appti/TR122I/fs_ne/EBSapps/log/adop/8/apply_20131216_202843/TR122I_nsmltcstrg02/adzdshowlog.out

        [END   2013/12/16 20:47:14] Generating AD_ZD_LOGS Report
      [END   2013/12/16 20:47:14] Generating Post Apply Reports
    [END   2013/12/16 20:47:19] adzdoptl.pl run
    adop phase=apply - Completed Successfully

    Log file: /u01/app/appti/TR122I/fs_ne/EBSapps/log/adop/8/adop_20131216_202843.log

adop exiting with status = 0 (Success)
[appti@nsmltcstrg02 ~]$

Note: For existing non-American languages in the system, skip NLS patch application for this. It is not required.

Start up all Application tier services.
UNIX

$ sh $ADMIN_SCRIPTS_HOME/adstrtal.sh

4) - Apply the 12.2.3 AD and TXK Release Update Packs

REFER Applying the 12.2.3 AD and TXK Release Update Pack (Doc ID 1586217.1)

3.2 PATH B - Existing 12.2 RUP level customers

Source the run edition environment file.
UNIX

$ . <RUN_BASE>/EBSapps/appl/APPS <CONTEXT_NAME>.env

Start new online patching cycle.
$ adop phase=prepare

Follow the instructions in the patch readme to execute adgrants. 
Run adgrants.
Download and unzip Oracle Applications DBA 12.2.3 Product Release Update Pack (R12.AD.C.Delta.3) , Patch 17023760.

[orati@nsmltcstrg02 admin]$ pwd
/u01/app/orati/TR122I/db/tech_st/11.2.0.3/appsutil/admin
[orati@nsmltcstrg02 admin]$ cp /u01/app/appti/TR122I/fs_ne/EBSapps/patch/17023760/admin/adgrants.sql .
[orati@nsmltcstrg02 admin]$ strings -a adgrants.sql|grep Header
REM $Header: adgrants.sql 120.67.12020000.15 2013/08/20 14:07:30 asutrala ship $
/* $Header: adgrants.sql 120.67.12020000.15 2013/08/20 14:07:30 asutrala ship $ */
/* $Header: adgrants.sql 120.67.12020000.15 2013/08/20 14:07:30 asutrala ship $ */
/* $Header: adgrants.sql 120.67.12020000.15 2013/08/20 14:07:30 asutrala ship $ */
/* $Header: adgrants.sql 120.67.12020000.15 2013/08/20 14:07:30 asutrala ship $ */
[orati@nsmltcstrg02 admin]$ sqlplus /nolog

SQL*Plus: Release 11.2.0.3.0 Production on Wed Dec 18 13:44:57 2013

Copyright (c) 1982, 2011, Oracle.  All rights reserved.

SQL> @adgrants.sql APPS
Connected.
---------------------------------------------------
--- adgrants.sql started at 2013-12-18 13:45:16 ---


Creating PL/SQL profiler objects.

---------------------------------------------------
--- profload.sql started at 2013-12-18 13:45:16 ---


Package created.

Grant succeeded.

Synonym created.

Library created.

Package body created.

Testing for correct installation
SYS.DBMS_PROFILER successfully loaded.

PL/SQL procedure successfully completed.

-----------------------------------------------------
--- profload.sql completed at 2013-12-18 13:45:18 ---

--------------------------------------------------
--- proftab.sql started at 2013-12-18 13:45:18 ---

Table dropped.

Table dropped.

Table dropped.

Sequence dropped.

Table created.

Comment created.

Table created.

Comment created.

Table created.

Comment created.

Sequence created.

-----------------------------------------------------
--- profltab.sql completed at 2013-12-18 13:45:19 ---

Installing Hierarchical Profiler.

Table dropped.

Table dropped.

Table dropped.

Sequence dropped.

Table created.

Comment created.

Table created.

Comment created.

Table created.

Comment created.

Sequence created.

Package created.

Synonym created.

Grant succeeded.
Grant succeeded.

Grant succeeded.

Grant succeeded.

Loading Stylesheets if missing

PL/SQL procedure successfully completed.

Start of Creating AD_JAR context

PL/SQL procedure successfully completed.

End of Creating AD_JAR context

Creating PL/SQL Package AD_DBMS_METADATA.

Package created.

Package body created.

End of Creating PL/SQL Package AD_DBMS_METADATA.

Creating PL/SQL Package AD_ZD_SYS.

Package created.

Package body created.

End of Creating PL/SQL Package AD_ZD_SYS.

Start of giving grants. This may take few minutes.

PL/SQL procedure successfully completed.

Start of PURGE DBA_RECYCLEBIN.

PL/SQL procedure successfully completed.

End of PURGE DBA_RECYCLEBIN.

Commit complete.

Disconnected from the Oracle Database 11g Enterprise Edition Release 11.2.0.3.0 - 64bit Production
With the Partitioning, OLAP, Data mining and the Real Application testing options
[orati@nsmltcstrg02 admin]$

Source the run edition environment file.
UNIX

$ . <RUN_BASE>/EBSapps/appl/APPS <CONTEXT_NAME>.env
Windows

C:\><RUN_BASE>\EBSapps\appl\envshell<CONTEXT_NAME>.cmd
Start new online patching cycle.

$ adop phase=prepare

Run apply phase for R12.AD.C.DELTA.3 Patch 17023760.
$ adop phase=apply patches=17023760
Run apply phase for R12.TXK.C.DELTA.3 Patch 17021789.
$ adop phase=apply patches=17021789

Note: R12.AD.C.DELTA.3 and R12.TXK.C.DELTA.3 must be applied in the same online patching cycle, without merging.
Instantiate the Oracle HTTP Server configuration files admin.conf, ssl.conf, mod_wl_ohs.conf on on patch edition applications environment.

Note: Since the templates are being instantiated, all customizations will be lost and have to be restored explicitly.
Source the patch edition environment file.

$ . <PATCH_BASE>/EBSapps/appl/APPS <CONTEXT_NAME>.env

Perform the instantiation with the following commands. When prompted for the APPS password, press <Return>.

$ADJVAPRG oracle.apps.ad.autoconfig.InstantiateFile -e $CONTEXT_FILE -d $FND_TOP/admin/driver/ohstmpl.drv -tmpl $FND_TOP/admin/template/ssl_conf_FMW.tmp
$ADJVAPRG oracle.apps.ad.autoconfig.InstantiateFile -e $CONTEXT_FILE -d $FND_TOP/admin/driver/ohstmpl.drv -tmpl $FND_TOP/admin/template/mod_wl_ohs_conf_FMW.tmp
$ADJVAPRG oracle.apps.ad.autoconfig.InstantiateFile -e $CONTEXT_FILE -d $FND_TOP/admin/driver/ohstmpl.drv -tmpl $FND_TOP/admin/template/admin_conf_FMW.tmp
perl $FND_TOP/patch/115/bin/txkSetAppsConf.pl -contextfile=$CONTEXT_FILE -outfile=$INST_TOP/logs/appl/rgf/TXK/test.log

***OUTPUTs as below***

[appti@nsmltcstrg02 ~]$ . ./APPSFS2.env
[appti@nsmltcstrg02 ~]$ echo $PATCH_BASE
/u01/app/appti/TR122I/fs2
[appti@nsmltcstrg02 ~]$ $ADJVAPRG oracle.apps.ad.autoconfig.InstantiateFile -e $CONTEXT_FILE -d $FND_TOP/admin/driver/ohstmpl.drv -tmpl $FND_TOP/admin/template/ssl_conf_FMW.tmp
Enter the APPS password :
[appti@nsmltcstrg02 ~]$ $ADJVAPRG oracle.apps.ad.autoconfig.InstantiateFile -e $CONTEXT_FILE -d $FND_TOP/admin/driver/ohstmpl.drv -tmpl $FND_TOP/admin/template/mod_wl_ohs_conf_FMW.tmp
Enter the APPS password :
[appti@nsmltcstrg02 ~]$ $ADJVAPRG oracle.apps.ad.autoconfig.InstantiateFile -e $CONTEXT_FILE -d $FND_TOP/admin/driver/ohstmpl.drv -tmpl $FND_TOP/admin/template/admin_conf_FMW.tmp
Enter the APPS password :
[appti@nsmltcstrg02 ~]$ date
Wed Dec 18 16:19:11 EST 2013
[appti@nsmltcstrg02 ~]$ ll $FND_TOP/admin/driver/ohstmpl.drv
-rwxr-xr-x 1 appti appti 3214 Dec 18 15:26 /u01/app/appti/TR122I/fs2/EBSapps/appl/fnd/12.0.0/admin/driver/ohstmpl.drv
[appti@nsmltcstrg02 ~]$ perl $FND_TOP/patch/115/bin/txkSetAppsConf.pl -contextfile=$CONTEXT_FILE -outfile=$INST_TOP/logs/appl/rgf/TXK/test.log
apps.conf generated successfully

mod_wl_ohs.conf generated successfully

[appti@nsmltcstrg02 ~]$

***OUTPUTs as above***


5. Apply the 12.2.3 Suite-Wide Release Update Pack

Having applied the Release 12.2.3 AD and TXK Release Update Packs, you can now proceed to apply the 12.2.3 Suite-Wide Release Update Pack.

Source the run edition applications environment.

UNIX

$ . <RUN_BASE>/EBSapps/appl/APPS<CONTEXT_NAME>.env <-- Already sources as part of Above adop session
Start an online patching cycle.

$ adop phase=prepare  <-- Already ran as part of Above adop session
Application Tier Technology Patches

Application tier technology patches must be applied to the patch file system. Refer to My Oracle Support Knowledge Document 1355068.1, Oracle E-Business Suite 12.2 Patching Technology Components Guide for instructions on how to apply technology patches. As you are already in an active adop patching cycle, you should not invoke any adop actions (for example: finalize, cutover, cleanup, fs_clone) as mentioned in the My Oracle Support Knowledge Document 1355068.1. These adop actions should be executed in later steps as mentioned in this document.

Apply the latest Application tier technology patches documented in 'Section 3: Application Tier Technology Patches and Bug Numbers' of My Oracle Support Knowledge Document 1594274.1, Oracle E-Business Suite Release 12.2: Consolidated List of Patches and Technology Bug Fixes.

Apply the Oracle E-Business Suite Release 12.2.3 Patch 17020683 and Oracle E-Business Suite Release 12.2.3 Online Help Patch 17020685.

$ adop phase=apply patches=17020683,17020685
.....
...
..
defaultsfile=/u01/app/appti/TR122I/fs2/EBSapps/appl/admin/TR122I_patch/adalldefaults.txt patchtop=/u01/app/appti/TR122I/fs_ne/EBSapps/patch/17020685 driver=u17020685.drv logfile=u17020685.log
    ADPATCH Log directory: /u01/app/appti/TR122I/fs_ne/EBSapps/log/adop/9/apply_20131218_162341/TR122I_nsmltcstrg02/17020685/log
  [END   2013/12/18 21:27:30] apply phase
  [START 2013/12/18 21:27:30] Generating Post Apply Reports
    [START 2013/12/18 21:27:33] Generating AD_ZD_LOGS Report
        [EVENT]     Report: /u01/app/appti/TR122I/fs1/EBSapps/appl/ad/12.0.0/sql/ADZDSHOWLOG.sql

        [EVENT]     Output: /u01/app/appti/TR122I/fs_ne/EBSapps/log/adop/9/apply_20131218_162341/TR122I_nsmltcstrg02/adzdshowlog.out

    [END   2013/12/18 21:27:38] Generating AD_ZD_LOGS Report
  [END   2013/12/18 21:27:38] Generating Post Apply Reports
[END   2013/12/18 21:27:42] adzdoptl.pl run
adop phase=apply - Completed Successfully

Log file: /u01/app/appti/TR122I/fs_ne/EBSapps/log/adop/9/adop_20131218_162341.log

adop exiting with status = 0 (Success)
[appti@nsmltcstrg02 ~]$

Instantiate the Oracle HTTP Server configuration files admin.conf, ssl.conf, and mod_wl_ohs.conf.
Note: Since the templates are being instantiated, all the customizations will be lost and have to be restored explicitly.
Source the patch edition environment file:
UNIX

$ . $PATCH_BASE/EBSapps/appl/APPS$CONTEXT_NAME.env

Perform the instantiation with the following commands (the backslash at the end of each line is being used to divide each command across several screen lines for readability). When prompted for the APPS password, press <Return>.
UNIX

$ADJVAPRG oracle.apps.ad.autoconfig.InstantiateFile -e $CONTEXT_FILE -d $FND_TOP/admin/driver/ohstmpl.drv -tmpl $FND_TOP/admin/template/ssl_conf_FMW.tmp
$ADJVAPRG oracle.apps.ad.autoconfig.InstantiateFile -e $CONTEXT_FILE -d $FND_TOP/admin/driver/ohstmpl.drv -tmpl $FND_TOP/admin/template/mod_wl_ohs_conf_FMW.tmp
$ADJVAPRG oracle.apps.ad.autoconfig.InstantiateFile -e $CONTEXT_FILE -d $FND_TOP/admin/driver/ohstmpl.drv -tmpl $FND_TOP/admin/template/admin_conf_FMW.tmp
perl $FND_TOP/patch/115/bin/txkSetAppsConf.pl -contextfile=$CONTEXT_FILE -outfile=$INST_TOP/logs/appl/rgf/TXK/test.log
==========================================
****OUTPUT for above commands below****
[appti@nsmltcstrg02 ~]$ . ./APPSFS2.env
[appti@nsmltcstrg02 ~]$ echo $PATCH_BASE
/u01/app/appti/TR122I/fs2
[appti@nsmltcstrg02 ~]$ $ADJVAPRG oracle.apps.ad.autoconfig.InstantiateFile -e $CONTEXT_FILE -d $FND_TOP/admin/driver/ohstmpl.drv -tmpl $FND_TOP/admin/template/ssl_conf_FMW.tmp
Enter the APPS password :
[appti@nsmltcstrg02 ~]$ $ADJVAPRG oracle.apps.ad.autoconfig.InstantiateFile -e $CONTEXT_FILE -d $FND_TOP/admin/driver/ohstmpl.drv -tmpl $FND_TOP/admin/template/mod_wl_ohs_conf_FMW.tmp
Enter the APPS password :
[appti@nsmltcstrg02 ~]$ $ADJVAPRG oracle.apps.ad.autoconfig.InstantiateFile -e $CONTEXT_FILE -d $FND_TOP/admin/driver/ohstmpl.drv -tmpl $FND_TOP/admin/template/admin_conf_FMW.tmp
Enter the APPS password :
[appti@nsmltcstrg02 ~]$ perl $FND_TOP/patch/115/bin/txkSetAppsConf.pl -contextfile=$CONTEXT_FILE -outfile=$INST_TOP/logs/appl/rgf/TXK/test.log
apps.conf generated successfully

mod_wl_ohs.conf generated successfully

==========================================
Complete the online patching cycle by running the following commands in the order shown.
Source the run edition environment file:
UNIX

$ . $RUN_BASE/EBSapps/appl/APPS$CONTEXT_NAME.env

adop phase=finalize
adop phase=cutover
.....
...
..
      [EVENT]     Report: /u01/app/appti/TR122I/fs2/EBSapps/appl/ad/12.0.0/sql/ADZDSHOWLOG.sql

      [EVENT]     Output: /u01/app/appti/TR122I/fs_ne/EBSapps/log/adop/9/cutover_20131218_221044/TR122I_nsmltcstrg02/adzdshowlog.out

  [END   2013/12/18 22:59:20] Generating AD_ZD_LOGS Report

Broadcast message from appti (Wed Dec 18 22:59:23 2013):

The context of the Oracle E-Business Suite system TR122I has been changed after the completion of the Online Patching. All users connected to the Run or Patch file system must now re-source the Oracle E-Business Suite Applications Environment.
  [EVENT]     Executing post-cutover call-out script.
[END   2013/12/18 22:59:27] adzdoptl.pl run
adop phase=cutover - Completed Successfully

Log file: /u01/app/appti/TR122I/fs_ne/EBSapps/log/adop/9/adop_20131218_221044.log

adop exiting with status = 0 (Success)
You have a new mail in /var/spool/mail/appti
[appti@nsmltcstrg02 ~]$
==============================================
Received following message on different Putty Session –(Informational Only)

[appti@nsmltcstrg02 ~]$ . ./APPSFS1.env
[appti@nsmltcstrg02 ~]$ echo $RUN_BASE
/u01/app/appti/TR122I/fs1
[appti@nsmltcstrg02 ~]$
Broadcast message from appti (Wed Dec 18 22:19:55 2013):

The context of the Oracle E-Business Suite system TR122I has been changed after the completion of the Online Patching.
All users connected to the Run or Patch file system must now re-source the Oracle E-Business Suite Applications Environment.
==============================================
**Restarted session, Resourced RUN FS Env**
adop phase=cleanup
.....
...
..
            [EVENT]     Output: /u01/app/appti/TR122I/fs_ne/EBSapps/log/adop/9/cleanup_20131219_070945/TR122I_nsmltcstrg02/adzdallddls_20131219_071159.out

        [END   2013/12/19 07:12:00] Generating All DDL Report
        [EVENT]     Calling cleanup in QUICK mode
        [WARNING]   Cleanup may take a while. Please wait.
      [EVENT]     [END   2013/12/19 07:40:06] Performing Cleanup steps
    [END   2013/12/19 07:40:14] cleanup phase
    [START 2013/12/19 07:40:18] Generating AD_ZD_LOGS Report
        [EVENT]     Report: /u01/app/appti/TR122I/fs2/EBSapps/appl/ad/12.0.0/sql/ADZDSHOWLOG.sql

        [EVENT]     Output: /u01/app/appti/TR122I/fs_ne/EBSapps/log/adop/9/cleanup_20131219_070945/TR122I_nsmltcstrg02/adzdshowlog.out

    [END   2013/12/19 07:40:23] Generating AD_ZD_LOGS Report
  [END   2013/12/19 07:40:24] adzdoptl.pl run
  adop phase=cleanup - Completed Successfully

  Log file: /u01/app/appti/TR122I/fs_ne/EBSapps/log/adop/9/adop_20131219_070945.log

adop exiting with status = 0 (Success)
[appti@nsmltcstrg02 ~]$
==========================================
6. Post-Update Steps

Synchronize file systems
Synchronize the file systems using the command shown below.
This action will copy the new run edition code and configuration to the other file system, to help the next online patching cycle complete faster.

adop phase=fs_clone

.....
...
..
adadminsrvctl.sh: exiting with status 0

adadminsrvctl.sh: check the logfile /u01/app/appti/TR122I/fs1/inst/apps/TR122I_nsmltcstrg02/logs/appl/admin/log/adadminsrvctl.txt for more information ... 

          [EVENT]     [END   2013/12/19 10:03:31] Check and Stop Patch FS Admin Server
    [START 2013/12/19 10:03:33] Generating AD_ZD_LOGS Report
        [EVENT]     Report: /u01/app/appti/TR122I/fs2/EBSapps/appl/ad/12.0.0/sql/ADZDSHOWLOG.sql

        [EVENT]     Output: /u01/app/appti/TR122I/fs_ne/EBSapps/log/adop/10/fs_clone_20131219_090512/TR122I_nsmltcstrg02/adzdshowlog.out

    [END   2013/12/19 10:03:38] Generating AD_ZD_LOGS Report
  [END   2013/12/19 10:03:38] adzdoptl.pl run
  adop phase=fs_clone - Completed Successfully

  Log file: /u01/app/appti/TR122I/fs_ne/EBSapps/log/adop/10/adop_20131219_090512.log

adop exiting with status = 0 (Success)
[appti@nsmltcstrg02 ~]$

This concludes R12.2.3 Upgrade… You can now complete the upgrade hassle free!!!