Blog | Jan 31, 2014

Upgrade to E-Business Suite R12.2.2 from R12.2.0. Part III

In the third part we learn to upgrade to E-Business Suite R12.2.2 from R12.2.0. During the upgrade you will notice the use of backslash at the end of each line. This has a significance and is used to divide each command across several screen lines for readability.

The context of the Oracle E-Business Suite system TR122I has been changed after the completion of Online Patching.  All users connected to the Run or Patch file system must now re-source the Oracle E-Business Suite Applications Environment.

Synchronizing the file systems is important as this action copies the new run edition code and configuration to the other file system, to help the next online patching cycle complete faster.

Reference Notes #
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)
Applying the 12.2.2 AD and TXK Release Update Pack (Doc ID 1560906.1)
Oracle E-Business Suite Release 12.2.2 Readme (Doc ID 1506669.1)

Having applied the Release 12.2.2 AD and TXK Release Update Packs in Part # 2 as Post Upgrade Step of R12.2.0, you can now proceed to apply the 12.2.2 Suite-Wide Release Update Pack in the Online Patching Mode

1. Apply the 12.2.2 Suite-Wide Release Update Pack

Start an online patching cycle.

$ adop phase=prepare
[appti@nsmltcstrg02 ~]$ adop phase=prepare

Enter the APPS password:
Enter the SYSTEM password:
Enter the WLSADMIN password:

Please wait. Validating credentials...

RUN file system context file: /u01/app/appti/TR122I/fs2/inst/apps/TR122I_nsmltcstrg02/appl/admin/TR122I_nsmltcstrg02.xml
PATCH file system context file: /u01/app/appti/TR122I/fs1/inst/apps/TR122I_nsmltcstrg02/appl/admin/TR122I_nsmltcstrg02.xml

************* Start of  session *************
version: 12.2.0
started at: Fri Nov 15 2013 22:25:59

APPL_TOP is set to /u01/app/appti/TR122I/fs2/EBSapps/appl

...
...
...


You are running adadminsrvctl.sh version 120.10.12020000.4

Stopping WLS Admin Server...
Refer /u01/app/appti/TR122I/fs1/inst/apps/TR122I_nsmltcstrg02/logs/appl/admin/log/adadminsrvctl.txt for details

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/11/15 22:51:43] Check and Stop Patch FS Admin Server
  [END   2013/11/15 22:51:49] adzdoptl.pl run
  adop phase=prepare - Completed Successfully

  Log file: /u01/app/appti/TR122I/fs_ne/EBSapps/log/adop/6/adop_20131115_222522.log

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


2.  Apply the Oracle E-Business Suite Release 12.2.2 Patch 16207672 and the Oracle E-Business Suite Release 12.2.2 Online Help Patch 16207673.

$ adop phase=apply patches=16207672,16207673
[appti@nsmltcstrg02 ~]$ adop phase=apply patches=16207672,16207673

Enter the APPS password:
Enter the SYSTEM password:
Enter the WLSADMIN password:

Please wait. Validating credentials...

RUN file system context file: /u01/app/appti/TR122I/fs2/inst/apps/TR122I_nsmltcstrg02/appl/admin/TR122I_nsmltcstrg02.xml
PATCH file system context file: /u01/app/appti/TR122I/fs1/inst/apps/TR122I_nsmltcstrg02/appl/admin/TR122I_nsmltcstrg02.xml

************* Start of  session *************
version: 12.2.0
started at: Fri Nov 15 2013 23:22:28

APPL_TOP is set to /u01/app/appti/TR122I/fs2/EBSapps/appl

..........
..........

  [END   2013/11/16 06:50:40] apply phase
  [START 2013/11/16 06:50:41] Generating Post Apply Reports
    [START 2013/11/16 06:50:44] 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/6/apply_20131115_232131/TR122I_nsmltcstrg02/adzdshowlog.out

    [END   2013/11/16 06:50:49] Generating AD_ZD_LOGS Report
  [END   2013/11/16 06:50:50] Generating Post Apply Reports
[END   2013/11/16 06:50:54] adzdoptl.pl run
adop phase=apply - Completed Successfully

Log file: /u01/app/appti/TR122I/fs_ne/EBSapps/log/adop/6/adop_20131115_232131.log

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

3.  Instantiate the Oracle HTTP Server configuration files ssl.conf and mod_wl_ohs.conf.

