Oracle E-Business Suite R12.2.14 Upgrade Guide

Overview

This comprehensive guide outlines the step-by-step process for updating Oracle E-Business Suite to Release 12.2.14, including all prerequisite patches, database updates, and post-upgrade validation steps.

6.1 Apply Required Database Patches

Prerequisites

Download the latest EBS Technology Code Level Checker (ETCC) patch (Patch 17537119). The ETCC patch is regularly updated, so recommended patches may vary over time.

Step 1: Source Database Environment and Run ETCC

Navigate to the ETCC directory and execute the database check script:

[oracle@fbsebs etcc]$ pwd
/u01/patches/etcc

[oracle@fbsebs etcc]$ unzip p17537119_R12_GENERIC.zip
[oracle@fbsebs etcc]$ ./checkDBpatch.sh

This identifies all missing patches required for your database environment.

Step 2: Download and Apply Required Patches

Download the consolidated patch bundle Patch 36925840 - EBS Release 12.2 Consolidated Database Fixes for OCT 2024.

Important: Ensure both Database and Application services are stopped before applying patches.

[oracle@fbsebs 12c]$ pwd
/u01/patches/db/etcc-bundle/LINUX_X86-64/database/12.1.0.2

[oracle@fbsebs 12c]$ ls -alt
total 10160
-rw-r--r--. 1 oracle oinstall 3439648 Sep 17 23:06 p33649800_121020_Linux-x86-64.zip
-rw-r--r--. 1 oracle oinstall 2236220 Sep 17 23:05 p32901495_121020_Linux-x86-64.zip
# ... additional patch files

[oracle@fbsebs 12c]$ unzip '*.zip'

Step 3: Apply Individual Patches

Navigate to each patch directory and apply using OPatch:

[oracle@fbsebs 12c]$ cd 8975044/
[oracle@fbsebs 8975044]$ opatch apply

[oracle@fbsebs 12c]$ cd 32901495/
[oracle@fbsebs 32901495]$ opatch apply

# Repeat for all patches listed in the ETCC output

Step 4: Verify All Patches Applied

Re-run the ETCC check to validate successful application:

[oracle@fbsebs etcc]$ ./checkDBpatch.sh

Expected confirmation:

All the required one-off bugfixes are present in database ORACLE_HOME.

Step 5: Start Database and Run datapatch

[oracle@fbsebs OPatch]$ sqlplus / as sysdba

SQL> startup
SQL> exit

[oracle@fbsebs OPatch]$ ./datapatch

datapatch Output:

SQL Patching tool version 12.2.0.0.0
Connecting to database...OK
Installation queue:
  The following patches will be applied:
    18793246 ()
    20887355 ()
    21321429 ()
    25599890 ()
    28653113 ()
    32901495 ()
    33649800 ()
    
Installing patches...
Patch installation complete. Total patches installed: 7

Restart the Database and re-run checkDBpatch.sh to confirm all database-level patches are applied.

6.2 Set Database Parameters

Configure the following database parameters for optimal performance:

SQL> alter system set optimizer_adaptive_features=false;
System altered.

SQL> alter system set "_disable_actualization_for_grant"=true;
System altered.

Verification:

SQL> show parameter optimizer_adaptive_features
NAME                                TYPE       VALUE
------------------------------------ ----------- ------------------------------
optimizer_adaptive_features         boolean    FALSE

SQL> show parameter _disable_actualization_for_grant
NAME                                TYPE       VALUE
------------------------------------ ----------- ------------------------------
_disable_actualization_for_grant    boolean    TRUE

6.3 Apply Consolidated Seed Table Upgrade Patch

Note: Skip this step if you upgraded to Release 12.2.0 using the latest Consolidated Upgrade Patch 34754463:12.2.0 (CUP15) or earlier versions:
Patch 28853097:12.2.0 (CUP10)
Patch 26924710:12.2.0 (CUP9)
Patch 24690520:12.2.0 (CUP8)

