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