Unable to successfully install the Oracle CPU due to missing prerequisites

Products

• Data Loss Prevention Oracle Standard Edition 2

Issue/Introduction

Downloaded the latest Oracle Critical Patch Update (CPU) from Broadcom Downloads, i.e. Oracle_19c_CPU2024APR_Win64.

Next, attempted to install the Oracle CPU using the opatch apply command as per the documented process, but the command failed with a message about a missing prerequisite - as in the example below:

Environment

Oracle 19c

Cause

Missing prerequisite (i.e. 36219938 for CPU2024APR) Patch from Oracle

opatch failed with error code = 73

Resolution

Please review the contents of the patch installation which contains the Readme for Oracle Database Patches text file

Below example screenshot shows internal contents of “Oracle_19c_CPU2024APR_Win64.zip :

Note: An Oracle CPU package contains several items which have to be installed in the right order, as described in the readme file included in the CPU zip. 

In this example, the error message is generated as OJVM installation was initiated and failed because it's missing a prerequisite patch “36219938”, which should be installed first.

As seen in the screenshot of contents, the missing patch 36219938 is also included in the CPU2024APR zip under the name of "ReleaseUpdate_19.23.0.0.0_2024APR_64bit_Win". The error output of the command shown earlier, as described in the readme in the install order, it will have to be installed first before the OJVM. 

Below is an example extract from the CPU2024APR readme file, which shows the order in which the patches have to be installed.:

1. OPatch_64bit_12.2.0.1.42 Utility required to install Oracle patches used by Oracle 12c through 19c
   
   
2. ReleaseUpdate_19.23.0.0.0_2024APR_64bit_Win Database Bundle Patch to update database software 19.3 through 19.22 to 19.23
   
   
3. OJVMUpdate_19.23.0.0.0_2024APR_64bit_Win Update for the Oracle JavaV
   
   
4. JDKupdate_19.0.0.0.0_8u411_64bit_Win Update the JDK under ORACLE_HOME

NOTE: Before installing the ReleaseUpdate database bundle patch, the previous OJVM update often has to be uninstalled first

After this database bundle patch is installed, then the matching OJVM in this zip can then be installed.

Additional Information

Installing Oracle JavaVM update is optional as DLP does not use OJVM and does not include it in its DLP database templates.
However, because OJVM is still part of the Oracle Home software, Oracle still recommends installing the latest OJVM patch.