{"id":218,"date":"2013-10-24T22:53:49","date_gmt":"2013-10-25T03:53:49","guid":{"rendered":"https:\/\/bijoos.com\/oraclenotes\/?p=218"},"modified":"2026-02-07T15:14:41","modified_gmt":"2026-02-07T21:14:41","slug":"opatch-options","status":"publish","type":"post","link":"https:\/\/bijoos.com\/oraclenotes\/2013\/218\/","title":{"rendered":"OPatch Options!"},"content":{"rendered":"<p>A friend of mine was working to apply the July 2013 PSU, and had to rollback two one off patch conflicts. Since the instance was cloned from production, OPatch was failing with this error&#8230;<\/p>\n<pre class=\"lang:default highlight:0 decode:true\">$ $ORACLE_HOME\/OPatch\/opatch rollback -id 12834800\n\nThe patch should be applied\/rolled back in '-all_nodes' mode only.\nConverting the RAC mode to '-all_nodes' mode.\nPrerequisite check \"CheckRollbackSid\" failed.\n\nPatch ID: 12834800\nThe details are:\nThe specified online patch(es) are installed on the following Database Instances (SIDs) \"xyzprod\".\nThe SIDs given for rollback are not the same. OPatch cannot continue.\n[ Error during Prerequisite for rollback Phase]. Detail: RollbackSession failed during prerequisite checks: Prerequisite check \"CheckRollbackSid\" failed.\nLog file location: \/u01\/app\/oracle\/xyzdev\/11.2.0.3\/cfgtoollogs\/opatch\/12834800_Oct_23_2013_16_37_13\/rollback2013-10-23_16-37-13PM_1.log\nRecommended actions: Please look at log file to locate the prerequisite that failed. Invoke 'opatch apply -report' or 'opatch rollback -report'.\nOPatch failed with error code 30<\/pre>\n<p>So, though we are trying to rollback the conflicting patch from dev instance, the inventory still has reference to prod instance, where the oracle home was cloned from&#8230; Adding the <span class=\"lang:default decode:true  crayon-inline\">-connectString xyzdev:sys:passsword:<\/span>\u00a0\u00a0did not work either&#8230;.<\/p>\n<p>I did not know until I reviewed the OPatch documentation, it has a lot of cool options in 11gR2&#8230; <a title=\"OPatch Options - Oracle Doc\" href=\"http:\/\/docs.oracle.com\/cd\/E11857_01\/em.111\/e12255\/oui7_opatch.htm\" target=\"_blank\">See documentation<\/a>.<\/p>\n<p>Thanks to Oracle support, for identifying the right option to remove the patch from the inventory.<\/p>\n<pre class=\"lang:default highlight:0 decode:true\">$ORACLE_HOME\/OPatch\/opatch rollback -id 12834800 -no_sysmod -connectString xyzdev:sys:passsword:\u00a0-local\n\n$ORACLE_HOME\/OPatch\/opatch rollback -id 13004894 -no_sysmod -connectString xyzdev:sys:passsword:\u00a0-local<\/pre>\n<p>Now, able to apply the PSU without issue&#8230;<\/p>\n<p>&nbsp;<\/p>\n<p>&nbsp;<\/p>\n<p>&nbsp;<\/p>\n","protected":false},"excerpt":{"rendered":"<p>A friend of mine was working to apply the July 2013 PSU, and had to rollback two one off patch conflicts. Since the instance was cloned from production, OPatch was failing with this error&#8230; $ $ORACLE_HOME\/OPatch\/opatch rollback -id 12834800 The patch should be applied\/rolled back in &#8216;-all_nodes&#8217; mode only. Converting the RAC mode to &#8216;-all_nodes&#8217; &#8230; <a title=\"OPatch Options!\" class=\"read-more\" href=\"https:\/\/bijoos.com\/oraclenotes\/2013\/218\/\" aria-label=\"Read more about OPatch Options!\">Read more<\/a><\/p>\n","protected":false},"author":2,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_acf_changed":false,"_jetpack_newsletter_access":"","_jetpack_dont_email_post_to_subs":false,"_jetpack_newsletter_tier_id":0,"_jetpack_memberships_contains_paywalled_content":false,"_jetpack_hide_featured_image":false,"_jetpack_featured_image_duplicate_dismissed":0,"_jetpack_feature_clip_id":0,"_jetpack_memberships_contains_paid_content":false,"footnotes":"","jetpack_post_was_ever_published":false},"categories":[133],"tags":[],"class_list":["post-218","post","type-post","status-publish","format-standard","hentry","category-oracledb"],"acf":[],"jetpack-related-posts":[{"id":1641,"url":"https:\/\/bijoos.com\/oraclenotes\/2015\/1641\/","url_meta":{"origin":218,"position":0},"title":"Apply DB OVJM PSU + Queryable Patch Inventory Demo","author":"Biju","date":"December 1, 2015","format":false,"excerpt":"Oracle started releasing OVJM component of \u00a0DB PSU in October 2014, and recommend applying OVJM PSU along with (or after) DB PSU. I will demo applying DB PSU, and OVJM PSU on 12.1.0.2 database. Use this opportunity to introduce you to Queryable Patch Inventory (DBMS_QOPATCH), where you can query OPatch\u2026","rel":"","context":"In &quot;Oracle Database&quot;","block_context":{"text":"Oracle Database","link":"https:\/\/bijoos.com\/oraclenotes\/category\/oracledb\/"},"img":{"alt_text":"","src":"","width":0,"height":0},"classes":[]},{"id":1601,"url":"https:\/\/bijoos.com\/oraclenotes\/2015\/1601\/","url_meta":{"origin":218,"position":1},"title":"Bundle Patch or PSU on Windows","author":"Biju","date":"September 21, 2015","format":false,"excerpt":"Well, honestly, have forgotten working\u00a0on Windows platform administering Oracle databases. Recently, installed Oracle Database 12c on Windows and wanted to apply the latest PSU. Could not find the PSU, but found the BP (Bundled Patch) - hoped it the same and included more than a PSU! Had some challenges installing...\u2026","rel":"","context":"In &quot;Oracle Database&quot;","block_context":{"text":"Oracle Database","link":"https:\/\/bijoos.com\/oraclenotes\/category\/oracledb\/"},"img":{"alt_text":"","src":"","width":0,"height":0},"classes":[]},{"id":1904,"url":"https:\/\/bijoos.com\/oraclenotes\/2016\/1904\/","url_meta":{"origin":218,"position":2},"title":"12 Days of #Cloud: Apply Patch to #DBaaS Instance","author":"Biju","date":"December 28, 2016","format":false,"excerpt":"12 Days of #Cloud: Day 9 I have a 12.1. Database Cloud Instance, which comes with several patches including July 2016 PSU. The dbaascli\u00a0cloud tool can be used to query and apply patches. Before we use dbaascli, let's check what the Cloud interface shows. Choose the DBaaS instance and view\u2026","rel":"","context":"In &quot;Cloud &amp; Autonomous Database&quot;","block_context":{"text":"Cloud &amp; Autonomous Database","link":"https:\/\/bijoos.com\/oraclenotes\/category\/cloud-autonomous\/"},"img":{"alt_text":"","src":"","width":0,"height":0},"classes":[]},{"id":2858,"url":"https:\/\/bijoos.com\/oraclenotes\/2025\/2858\/","url_meta":{"origin":218,"position":3},"title":"Oracle AI Database 26ai Software Install using AutoUpgrade on a Brand New VM!","author":"biju.thomas","date":"November 6, 2025","format":false,"excerpt":"This week, I attended the East Coast Oracle Conference and listened to Alex Zaballa. He finished his session early and jumped to show some of the cool features available in AutoUpgrade. I was truly impressed by the new features and capabilities of AutoUpgrade. I think that soon the upgrade team\u2026","rel":"","context":"In &quot;Oracle Database&quot;","block_context":{"text":"Oracle Database","link":"https:\/\/bijoos.com\/oraclenotes\/category\/oracledb\/"},"img":{"alt_text":"","src":"https:\/\/i0.wp.com\/bijoos.com\/oraclenotes\/wp-content\/uploads\/2025\/11\/image-1.png?fit=1024%2C768&ssl=1&resize=350%2C200","width":350,"height":200,"srcset":"https:\/\/i0.wp.com\/bijoos.com\/oraclenotes\/wp-content\/uploads\/2025\/11\/image-1.png?fit=1024%2C768&ssl=1&resize=350%2C200 1x, https:\/\/i0.wp.com\/bijoos.com\/oraclenotes\/wp-content\/uploads\/2025\/11\/image-1.png?fit=1024%2C768&ssl=1&resize=525%2C300 1.5x, https:\/\/i0.wp.com\/bijoos.com\/oraclenotes\/wp-content\/uploads\/2025\/11\/image-1.png?fit=1024%2C768&ssl=1&resize=700%2C400 2x"},"classes":[]},{"id":2351,"url":"https:\/\/bijoos.com\/oraclenotes\/2018\/2351\/","url_meta":{"origin":218,"position":4},"title":"Oracle Tidbits &#8211; October 2018 #oratidbit","author":"biju.thomas","date":"October 31, 2018","format":false,"excerpt":"\u201cOracle *daily* TidBits\u201d (#oratidbit) published on\u00a0\u00a0Facebook,\u00a0Twitter,\u00a0and\u00a0Google+\u00a0during weekdays\u00a0in October 2018. Hope you find these helpful to learn something new or to remind you of its existence and use. #oratidbit #db18c You can convert a conventional disk group (disk group created before Oracle ASM 18c) to an Oracle ASM flex disk group\u2026","rel":"","context":"In &quot;TidBits &amp; Quick Tips&quot;","block_context":{"text":"TidBits &amp; Quick Tips","link":"https:\/\/bijoos.com\/oraclenotes\/category\/tidbits\/"},"img":{"alt_text":"","src":"https:\/\/i0.wp.com\/bijoos.com\/oraclenotes\/wp-content\/uploads\/2018\/04\/oratidbit.jpg?resize=350%2C200&ssl=1","width":350,"height":200},"classes":[]},{"id":204,"url":"https:\/\/bijoos.com\/oraclenotes\/2013\/204\/","url_meta":{"origin":218,"position":5},"title":"Streams Answer&#8230;","author":"Biju","date":"August 29, 2013","format":false,"excerpt":"I posted the question few days back on a streams issue I have been working on... https:\/\/bijoos.com\/oraclenotes\/oraclenotes\/2013\/199 It looks like there was a open or long transaction, and before that transaction was committed or rollback, the archivelog file got deleted by the RMAN backup and cleanup job... \u00a0or we just\u2026","rel":"","context":"In &quot;Oracle Database&quot;","block_context":{"text":"Oracle Database","link":"https:\/\/bijoos.com\/oraclenotes\/category\/oracledb\/"},"img":{"alt_text":"","src":"","width":0,"height":0},"classes":[]}],"jetpack_sharing_enabled":true,"jetpack_featured_media_url":"","_links":{"self":[{"href":"https:\/\/bijoos.com\/oraclenotes\/wp-json\/wp\/v2\/posts\/218","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/bijoos.com\/oraclenotes\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/bijoos.com\/oraclenotes\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/bijoos.com\/oraclenotes\/wp-json\/wp\/v2\/users\/2"}],"replies":[{"embeddable":true,"href":"https:\/\/bijoos.com\/oraclenotes\/wp-json\/wp\/v2\/comments?post=218"}],"version-history":[{"count":1,"href":"https:\/\/bijoos.com\/oraclenotes\/wp-json\/wp\/v2\/posts\/218\/revisions"}],"predecessor-version":[{"id":2970,"href":"https:\/\/bijoos.com\/oraclenotes\/wp-json\/wp\/v2\/posts\/218\/revisions\/2970"}],"wp:attachment":[{"href":"https:\/\/bijoos.com\/oraclenotes\/wp-json\/wp\/v2\/media?parent=218"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/bijoos.com\/oraclenotes\/wp-json\/wp\/v2\/categories?post=218"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/bijoos.com\/oraclenotes\/wp-json\/wp\/v2\/tags?post=218"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}