OPatch auto is not patching Database Home

This post is also available in: Português

Sometimes I face a situation where the following command finishes successfully, however, RAC database ORACLE_HOME is not patched:

# opatch auto -ocmrf

There are 2 situations where this happens:

1. The GI home and RAC database home are under different Patch Sets (until 4th digit)

i.e. :

• GI is 11.2.0.4 and RAC is 11.2.0.3
• GI is 12.1.0.2 and RAC is 11.2.0.4

The PSU will be applied only to homes which have same patch set number.

2. The RAC database home has no database registered in the OCR

This is the most common case and happens when you installed RAC but haven't created any database yet.

You can check if you have any DB registered in you OCR running:

$ $GRID_HOME/bin/crsctl stat res -p -w "TYPE = ora.database.type" | egrep '^NAME|^ORACLE_HOME'

To patch your DB home, you will need to either:

• Run "opatch auto" again specifying RAC ORACLE_HOME:

  # opatch auto <UNZIPPED_PATCH_LOCATION> -oh <RAC_HOME> -ocmrf <ocm response file>

• Create/Add your database to OCR and rerun "opatch auto":

  $ srvctl add database / instance

More information:

Doc Id 1479651.1 (Why "opatch auto" not patching RAC database ORACLE_HOME?)

+4