Comprehensive Guide to Applying Oracle E-Business Suite 12.2 Database and Technology Patches

Overview

This article provides a comprehensive, step-by-step guide for applying required database and technology patches to Oracle E-Business Suite (EBS) Release 12.2 environments. The process covers everything from initial patch identification through post-implementation validation, ensuring a smooth and successful patching experience.

1. Database Patching

1.1 Determine the Latest Database PSU

Before beginning the patching process, identify the latest recommended Database Release Update (RU) for EBS 12.2 by consulting MOS Note 1594274.1: Oracle E-Business Suite Release 12.2: Consolidated List of Patches and Technology Bug Fixes.

Search within the document for the pattern "recommended Release Update" to identify the current patches. For example, the following patches represent a recent update:

Patch Number	Description
34419443	Database Release Update 19.17.0.0.221018
34411846	Oracle JavaVM Component Release Update 19.17.0.0.221018

1.2 Download and Install Latest OPatch

OPatch must be updated before applying any patches to prevent unexpected issues:

$ cd $ORACLE_HOME
$ mv OPatch/ OPatch_bkp
$ cp ~/patches/p6880880_190000_Linux-x86-64.zip .
$ unzip p6880880_190000_Linux-x86-64.zip

1.3 Verify Patch Conflicts

Check for conflicts against the current Oracle Home:

$ cd 34419443
$ opatch prereq CheckConflictAgainstOHWithDetail -ph ./
# Expected output: Prereq "checkConflictAgainstOHWithDetail" passed.

$ cd 34411846
$ opatch prereq CheckConflictAgainstOHWithDetail -ph ./
# Expected output: Prereq "checkConflictAgainstOHWithDetail" passed.

If conflicts are detected, consult My Oracle Support documents, use the Patch Conflict Checker Tool, or create an Oracle Service Request for assistance.

1.4 Shutdown Application and Database Services

Properly shut down all services before applying patches:

# Stop application services
$ . /u01/install/APPS/EBSapps.env run
$ cd $ADMIN_SCRIPTS_HOME
$ ./adstpall.sh

# Shut down database
$ . /u01/install/APPS/19c/CDBVIS_demo.env
$ echo "shu immediate"|sqlplus '/as sysdba'
$ lsnrctl stop $ORACLE_SID

1.5 Apply Patches with OPatch

Use the screen utility to preserve the session in case of network interruptions:

$ screen -S patching

# Apply Database Release Update
$ cd 34419443
$ opatch apply
$ egrep -i "error|fail|ORA-|ac-|rc-" /u01/install/APPS/12.1.0/cfgtoollogs/opatch/opatch*.log

# Apply JavaVM Component Update
$ cd 34411846
$ opatch apply
$ egrep -i "error|fail|ORA-|ac-|rc-" /u01/install/APPS/12.1.0/cfgtoollogs/opatch/opatch*.log

1.6 Load Modified SQL Files

Run datapatch to apply SQL changes. For a multitenant database:

SQL> sqlplus '/as sysdba'
SQL> startup upgrade
SQL> alter pluggable database all open upgrade;
SQL> quit;

$ cd $ORACLE_HOME/OPatch
$ ./datapatch -verbose

SQL> sqlplus '/as sysdba'
SQL> shutdown immediate
SQL> startup
SQL> alter pluggable database all open;

For a standalone database:

SQL> sqlplus '/as sysdba'
SQL> startup upgrade

$ cd $ORACLE_HOME/OPatch
$ ./datapatch -verbose

SQL> sqlplus '/as sysdba'
SQL> shutdown immediate;
SQL> startup

1.7 Recompile Invalid Objects

Multitenant database:

$ORACLE_HOME/perl/bin/perl $ORACLE_HOME/rdbms/admin/catcon.pl --n 1 --e -l /tmp --b utlrp --d $ORACLE_HOME/rdbms/admin utlrp.sql

Standalone database:

$ cd $ORACLE_HOME/rdbms/admin
$ sqlplus '/as sysdba'
SQL> @utlrp.sql

2. ETCC Tool for EBS 12.2 Patches

The EBS Technology Codelevel Checker (ETCC) tool helps identify required mandatory patches. Download Patch 36616672: EBS RELEASE 12.2 CONSOLIDATED FMW FIXES FOR JUL 2024.

3. Apply WebLogic Server (WLS) PSU

3.1 Start a New Patching Cycle

Set up password variables for convenience:

$ read -s appspass
$ read -s systempass
$ read -s wlspass

Start the patching cycle (WLS admin server starts automatically on the run file system):

{ echo $appspass; echo $systempass; echo $wlspass; }|adop phase=prepare

3.2 Remove Conflicting Patches

