Do Not Mix Different Patch Types

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

Reviewing Current System Patch Level

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 

Attempted PSU Application and Conflict Failure

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. 

Successful Validation with Proactive Bundle Patch

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. 

Final Conclusion

Lesson learned is to apply the same patch type as the existing one.

Oracle Database Consulting Services

Ready to optimize your Oracle Database for the future?