I was preparing to apply a July 2019 path for a single instance database without ASM. Here are the available patch types for Oracle Database: PSU, SPU(CPU), Bundle Patches (Versions 12.1 & lower) via Doc ID 2118136.2 Review current patch on system. Notice Database Bundle Patch.
$ $ORACLE_HOME/OPatch/opatch lspatches
26717470;Database Bundle Patch : 12.1.0.2.171017 (26717470)
OPatch succeeded
Downloaded Patch 29494060 - Database Patch Set Update 12.1.0.2.190716 Check patch conflict was not favorable.
$ cd $PATCH_TOP_DIR/29494060
$ $ORACLE_HOME/OPatch/opatch prereq CheckConflictAgainstOHWithDetail -ph ./
Oracle Interim Patch Installer version 12.2.0.1.17
Copyright (c) 2019, Oracle Corporation. All rights reserved.
PREREQ session
Oracle Home : /u01/app/oracle/product/12.1.0/dbhome_1
Central Inventory : /u01/app/oraInventory
from : /u01/app/oracle/product/12.1.0/dbhome_1/oraInst.loc
OPatch version : 12.2.0.1.17
OUI version : 12.1.0.2.0
Log file location : /u01/app/oracle/product/12.1.0/dbhome_1/cfgtoollogs/opatch/opatch2019-11-07_14-59-34PM_1.log
Invoking prereq "checkconflictagainstohwithdetail"
Prereq "checkConflictAgainstOHWithDetail" failed.
The details are:
The relation between 2 composites[26717470,29494060] are invalid.
Please contact SE team to regenerate the patches.
Summary of Conflict Analysis:
There are no patches that can be applied now.
OPatch succeeded.
Downloaded Patch 29698629 - Database Proactive Bundle Patch 12.1.0.2.190716 Check patch conflict was successful.
$ $ORACLE_HOME/OPatch/opatch prereq CheckConflictAgainstOHWithDetail -phBaseDir $PATCH_TOP_DIR/29698629/29496791
Oracle Interim Patch Installer version 12.2.0.1.17
Copyright (c) 2019, Oracle Corporation. All rights reserved.
PREREQ session
Oracle Home : /u01/app/oracle/product/12.1.0/dbhome_1
Central Inventory : /u01/app/oraInventory
from : /u01/app/oracle/product/12.1.0/dbhome_1/oraInst.loc
OPatch version : 12.2.0.1.17
OUI version : 12.1.0.2.0
Log file location : /u01/app/oracle/product/12.1.0/dbhome_1/cfgtoollogs/opatch/opatch2019-11-08_08-47-34AM_1.log
Invoking prereq "checkconflictagainstohwithdetail"
Prereq "checkConflictAgainstOHWithDetail" passed.
OPatch succeeded.
$ $ORACLE_HOME/OPatch/opatch prereq CheckConflictAgainstOHWithDetail -phBaseDir $PATCH_TOP_DIR/29698629/29509318
Oracle Interim Patch Installer version 12.2.0.1.17
Copyright (c) 2019, Oracle Corporation. All rights reserved.
PREREQ session
Oracle Home : /u01/app/oracle/product/12.1.0/dbhome_1
Central Inventory : /u01/app/oraInventory
from : /u01/app/oracle/product/12.1.0/dbhome_1/oraInst.loc
OPatch version : 12.2.0.1.17
OUI version : 12.1.0.2.0
Log file location : /u01/app/oracle/product/12.1.0/dbhome_1/cfgtoollogs/opatch/opatch2019-11-08_08-47-46AM_1.log
Invoking prereq "checkconflictagainstohwithdetail"
Prereq "checkConflictAgainstOHWithDetail" passed.
OPatch succeeded.
Lesson learned is to apply the same patch type as the existing one.
.svg){kind=small}
.svg){kind=small}