My Oracle Support Banner

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

Last updated on DECEMBER 22, 2019

Applies to:

Oracle Database - Enterprise Edition - Version and later
Information in this document applies to any platform.


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

$ export ORACLE_HOME=/home/oracle/app/oracle/product/11.2.0/b202
$ $ORACLE_HOME/OPatch/opatch lsinventory
Oracle Interim Patch Installer version
Interim patches (1) :
Patch (online) 13413533: applied on Fri Feb 17 22:40:18 PST 2012

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

Oracle Interim Patch Installer version
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    :
OUI version       :
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


To view full details, sign in with your My Oracle Support account.

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

In this Document

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.