OPatch "CheckRollbackable" On Auto-rollback Patches Failed

Prerequisite Check "CheckRollbackable" On Auto-rollback Patches Failed

Today, I encountered the following OPATCH issue while trying to rollback patches.

[oracle@qed1db04:DBAUPG2 DBAUPG]$ opatch rollback -id 12834800 -local

Oracle Interim Patch Installer version 11.2.0.3.6

Copyright (c) 2013, Oracle Corporation. All rights reserved.

Oracle Home       : /u01/app/oracle/product/11.2.0.3/DBAUPG

Central Inventory : /u01/app/oraInventory

   from           : /u01/app/oracle/product/11.2.0.3/DBAUPG/oraInst.loc

OPatch version   : 11.2.0.3.6

OUI version       : 11.2.0.3.0

Log file location : /u01/app/oracle/product/11.2.0.3/DBAUPG/cfgtoollogs/opatch/12834800_May_13_2014_20_42_33/rollback2014-05-13_20-42-33PM_1.log

RollbackSession rolling back interim patch '12834800' from OH '/u01/app/oracle/product/11.2.0.3/DBAUPG'

Prerequisite check "CheckRollbackable" failed.

The details are:

Patch 12834800:

Archive Action: Source file"/u01/app/oracle/product/11.2.0.3/DBAUPG/.patch_storage/12834800_Apr_24_2013_05_58_13/files/lib/libserver11.a/qksvc.o" does not exists.

'oracle.rdbms, 11.2.0.3.0': Cannot update file '/u01/app/oracle/product/11.2.0.3/DBAUPG/lib/libserver11.a' with '/qksvc.o'

[ Error during Prerequisite for rollback Phase]. Detail: RollbackSession failed during prerequisite checks: Prerequisite check "CheckRollbackable" failed.

Log file location: /u01/app/oracle/product/11.2.0.3/DBAUPG/cfgtoollogs/opatch/12834800_May_13_2014_20_42_33/rollback2014-05-13_20-42-33PM_1.log

Recommended actions: OPatch won't be able to roll back the given patch. A common reason is there are other patches that depend on this patch. You need to roll back those dependent patches before you can roll back this patch.

OPatch failed with error code 43

According to (Doc ID 1331900.1) Prerequisite Check "CheckRollbackable" On Auto-rollback Patches Failed.

This is because $ORACLE_HOME/.patch_storage is corrupted and does not contain the needed files for the rollback.

The suggested solution is to restore complete .patch_storage directory from backed up ORACLE_HOME prior to the files missing, and do the rollback again.

On ORBQA

[oracle@qed1db03:ORBQA1 .patch_storage]$ cd $ORACLE_HOME/.patch_storage

[oracle@qed1db03:ORBQA1 .patch_storage]$ cp -r 12834800_Apr_24_2013_05_58_13 /mnt/nfs/oracle.patches

On DBAUPG

[oracle@qed1db04:DBAUPG2 DBAUPG]$ cd $ORACLE_HOME/.patch_storage

[oracle@qed1db04:DBAUPG2 .patch_storage]$ cp -r /mnt/nfs/oracle.patches/12834800_Apr_24_2013_05_58_13 .

[oracle@qed1db04:DBAUPG2 .patch_storage]$ opatch rollback -id 12834800 -local

Oracle Interim Patch Installer version 11.2.0.3.6

Copyright (c) 2013, Oracle Corporation. All rights reserved.

Oracle Home       : /u01/app/oracle/product/11.2.0.3/DBAUPG

Central Inventory : /u01/app/oraInventory

   from           : /u01/app/oracle/product/11.2.0.3/DBAUPG/oraInst.loc

OPatch version   : 11.2.0.3.6

OUI version       : 11.2.0.3.0

Log file location : /u01/app/oracle/product/11.2.0.3/DBAUPG/cfgtoollogs/opatch/12834800_May_13_2014_21_23_28/rollback2014-05-13_21-23-28PM_1.log

RollbackSession rolling back interim patch '12834800' from OH '/u01/app/oracle/product/11.2.0.3/DBAUPG'

Please shutdown Oracle instances running out of this ORACLE_HOME on the local system.

(Oracle Home = '/u01/app/oracle/product/11.2.0.3/DBAUPG')

Is the local system ready for patching? [y|n]

y

User Responded with: Y

Patching component oracle.rdbms, 11.2.0.3.0...

RollbackSession removing interim patch '12834800' from inventory

Log file location: /u01/app/oracle/product/11.2.0.3/DBAUPG/cfgtoollogs/opatch/12834800_May_13_2014_21_23_28/rollback2014-05-13_21-23-28PM_1.log

OPatch succeeded.