{
. ~/EBSapps.env patch
cd $FMW_HOME/utils/bsu
$FMW_HOME/utils/bsu/bsu.sh -prod_dir=$FMW_HOME/wlserver_10.3 -status=applied -verbose -view
$FMW_HOME/utils/bsu/bsu.sh -remove -patchlist=TTGM,6VAM -prod_dir=$FMW_HOME/wlserver_10.3
$FMW_HOME/utils/bsu/bsu.sh -remove -patchlist=21Y4 -prod_dir=$FMW_HOME/wlserver_10.3
}

3.3 Apply WLS Patch Set Update

Apply Patch 34009030: WLS Patch Set Update 10.3.6.0.220719 (RAWM):

{
. ~/EBSapps.env patch
cp /stage/patches/WLS_RUP/RAWM.jar $FMW_HOME/utils/bsu/cache_dir/
cp /stage/patches/WLS_RUP/patch-catalog_27884.xml $FMW_HOME/utils/bsu/cache_dir/
cd $FMW_HOME/utils/bsu
$FMW_HOME/utils/bsu/bsu.sh -install -patch_download_dir=$FMW_HOME/utils/bsu/cache_dir -patchlist=RAWM -prod_dir=$FMW_HOME/wlserver_10.3
}

Verify the version after application:

$ . $FMW_HOME/wlserver_10.3/server/bin/setWLSEnv.sh
$ java weblogic.version
# Expected: WebLogic Server 10.3.6.0.220719 PSU Patch for BUG33172858

4. Apply Database ETCC Patches

4.1 Run ETCC Report on Database Tier

Execute the latest version of ETCC via Patch 17537119:

$ cd /stage/patches/ETCC
$ ./checkDBpatch.sh

The report will list missing patches. Shut down the database, identify and roll back conflicting patches:

$ echo "shu immediate"|sqlplus '/as sysdba'
$ lsnrctl stop $ORACLE_SID

$ unzip 'p*zip'
$ cd [patch number]
$ opatch prereq CheckConflictAgainstOHWithDetail -ph ./
{
opatch rollback -id <patch_id> -silent
}

4.2 Apply Database ETCC Patches

Apply all identified patches:

$ cd [patch number]
$ opatch apply
$ egrep -i "error|fail|ORA-|ac-|rc-" <log_file>

4.3 Post-Installation Tasks

Run datapatch and recompile invalid objects:

$ lsnrctl start $ORACLE_SID
$ cd $ORACLE_HOME/OPatch
$ echo "startup"|sqlplus '/as sysdba'
$ ./datapatch -verbose

Recompile invalid objects:

Multitenant:

$ORACLE_HOME/perl/bin/perl $ORACLE_HOME/rdbms/admin/catcon.pl --n 1 --e -l /tmp --b utlrp --d $ORACLE_HOME/rdbms/admin utlrp.sql

Standalone:
sql
```
SQL> @?/rdbms/admin/utlrp.sql
```

Re-run ETCC to confirm all patches are applied:

$ . ~/FBS_database.env
$ ./checkDBpatch.sh
# Expected: All the required one-off bugfixes are present

4.4 Set Database Parameters

Adjust the following parameters based on your database version:

For Database 12.1.0.2 only:

optimizer_adaptive_features=false

For Database 11.2.0.4, 12.1.0.2, and 19c:

"_disable_actualization_for_grant"=true

Apply the settings:

SQL> alter system set "_disable_actualization_for_grant"=true;
SQL> alter system set optimizer_adaptive_features=false;

5. Apply Application Tier ETCC Patches

5.1 Run ETCC Report on MT Tier

Execute the ETCC report on the application tier:

$ cd /stage/patches/ETCC
$ ./checkMTpatch.sh

The report will generate a patch recommendation summary similar to:

Component	Patch Recommendations
Oracle Forms and Reports 10.1.2.3.0	32922089, 25342269, 27491934
FMW - Web Tier 11.1.1.9.0	22288381, 35540062, 32287205, 23716938, 32928416, 33144848, 34067016
FMW - Web Tier 11.1.0.7.0	22290164
FMW - Oracle Common 11.1.1.9.0	9905685, 17428617, 21366277, 21628307, 24606362, 24843064, 13544814, 33974106, 16089637, 20141119, 34330735, 27212806, 28708563, 26933408, 33960746, 34714760

Note: A consolidated zip file with required application tier patches is available via Patch 36616672: EBS RELEASE 12.2 CONSOLIDATED FMW FIXES FOR JUL 2024.

5.2 Apply FMW - Web Tier Patches

Extract the latest OPatch and set the environment:

$ . /u01/app/UAT/EBSapps.env patch
$ . $FMW_HOME/SetWebtier.env
$ cd $ORACLE_HOME
$ scp -r /u01/app/UAT/fs_ne/EBSapps/patch/OPatch .

Apply the patches in the specified order:

