opatch Fails to Rollback Online(Hot) Patch With Prerequisite check "CheckRollbackSid" failed and error code 30 (Doc ID 1422190.1)

Last updated on FEBRUARY 26, 2012

Applies to:

Oracle Server - Enterprise Edition - Version: 11.2.0.1 and later   [Release: 11.2 and later ]
Information in this document applies to any platform.

Symptoms

opatch fails when rolling back an online(hot) patch:

  • Instance name in this example is "db202"
  • online patch applied successfully
$ export ORACLE_HOME=/home/oracle/app/oracle/product/11.2.0/b202
$ $ORACLE_HOME/OPatch/opatch lsinventory
Oracle Interim Patch Installer version 11.2.0.1.9
..
Interim patches (1) :
Patch (online) 13413533: applied on Fri Feb 17 22:40:18 PST 2012
..


  • opatch rollback failure

$ $ORACLE_HOME/OPatch/opatch rollback -id 13413533 -connectString db202::: -local

Oracle Interim Patch Installer version 11.2.0.1.9
Copyright (c) 2011, Oracle Corporation.  All rights reserved.


Oracle Home       : /oracle/app/oracle/11.2.0/db_1
Central Inventory : /oracle/app/oraInventory
  from           : /oracle/app/oracle/11.2.0/db_1/oraInst.loc
OPatch version    : 11.2.0.1.9
OUI version       : 11.2.0.2.0
Log file location : /oracle/app/oracle/11.2.0/db_1/cfgtoollogs/opatch/opatch2012-02-21_18-40-41PM.log

RollbackSession rolling back interim patch '13413533' from OH '/oracle/app/oracle/11.2.0/db_1'

..
Prerequisite check "CheckRollbackSid" failed.

Patch ID: 13413533

The details are:

There are no SIDs defined to check with the input SIDs.

[ Error during Prerequisite for rollback Phase]. Detail: RollbackSession failed during prerequisite checks: Prerequisite check "CheckRollbackSid" failed.
Log file location: /oracle/app/oracle/11.2.0/db_1/cfgtoollogs/opatch/opatch2012-02-21_18-40-41PM.log

Recommended actions: Please look at log file to locate the prerequisite that failed. Invoke 'opatch apply  -report' or 'opatch rollback  -report'.

OPatch failed with error code 30




Cause

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms