Archive for January 2014

Upgrade R12.2 to R12.2.3   22 comments

In this post i will list out the steps for upgrading R12.2 to R12.2.3

Note:

If you are freshly installing R12.2. and downloading the stage from edelivery then you will get stardCD version 12.2.0.46, also  i would suggest you all to download startCD version 12.2.0.47 it includes lot of updates which will be helpful in reducing the R12.2.3 upgrade time. startCD version 12.2.0.47 is a patch with #17445880.

So when you are downloading the Media R12.2 Software,  you will get stardCD  12.2.0.46  from edelivery. In your downloads include new startdCD version 12.2.0.47 patch #17445880

1

Once you build the stage using buildstage.sh we need to update the Start Here DVD, uncompress the patch in the main staging area to overwrite the startCD directory.

unzip -o p17445880_R12_GENERIC.zip let the existing 12.2.0.46 get overwritten by 12.2.0.47 startCD patch

Now you must run the buildStage.sh script and select option 2. Copy new patches to current stage area from the Build Stage Menu:

Build Stage Menu
——————————————————
1.     Create new stage area
2.     Copy new patches to current stage area.
3.     Display existing files in stage TechPatches.
4.     Exit menu

Enter your choice [4]: 2

This will copy the latest technology patches to the shiphome. Failure to do this will cause the installation to fail during the Oracle Home patching phase.

If you dont download latest stardCD Patch 12.2.0.47 then as per pre-upgrade steps for R12.2.3 we need to apply below patches which are there in 12.2.0.47

For Database Oracle Home 11.2.0.3

Included in startCD Linux x86-64
12.2.0.46 12942119
N/A
N/A
13931044
14123213
16105745
16303726
16342486
16438289
16587934
12.2.0.47 13001379
16924879
16929165
16992075
17047617
17184721
17461865
17468141
17502060
Not included in any startCD 17875948 this is not included in stardCD patch 12.2.0.47

Forms and Reports 10.1.2.3 Patches and Bug Numbers

Included in startCD Linux x86-64
12.2.0.46 N/A
5917053
6371228
7016961
7121788
7140405
8339196
8528194
8557019
N/A
N/A
10152652
11780669
12379038
12837860
12848228
12887068
12898423
N/A
14353879
N/A
14374587
14825718
16209520
12.2.0.47 8300196
14703419
16207165
16241466
16271876
16778382
17303472
N/A

Patches and bug numbers for Version 10.1.0.5.0

Included in startCD Linux x86-64
12.2.0.46 3559326
5261796
5394728
5651245
6400501
7695070
12949905
16275529
12.2.0.47 4047619
5604120

Web Tier and Utilities (OHS) 11.1.1.6 Patches and Bug Numbers

 Patches and bug numbers for Version 11.1.1.6.0

Included in startCD Linux x86-64
12.2.0.46 10638758
13643211
14616819
16199894
12.2.0.47 17325559

Patches and bug numbers for Version 11.1.0.7

Included in startCD Linux x86-64
12.2.0.46 7695070
12949905

 Oracle Fusion Middleware Common 11.1.1.6 Patches and Bug Numbers

Patches and bug numbers for Oracle Fusion Middleware 11.1.1.6.0

Included in startCD Linux x86-64
12.2.0.46 13877559
14386347
14588599
16199894
12.2.0.47 12714567

Oracle Weblogic Server 10.3.6.0 Patch and Bug Numbers

Note: Oracle WebLogic Server patches are generic (not platform-specific).

Patches and bug numbers for Oracle Weblogic Server 10.3.6.0

Included in startCD Patch Number BSU Patch ID Bug Number
12.2.0.46 13572948 LL4G 13572948
13845626 YHJK 13845626
14272383 S9MN 14272383
14597598 VFS8 14597598
14621810 TTEM 14621810
13642485 32I2 13642485
12.2.0.47 13729611 YIJF 13729611
16083651 D33T 16083651
Not included in any startCD 17495356 CIH8 17220061, 17331802, 17351504

For more Information on the above patches please follow below metalink Note

Oracle E-Business Suite Release 12.2: Consolidated List of Patches and Technology Bug Fixes (Doc ID 1594274.1)

If you have not download 12.2.0.47 startCD and installed R12.2 with the media downloaded from edelivery then we need to apply all the patches which are mentioned above specific to 12.2.0.47 for R12.2.3 Upgrade.

For how to apply patches please follow below metalink note

Oracle E-Business Suite 12.2 Patching Technology Components Guide (Doc ID 1355068.1)

Once everything is done proceed with the upgrade steps

Step1

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.
  1. Stop all Application tier services on the Run File System
    sh $ADMIN_SCRIPTS_HOME/adstpall.sh

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

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

  3. $ adop phase=apply patches=17204589 hotpatch=yes
    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.

$ sh $ADMIN_SCRIPTS_HOME/adstrtal.sh

Step2

Applying the 12.2.3 AD and TXK Release Update Packs

Type of Installation Available Paths
Upgrade Customers (R11i, R12.0, R12.1 customer upgrading to 12.2.0) Path-A
New Installation Customers Path-A
Existing R12.2 RUP Customers (EBS Release 12.2.2 or higher level) Path-B

Note:This is a new installation of R12.2, For R12.2.3 upgrade I am following Path A. For more information please follow below metalink note

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

 Apply the 12.2.3 AD and TXK Release Update Packs

  1. Source the run edition environment file.

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

  1. Run adgrants.
    1. Download and unzip Oracle Applications DBA 12.2.3 Product Release Update Pack (R12.AD.C.Delta.3) , Patch 17023760.
    2. Follow the instructions in the patch readme to execute adgrants.
  2. Apply R12.AD.C.DELTA.3 Patch 17023760 in hotpatch mode on Run Edition Application File System:

$ adop phase=apply patches=17023760 hotpatch=yes

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

$ adop phase=apply patches=17021789 hotpatch=yes

  1. Instantiate the Oracle HTTP Server configuration files admin.conf, ssl.conf, mod_wl_ohs.conf on Run File System.
  2. Note: Since the templates are being instantiated, all customizations will be lost and have to be restored explicitly.
 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>.

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

  1. Start all Application Tier Services.

Start all Application Tier services from run file system using the adstrtal script as follows:

sh <ADMIN_SCRIPTS_HOME>/adstrtal.sh

  1. Synchronize the patch file system

Synchronize the patch file system using the command shown below. This action will copy the new run edition code and configuration to the other file system.

$ adop phase=fs_clone

 Step3:

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.

  1. Source the run edition applications environment.

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

  1. Start an online patching cycle.

$ adop phase=prepare

  1. Application Tier Technology Patches
  2. Apply Oracle E-Business Suite Release 12.2.3

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

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

  1. Source the patch edition environment file:

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

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

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

  1. $ adop phase=finalize
  2. $ adop phase=cutover
  3. $ adop phase=cleanup

Step4:

 Post-Update Steps

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

This finishes the R12.2.0 upgrade to R12.2.3

Let me know if anyone has any questions on this…..

References:

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

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

Oracle E-Business Suite Release 12.2: Consolidated List of Patches and Technology Bug Fixes (Doc ID 1594274.1)

Oracle E-Business Suite Release Notes, Release 12.2 (Doc ID 1320300.1)

Oracle E-Business Suite 12.2 Patching Technology Components Guide (Doc ID 1355068.1)

Advertisements

Posted January 29, 2014 by balaoracledba.com in R12.2

Oracle Released Critical patch update for Jan-2014   Leave a comment

http://www.oracle.com/technetwork/topics/security/alerts-086861.html

Posted January 15, 2014 by balaoracledba.com in Oracle DBA