Application Tier Preparation

Stop all application tier services on the run file system:

[applmgr@fbsebs ~]$ sh $ADMIN_SCRIPTS_HOME/adstpall.sh

Start only the Oracle WebLogic Admin Server:

[applmgr@fbsebs ~]$ sh $ADMIN_SCRIPTS_HOME/adadminsrvctl.sh start

Apply Seed Table Upgrade Patch

Apply Patch 34754463 using hotpatch mode:

[applmgr@fbsebs op]$ adop phase=apply patches=34754463 hotpatch=yes

Validate successful patch application before proceeding.

6.4 Apply Latest AD and TXK Delta Release Update Packs

The latest RUPs are:

R12.AD.C.Delta.16 (Patch 36119925)
R12.TXK.C.Delta.16 (Patch 36117775)

Step 1: Source Run Edition Environment

[applmgr@fbsebs ~]$ . $RUN_EDITION_FILE

Step 2: Start WebLogic Admin Server

[applmgr@fbsebs ~]$ sh $ADMIN_SCRIPTS_HOME/adadminsrvctl.sh start

Step 3: Execute adgrants

Follow instructions in the Patch 36119925 readme, which includes the latest version of adgrants:

SQL> @$ORACLE_HOME/appsutil/admin/adgrants.sql apps

SQL> ALTER USER EBS_SYSTEM ACCOUNT UNLOCK;
SQL> ALTER USER SYSTEM IDENTIFIED BY K0Junga#;
SQL> ALTER USER EBS_SYSTEM IDENTIFIED BY K0Junga#;

Step 4: Apply AD Delta Patch

[applmgr@fbsebs patch]$ adop phase=apply patches=36119925 hotpatch=yes

Step 5: Apply TXK Delta Patch

[applmgr@fbsebs patch]$ adop phase=apply patches=36117775 hotpatch=yes

Step 6: Apply Additional Critical Patches

[applmgr@fbsebs patch]$ adop phase=apply patches=31904550 merge=yes hotpatch=yes

Verify all patches are applied successfully before proceeding.

6.5 Apply Other Important Patches

Apply Patch 19259764:R12.FND.C:

[applmgr@fbsebs patch]$ adop phase=apply patches=19259764 hotpatch=yes

6.6 Run Middle Tier ETCC (MT-ETCC)

Step 1: Source Run File System

[applmgr@fbsebs ~]$ . $RUN_EDITION_FILE

Step 2: Run MT-ETCC

[applmgr@fbsebs etcc]$ ./checkMTpatch.sh

All reported patches can be applied later for the Middle Tier application.

6.7 Apply RUP for 12.2.14

Step 1: Source Run Edition Environment

[applmgr@fbsebs ~]$ . $RUN_EDITION_FILE

Step 2: Stop WebLogic Services

[applmgr@fbsebs ~]$ sh $ADMIN_SCRIPTS_HOME/adadminsrvctl.sh stop
[applmgr@fbsebs ~]$ sh $ADMIN_SCRIPTS_HOME/adnodemgrctl.sh stop

Step 3: Apply 12.2.14 Release Update Pack

Apply Patch 36026788 using downtime mode:

[applmgr@fbsebs patch]$ adop phase=apply apply_mode=downtime patches=36026788

Note: This process typically takes approximately 14 hours to complete.

6.8 Complete the Patching Cycle

Source the environment and run cleanup:

[applmgr@fbsebs ~]$ . /u01/app/FBS/EBSapps.env run
[applmgr@fbsebs patch]$ adop phase=cleanup

6.9 Apply Online Help Patch

Apply Patch 36026775 using hotpatch mode:

[applmgr@fbsebs patch]$ adop phase=apply patches=36026775 hotpatch=yes
[applmgr@fbsebs patch]$ adop phase=cleanup

Important: A new patching cycle session will be opened at this stage. Ensure tablespaces have sufficient free space.

6.10 Update Database Tier to Latest Code