a. Source the patch edition environment file:
UNIX
su - appti
ls -alrt *.env
FS2 is RUN and FS1 is PATCH at the moment - please double check by echo $RUN_BASE, echo $PATCH_BASE command

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

b. 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

[appti@nsmltcstrg02 ~]$ . ./APPSFS1.env
[appti@nsmltcstrg02 ~]$
[appti@nsmltcstrg02 ~]$
[appti@nsmltcstrg02 ~]$ env | grep RUN
RUN_BASE=/u01/app/appti/TR122I/fs2
[appti@nsmltcstrg02 ~]$ env |grep PATCH
PATCH_BASE=/u01/app/appti/TR122I/fs1


[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 :


4.  Complete the online patching cycle by running the following commands in the order shown.

a. Source the run edition environment file:

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

b. $ adop phase=finalize

[appti@nsmltcstrg02 ~]$ adop phase=finalize

Enter the APPS password:
Enter the SYSTEM password:
Enter the WLSADMIN password:

Please wait. Validating credentials...

RUN file system context file: /u01/app/appti/TR122I/fs2/inst/apps/TR122I_nsmltcstrg02/appl/admin/TR122I_nsmltcstrg02.xml
PATCH file system context file: /u01/app/appti/TR122I/fs1/inst/apps/TR122I_nsmltcstrg02/appl/admin/TR122I_nsmltcstrg02.xml

************* Start of session *************
version: 12.2.0
started at: Sun Nov 17 2013 03:32:46

APPL_TOP is set to /u01/app/appti/TR122I/fs2/EBSapps/appl

....
...
....

  [START 2013/11/17 03:33:23] finalize phase
      [EVENT]     Running Finalize in QUICK mode
  [END   2013/11/17 03:35:31] finalize phase
  [START 2013/11/17 03:35:31] Generating Post Finalize Reports
  [END   2013/11/17 03:35:32] Generating Post Finalize Reports
  [START 2013/11/17 03:35:32] 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/6/finalize_20131117_033152/TR122I_nsmltcstrg02/adzdshowlog.out

  [END   2013/11/17 03:35:38] Generating AD_ZD_LOGS Report
[END   2013/11/17 03:35:44] adzdoptl.pl run
adop phase=finalize - Completed Successfully

Log file: /u01/app/appti/TR122I/fs_ne/EBSapps/log/adop/6/adop_20131117_033152.log

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

c.$ adop phase=cutover

[appti@nsmltcstrg02 ~]$ adop phase=cutover

Enter the APPS password:
Enter the SYSTEM password:
Enter the WLSADMIN password:

Please wait. Validating credentials...

RUN file system context file: /u01/app/appti/TR122I/fs2/inst/apps/TR122I_nsmltcstrg02/appl/admin/TR122I_nsmltcstrg02.xml
PATCH file system context file: /u01/app/appti/TR122I/fs1/inst/apps/TR122I_nsmltcstrg02/appl/admin/TR122I_nsmltcstrg02.xml

************* Start of session *************
version: 12.2.0
started at: Sun Nov 17 2013 03:37:15
...
...
Program:  completed @ Sun Nov 17 03:48:34 2013

      [EVENT]     [END   2013/11/17 03:48:34] Atomic File System Cutover

Broadcast message from appti (Sun Nov 17 03:48:40 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]     [START 2013/11/17 03:48:40] Starting Middle Tier Services

Program:  started @ Sun Nov 17 03:48:41 2013

*** Log File = /u01/app/appti/TR122I/fs_ne/EBSapps/log/adop/6/cutover_20131117_033654/TR122I_nsmltcstrg02/TXK_CTRL_forcestartup_Sun_Nov_17_03_48_41_2013/txkADOPCutOverPhaseCtrlScript_Sun_Nov_17_03_48_41_2013.log
...
...

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

  [END   2013/11/17 05:00:37] Generating AD_ZD_LOGS Report

Broadcast message from appti (Sun Nov 17 05:00:58 2013):

The context of the Oracle E-Business Suite system TR122I has been changed after the completion of 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/11/17 05:01:07] adzdoptl.pl run
adop phase=cutover - Completed Successfully

Log file: /u01/app/appti/TR122I/fs_ne/EBSapps/log/adop/6/adop_20131117_033654.log

adop exiting with status = 0 (Success)
You have new mail in /var/spool/mail/appti

d. $ adop phase=cleanup