$ cd /path/to/patch/22288381
$ opatch apply
$ cd ../35540062
$ opatch apply
$ cd ../32287205
$ opatch apply
$ cd ../23716938
$ opatch apply
$ cd ../32928416
$ opatch apply
$ cd ../33144848
$ opatch apply
$ cd ../34067016
$ opatch apply
$ cd ../22290164
$ opatch apply

Important: The 32287205 patch requires following MOS Note 2555355.1 before application.

5.3 Apply FMW - Oracle Common Patches

Set the environment for Oracle Common:

$ . ~/EBSapps.env patch
$ . $FMW_HOME/SetOracleCommon.env
$ cd $ORACLE_HOME
$ mv OPatch/ OPatch_bkp
$ cp ~/patches/p6880880_111000_Linux-x86-64.zip .
$ unzip p6880880_111000_Linux-x86-64.zip
$ rm -f p6880880_111000_Linux-x86-64.zip

Apply the patches in order:

$ cd /path/to/patch/9905685
$ opatch apply
$ cd ../17428617
$ opatch apply
$ cd ../21366277
$ opatch apply
$ cd ../21628307
$ opatch apply
$ cd ../24843064
$ opatch apply
$ cd ../13544814
$ opatch apply
$ cd ../33974106
$ opatch apply
$ cd ../16089637
$ opatch apply
$ cd ../20141119
$ opatch apply
$ cd ../34330735
$ opatch apply
$ cd ../27212806
$ opatch apply
$ cd ../28708563
$ opatch apply
$ cd ../26933408
$ opatch apply
$ cd ../33960746
$ opatch apply
$ cd ../34714760
$ opatch apply

5.4 Update WebLogic Server Patching Tool

Download and apply Patch 35710802 to update the WLS 10.3.6 Patching tool:

$ cd $FMW_HOME/utils/bsu
$ ./bsu_update.sh install
# Expected: Installing Smart Update V4... Update was successful.

5.5 Apply WebLogic Server 10.3.6.0.231017

$ cd /u01/app/UAT/fs1/FMW_Home/utils/bsu
$ unzip -o p35710802_R12_GENERIC.zip

Remove conflicting patches:

$ bsu.sh -remove -patchlist=1LRI,2GYW,CW9T,VKXF,BLTG -prod_dir=/u01/app/UAT/fs1/FMW_Home/wlserver_10.3
$ bsu.sh -remove -patchlist=VKXF,Y5AP,FCX7,YVDZ,YHJK -prod_dir=/u01/app/UAT/fs1/FMW_Home/wlserver_10.3
$ bsu.sh -remove -patchlist=CIH8 -prod_dir=/u01/app/UAT/fs1/FMW_Home/wlserver_10.3

Install the WLS patch:

$ bsu.sh -install -patchlist=E7HI -prod_dir=/u01/app/UAT/fs1/FMW_Home/wlserver_10.3

Install overlay patches:

$ bsu.sh -install -patchlist=7BIA,7FC9,32I2,DI8E,ENUU,KMHV,S8H6,S9MN,TTEM,WY44 -prod_dir=/u01/app/UAT/fs1/FMW_Home/wlserver_10.3

5.6 Apply Oracle Forms and Reports Patches

Set the environment and apply patches:

$ . EBSapps.env patch
$ export PATH=$ORACLE_HOME/OPatch:$PATH

Apply each patch:

$ cd 32922089
$ opatch apply
$ cd ../25342269
$ opatch apply
$ cd ../27491934
$ opatch apply

5.7 Re-run ETCC Report

Confirm all required patches are present:

$ . ~/EBSapps.env patch
$ ./checkMTpatch.sh
# Expected: All required one-offs are confirmed as present

6. Apply Consolidated Seed Table Upgrade

Note: This step applies only to:
New installation customers
Customers upgrading from EBS Release 12.2.2 to 12.2.12

Skip this step for existing installations (e.g., 12.2.11) as documented in Patch 34754463: 12.2.0 (CUP15) or earlier Consolidated Upgrade Patches.

7. Apply Latest AD and TXK Delta RUPs

Reference: MOS Note 1617461.1 - Applying the Latest AD and TXK Release Update Packs to Oracle E-Business Suite Release 12.2

7.1 Patch Research

Identify the latest patches:

36119925: R12.AD.C.Delta.16
36117775: R12.TXK.C.Delta.16

7.2 Pre-steps - Execute adgrants Script

Create the directory on the database server:
bash
```
$ mkdir -p $ORACLE_HOME/appsutil/admin
```

Compare adgrants.sql versions:

$ grep '$Header' $ORACLE_HOME/appsutil/admin/adgrants.sql
$ grep '$Header' /stage/patches/EBS12.2/ADTKX/36119925/admin/adgrants.sql

Copy the higher version:

$ cp -iv /stage/patches/EBS12.2/ADTKX/36119925/admin/adgrants.sql $ORACLE_HOME/appsutil/admin