Step 1: Generate appsutil.zip (Application Tier - applmgr user)

[applmgr@fbsebs ~]$ . $RUN_EDITION_FILE
[applmgr@fbsebs ~]$ perl $AD_TOP/bin/admkappsutil.pl

Step 2: Transfer and Unzip appsutil.zip (Database Tier - oracle user)

[oracle@fbsebs ~]$ cd $ORACLE_HOME
[oracle@fbsebs $ORACLE_HOME]$ unzip -o appsutil.zip

Step 3: Run AutoConfig on Database Tier

[oracle@fbsebs admin]$ cd $ORACLE_HOME/appsutil/scripts/`hostname`
[oracle@fbsebs hostname]$ ./adautocfg.sh

Enter the APPS user password:

AutoConfig completed successfully.

Step 4: Run AutoConfig on Application Run File System

[applmgr@fbsebs ~]$ . $RUN_EDITION_FILE
[applmgr@fbsebs ~]$ adautocfg.sh

Enter the APPS user password:

AutoConfig completed successfully.

6.11 Synchronize the File Systems

[applmgr@fbsebs ~]$ adop phase=fs_clone

Post-Upgrade Validation

Verify the successful upgrade to 12.2.14:

SQL> select release_name from apps.fnd_product_groups;

RELEASE_NAME
--------------------------------------------------
12.2.14

Confirm all services are running correctly.

Important Notes

Prerequisite Knowledge

Ensure database and application services are stopped before database patching
All tablespaces must have sufficient free space
Review each patch's README for any special instructions

Known Issues

Reference: https://www.funoracleapps.com/2020/12/the-server-is-not-able-to-service-this.html

References

Oracle E-Business Suite Release 12.2.10 Readme (Doc ID 2666934.1)
Document 1617461.1: Applying the Latest AD and TXK Release Update Packs
Doc ID 1594274.1: Special instructions for database patches
Doc ID 2161861.1: Super-set patch conflicts

This document provides a comprehensive guide for upgrading Oracle E-Business Suite to Release 12.2.14. Always refer to official Oracle documentation for the most current procedures and requirements.

Pages

6a. Upgrade Oracle EBS R12.2.0 to R12.2.14 on 12.1.0 database

Oracle E-Business Suite R12.2.14 Upgrade Guide

Overview

6.1 Apply Required Database Patches

Prerequisites

Step 1: Source Database Environment and Run ETCC

Step 2: Download and Apply Required Patches

Step 3: Apply Individual Patches

Step 4: Verify All Patches Applied

Step 5: Start Database and Run datapatch

6.2 Set Database Parameters

6.3 Apply Consolidated Seed Table Upgrade Patch

Application Tier Preparation

Apply Seed Table Upgrade Patch

6.4 Apply Latest AD and TXK Delta Release Update Packs

Step 1: Source Run Edition Environment

Step 2: Start WebLogic Admin Server

Step 3: Execute adgrants

Step 4: Apply AD Delta Patch

Step 5: Apply TXK Delta Patch

Step 6: Apply Additional Critical Patches

6.5 Apply Other Important Patches

6.6 Run Middle Tier ETCC (MT-ETCC)

Step 1: Source Run File System

Step 2: Run MT-ETCC

6.7 Apply RUP for 12.2.14

Step 1: Source Run Edition Environment

Step 2: Stop WebLogic Services

Step 3: Apply 12.2.14 Release Update Pack

6.8 Complete the Patching Cycle

6.9 Apply Online Help Patch

6.10 Update Database Tier to Latest Code

Step 1: Generate appsutil.zip (Application Tier - applmgr user)

Step 2: Transfer and Unzip appsutil.zip (Database Tier - oracle user)

Step 3: Run AutoConfig on Database Tier

Step 4: Run AutoConfig on Application Run File System

6.11 Synchronize the File Systems

Post-Upgrade Validation

Important Notes

Prerequisite Knowledge

Known Issues

References

No comments:

Post a Comment