Pythian Blog: Technical Track

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 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.

No Comments Yet

Let us know what you think

Subscribe by email