Set the environment:

$ . ~/CDBVIS_demo.env
$ export ORACLE_PDB_SID=FBS

Run the script:

$ sqlplus /nolog
SQL> @$ORACLE_HOME/appsutil/admin/adgrants.sql APPS

Note: ORA-00942 and ORA-04042 warnings can be safely ignored per MOS Note 2507343.1.

7.3 Apply AD and TXK Patches

Set up passwords and check status:

$ read -s appspass
$ read -s systempass
$ read -s wlspass

$ . ~/EBSapps.env run
$ echo $appspass|adop -status -detail

Apply AD patch (without merge=yes):

$ adop phase=apply patches=36119925 hotpatch=yes

Apply TXK patch (without merge=yes):

$ adop phase=apply patches=36117775 hotpatch=yes

7.4 Update Database Tier

This step will be performed after all EBS patches are applied and file system cutover is completed.

8. Apply Oracle E-Business Suite 12.2.X Release Update Pack

For existing customers on Release 12.2.11, follow Path B.

8.1 Apply Patches with adop

{ echo $appspass; echo $systempass; echo $wlspass; }|adop phase=apply patches=33527700 patchtop=/stage/patches/EBS12212_upgrade workers=8

8.2 Apply Online Help

{ echo $appspass; echo $systempass; echo $wlspass; }|adop phase=apply patches=33527707 patchtop=/stage/patches/Online_help_12212 workers=4

8.3 Check Log Files for Errors

$ adopscanlog -latest=yes
$ egrep -i "error|warning|fail|ora-|ac-|rc-" /u01/install/APPS/fs_ne/EBSapps/log/adop/*/apply/apps/*/log/[adop_log_file].log

8.4 Complete the Patching Cycle

$ { echo $appspass; echo $systempass; echo $wlspass; }| adop phase=finalize
$ { echo $appspass; echo $systempass; echo $wlspass; }| adop phase=cutover
$ . ~/EBSapps.env run
$ { echo $appspass; echo $systempass; echo $wlspass; }| adop phase=cleanup
$ { echo $appspass; echo $systempass; echo $wlspass; }| adop phase=fs_clone

9. Post-Implementation Steps

9.1 Compile Invalid Objects

$ORACLE_HOME/perl/bin/perl $ORACLE_HOME/rdbms/admin/catcon.pl --n 1 --e -l /tmp --b utlrp --d $ORACLE_HOME/rdbms/admin utlrp.sql

9.2 Verify Security Configurations

http(s)://[host]:[port]/OA_HTML/AppsLocalLogin.jsp

Navigate to the console and unlock the system.

9.3 Update Database Tier to Latest Code

Create the appsutil.zip file:
bash
```
$ perl $AD_TOP/bin/admkappsutil.pl
```

As the Oracle user, unzip the file:

$ cd $ORACLE_HOME
$ unzip -o appsutil.zip

Run AutoConfig on the database tier:

$ORACLE_HOME/appsutil/scripts/$CONTEXT_NAME/adautocfg.sh
$ egrep -i "error|warning|fail|ora-|ac-|rc-" /u01/install/APPS/12.1.0/appsutil/log/*/adconfig.log

Run AutoConfig on the application tier:

$ sh $INST_TOP/admin/scripts/adautocfg.sh

10. Health Check

Restart application tier services and verify:

✓ EBS login works
✓ Forms open successfully
✓ Target concurrent processes equal actual concurrent processes
✓ Test concurrent requests complete successfully (e.g., "CP PLSQL Regression Test", "Active Users")
✓ Instance-specific components function correctly (e.g., Workflow Mailer)

References

Document ID	Description
2877607.1	Oracle E-Business Suite Release 12.2: Consolidated List of Oracle Fusion Middleware Patches and Technology Bug Fixes
1594274.1	Oracle E-Business Suite Release 12.2: Consolidated List of Oracle Database Patches and Technology Bug Fixes
2683670.1	Previous Oracle Database 19c Release Update Database Patch Lists for Oracle E-Business Suite
1147107.1	Database Patch Set Update Overlay Patches Required for Use with PSUs and Oracle E-Business Suite
1392527.1	Database Patches Required by Oracle E-Business Suite on Oracle Engineered Systems
2484000.1	Identifying the Latest Critical Patch Update for Oracle E-Business Suite Release 12
1617461.1	Applying the Latest AD and TXK Release Update Packs to Oracle E-Business Suite Release 12.2

Conclusion

This comprehensive patching guide ensures that your Oracle E-Business Suite 12.2 environment remains current with the latest security fixes and updates. Following these steps systematically will minimize downtime and reduce the risk of patching-related issues. Always consult the referenced My Oracle Support documents for the most up-to-date information and specific requirements for your environment.

Pages

8.a Oracle EBS 12.2.X Database and Middleware Upgrade Steps