[appti@nsmltcstrg02 ~]$ adop phase=cleanup

Enter the APPS password:
Enter the SYSTEM password:
Enter the WLSADMIN password:

Please wait. Validating credentials...

RUN file system context file: /u01/app/appti/TR122I/fs1/inst/apps/TR122I_nsmltcstrg02/appl/admin/TR122I_nsmltcstrg02.xml
PATCH file system context file: /u01/app/appti/TR122I/fs2/inst/apps/TR122I_nsmltcstrg02/appl/admin/TR122I_nsmltcstrg02.xml

************* Start of  session *************
version: 12.2.0
started at: Sun Nov 17 2013 06:18:34

APPL_TOP is set to /u01/app/appti/TR122I/fs1/EBSapps/appl
...
...
..
         Calling: adpatch options=hotpatch,nocompiledb interactive=no console=no workers=2 restart=no abandon=yes defaultsfile=/u01/app/appti/TR122I/fs1/EBSapps/appl/admin/TR122I/adalldefaults.txt patchtop=/u01/app/appti/TR122I/fs1/EBSapps/appl/ad/12.0.0/patch/115/driver logfile=cleanup.log driver=ucleanup.drv
          ADPATCH Log directory: /u01/app/appti/TR122I/fs_ne/EBSapps/log/adop/6/cleanup_20131117_061759/TR122I_nsmltcstrg02/log
        [EVENT]     [END   2013/11/17 06:20:07] Running CLEANUP ddls in ddl handler table
        [EVENT]     Cleaning up ABORT DDL from DDL Handler Table
        [START 2013/11/17 06:20:12] Generating All DDL Report
            [EVENT]     Report: /u01/app/appti/TR122I/fs1/EBSapps/appl/ad/12.0.0/sql/ADZDALLDDLS.sql

            [EVENT]     Output: /u01/app/appti/TR122I/fs_ne/EBSapps/log/adop/6/cleanup_20131117_061759/TR122I_nsmltcstrg02/adzdallddls_20131117_062014.out

        [END   2013/11/17 06:20:15] Generating All DDL Report
        [EVENT]     Calling cleanup in QUICK mode
        [WARNING]   Cleanup may take a while. Please wait.
...
...
..
        [END   2013/11/17 06:20:15] Generating All DDL Report
        [EVENT]     Calling cleanup in QUICK mode
        [WARNING]   Cleanup may take a while. Please wait.
      [EVENT]     [END   2013/11/17 06:51:33] Performing Cleanup steps
    [END   2013/11/17 06:51:39] cleanup phase
    [START 2013/11/17 06:51:43] 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/6/cleanup_20131117_061759/TR122I_nsmltcstrg02/adzdshowlog.out

    [END   2013/11/17 06:51:48] Generating AD_ZD_LOGS Report
  [END   2013/11/17 06:51:48] adzdoptl.pl run
  adop phase=cleanup - Completed Successfully

  Log file: /u01/app/appti/TR122I/fs_ne/EBSapps/log/adop/6/adop_20131117_061759.log

adop exiting with status = 0 (Success)

5. Post-Update Steps


Synchronize the 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

[appti@nsmltcstrg02 ~]$  adop phase=fs_clone

Enter the APPS password:
Enter the SYSTEM password:
Enter the WLSADMIN password:

Please wait. Validating credentials...

RUN file system context file: /u01/app/appti/TR122I/fs1/inst/apps/TR122I_nsmltcstrg02/appl/admin/TR122I_nsmltcstrg02.xml
PATCH file system context file: /u01/app/appti/TR122I/fs2/inst/apps/TR122I_nsmltcstrg02/appl/admin/TR122I_nsmltcstrg02.xml

************* Start of  session *************
version: 12.2.0
started at: Sun Nov 17 2013 06:54:38

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

          [EVENT]     [END   2013/11/17 08:08:07] Check and Stop Patch FS Admin Server
    [START 2013/11/17 08:08:09] 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/7/fs_clone_20131117_065412/TR122I_nsmltcstrg02/adzdshowlog.out

    [END   2013/11/17 08:08:14] Generating AD_ZD_LOGS Report
  [END   2013/11/17 08:08:14] adzdoptl.pl run
  adop phase=fs_clone - Completed Successfully

  Log file: /u01/app/appti/TR122I/fs_ne/EBSapps/log/adop/7/adop_20131117_065412.log

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

This concludes R12.2.2 Upgrade…