27 December 2013

Step by Step Oracle E-Business Suite R12.2.2 to R12.2.3 upgrade

Step by Step Oracle E-Business Suite R12.2.0 to R12.2.2 upgrade


Oracle E-Business Suite Release 12.2.3 Readme (Doc ID 1586214.1)

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


Apply Consolidated Seed Table Upgrade Patch (Required)

Only for R12.2.0

 Applying the 12.2.3 AD and TXK Release Update Packs

 New Installation Customers       Path-A

 Existing R12.2 RUP Customers (EBS Release 12.2.2 or higher level)        Path-B


 Path -A 

 Source the run edition environment file.
 
 $ . <RUN_BASE>/EBSapps/appl/APPS <CONTEXT_NAME>.env

 Run adgrants.

 Download and unzip Oracle Applications DBA 12.2.3 Product Release Update Pack (R12.AD.C.Delta.3) , Patch 17023760.

 Follow the instructions in the patch readme to execute adgrants.

 Apply R12.AD.C.DELTA.3 Patch 17023760 in hotpatch mode on Run Edition Application File System:

 $ adop phase=apply patches=17023760 hotpatch=yes

 Apply R12.TXK.C.DELTA.3 Patch 17021789 in hotpatch mode on Run Edition Application File System:

 $ adop phase=apply patches=17021789 hotpatch=yes

 Instantiate the Oracle HTTP Server configuration files admin.conf, ssl.conf, mod_wl_ohs.conf on Run File System.

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


Synchronize the patch file system

$ adop phase=fs_clone


PATH B - Existing 12.2 RUP level customers


Source the run edition environment file.
 
 $ . <RUN_BASE>/EBSapps/appl/APPS <CONTEXT_NAME>.env

 Run adgrants.

 Download and unzip Oracle Applications DBA 12.2.3 Product Release Update Pack (R12.AD.C.Delta.3) , Patch 17023760.

 Follow the instructions in the patch readme to execute adgrants.

 SQL> @@/u01/R12.2/other/17023760/admin/adgrants.sql APPS
 Connected.


 Apply R12.AD.C.DELTA.3 Patch 17023760  on Run Edition Application File System:

 $ adop phase=apply patches=17023760

 Apply R12.TXK.C.DELTA.3 Patch 17021789  on Run Edition Application File System:

 $ adop phase=apply patches=17021789

 Instantiate the Oracle HTTP Server configuration files admin.conf, ssl.conf, mod_wl_ohs.conf on Run File System.

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

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

Source the run edition environment file:

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

$ adop phase=finalize
$ adop phase=cutover
$ adop phase=cleanup

Synchronize file systems (Conditional)

$ adop phase=fs_clone


Apply the 12.2.3 Suite-Wide Release Update Pack


Source the run edition applications environment.

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

Start an online patching cycle.

$ adop phase=prepare

Apply 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

Instantiate the Oracle HTTP Server configuration files admin.conf, ssl.conf, and mod_wl_ohs.conf.
Source the patch edition environment file:


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

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

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

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

$ adop phase=finalize
$ adop phase=cutover
$ adop phase=cleanup


 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

Grant flexfield value set access to specific users (conditional)

Release 12.2 includes a new security feature, flexfield value set security; it controls who can create or modify flexfield values in the Flexfield Values Setup window (FNDFFMSV). Flexfield value set security requires some mandatory setup steps before any users can create or update values in the Values window. You must perform this step if you have not already done so for a previous version of Release 12.2.

Note: See the 'Flexfield Value Set Security' chapter in Oracle® E-Business Suite Flexfields Guide, Release 12.2 (Part No. E22963-07).

Perform Product-Specific Steps (conditional)
After you have completed the steps to update all database tier nodes with the latest code level, perform the following post-update steps only if you have licensed this product:

HR Legislative customers only: refer to the step "Latest legislation data update (Hrglobal installation)" from the readme of the patch "Oracle E-Business Suite Release 12.2.3 Patch 17020683."
Oracle E-Business Suite Extensions for Oracle Endeca customers: Refer to Installing Oracle E-Business Suite Extensions for Oracle Endeca, Release 12.2 V4 Document 1574273.1 for the complete installation and configuration steps.





No comments: