Oracle E-Business Suite 12.2 CPU patching

In this particular blog, I have considered July 2022 CPU cycle, EBS version 12.2.10 and Database 19c.

Critical Patch Update Availability Document is available for each cycle in Oracle Support site (support.oracle.com).

Below is the PAD for July CPU.

Oracle E-Business Suite Release 12.2 Critical Patch Update Availability Document (July 2022) (Doc ID 2879380.1)               

If you have ASM Grid, then apply Grid patches followed by Database patches and at last Application patches.

PAD for Database CPU is mentioned within Doc ID 2879380.1, which is as below.

Critical Patch Update (CPU) Program Jul 2022 Patch Availability Document (DB-only) (Doc ID 2867871.1)              

List of Database patches to be applied:

1. Combo OJVM Release Update 19.16.0.0.220719 and Database Release Update 19.16.0.0.220719 Patch 34160831 for UNIX
2. OJVM Release Update 19.16.0.0.220719 Patch 34086870
3. JDK8u341Patch 34113634
4. Perl Patch 33912872

Database patching is not covered in detail in this particular blog but high level steps are mentioned below.

We just have to make sure to run conflict check for each patch which needs to be applied.

1. Download and unzip Database patches in DB server.
2. Go to patch directory and run below command to check conflicts.

opatch prereq CheckConflictAgainstOHWithDetail –ph .

If no conflict found, apply the patch with “opatch apply” command.

In case of conflict, either rollback the conflict patch or check with Oracle Support.

3. Once all the patches are applied, start the database and run below command to apply SQL changes.

  $ORACLE_HOME/OPatch/datapatch –verbose

Note : Make sure to apply patches in all the Nodes in case of multi Node env.

Datapatch –verbose is required to run only once from any of the node.

For the Application side patches, we can follow Doc ID 2879380.1 as mentioned above.

In R12.2, we also have to apply WLS and FMW patches apart from EBS patches. Oracle also releases JDK update every quarter.

EBS patches list :

Please note that there will be one main CPU patch followed by other critical patches.

Apart from that, there will be module/product specific patches, which have to be applied as per the products/module in use.

adop phase=prepare

adop phase=apply patches=34127951

adop phase=apply patches=34127951:u34127951.drv, 34127951_ESA:u34127951.drv

adop phase=apply patches=<patch1, patch2, patch3> merge=yes

Now we have to apply WLS and FMW patches.

Steps to apply FMW patches.

1. Source patch filesystem and download WLS patches under FMW_HOME/utils/bsu/cache_dir
2. Go to FMW_Home/utils/bsu and apply WLS patch (34105280)
3. Since it’ll have conflict with previous cycle WLS patch, we need to rollback that first.

./bsu.sh -remove -patchlist=TTGM,6VAM -prod_dir=$FMW_HOME/wlserver_10.3

After rollback, apply latest WLS patch.

./bsu.sh -install -patch_download_dir=$FMW_HOME/utils/bsu/cache_dir -patchlist=RAWM -prod_dir=$FMW_HOME/wlserver_10.3

4. Unzip patch 34105303 which contains WLS overlay patches and other FMW patches.

Go to FMW_Home/utils/bsu and apply overlay patch 13964737 and 13845626

./bsu.sh -install -patch_download_dir=$FMW_HOME/utils/bsu/cache_dir -patchlist=UCI6,N3YF -prod_dir=$FMW_HOME/wlserver_10.3

5. Apply WebTier patch 34251646

export ORACLE_HOME=$FMW_Home/webtier
export ORACLE_HOME=$FMW_Home/webtier
cd 34251646
opatch apply

6. Apply FMW Oracle Common Home patch 34330735

export ORACLE_HOME=$FMW_Home/oracle_common 
export PATH=$ORACLE_HOME/OPatch:$PATH
cd 34330735
opatch apply

Apart from these, if we get patches for other FMW components, we need to apply those too. For July CPU cycle, we have to apply only above listed patches.

 Lastly, we need to upgrade JDK.

 Patch 34170410: JDK 7 Update 351

Steps to upgrade JDK :

Download and unzip both 32bit and 64bit JDK patch for your respective platform.

• Upgrading to Latest Java 7.0 on Application Tier Nodes

cd $COMMON_TOP/util
mv jdk jdk_17341 (to take backup of existing jdk)

Now first extract 32bit of JDK and then 64bit.

tar –xvf jdk-7u351-solaris-sparc.tar.gz
tar –xvf jdk-7u351-solaris-sparcv9.tar.gz
mv jdk1.7.0_351 jdk

• Upgrading to Latest Java 7.0 in Oracle Fusion Middleware 11g Web Tier

cd $FMW_HOME/webtier
mv jdk jdk_17341
tar –xvf jdk-7u351-solaris-sparc.tar.gz
tar –xvf jdk-7u351-solaris-sparcv9.tar.gz
mv jdk1.7.0_351 jdk

Relink Forms and Reports Executables

With environment still set to ‘patch’

$ cd $ORACLE_HOME/forms/lib32
$ make -f ins_forms.mk sharedlib install
$ cd $ORACLE_HOME/reports/lib32
$ make -f ins_reports.mk install
$ cd $ORACLE_HOME/bin
$ relink all

Now Regenerate Oracle E-Business Suite Forms and Reports Executables from ADADMIN.

Check JDK version.

$ADJVAPRG –version

Run rest of the adop phases either one by one or all together.

adop phase=finalize,cutover,cleanup

Validate the Application by doing basic DBA sanity check.