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…<\/p>\n
$ $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>\nSo, 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… Adding the -connectString xyzdev:sys:passsword:<\/span>\u00a0\u00a0did not work either….<\/p>\n
I did not know until I reviewed the OPatch documentation, it has a lot of cool options in 11gR2… See documentation<\/a>.<\/p>\n
Thanks to Oracle support, for identifying the right option to remove the patch from the inventory.<\/p>\n
$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>\nNow, able to apply the PSU without issue…<\/p>\n
<\/p>\n
<\/p>\n
<\/p>\n","protected":false},"excerpt":{"rendered":"
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… $ $ORACLE_HOME\/OPatch\/opatch rollback -id 12834800 The patch should be applied\/rolled back in ‘-all_nodes’ mode only. Converting the RAC mode to ‘-all_nodes’ … 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_post_was_ever_published":false,"_jetpack_newsletter_access":"","_jetpack_dont_email_post_to_subs":false,"_jetpack_newsletter_tier_id":0,"_jetpack_memberships_contains_paywalled_content":false,"_jetpack_memberships_contains_paid_content":false,"footnotes":""},"categories":[133],"tags":[],"class_list":["post-218","post","type-post","status-publish","format-standard","hentry","category-oracledb"],"acf":[],"jetpack_featured_media_url":"","jetpack-related-posts":[],"jetpack_sharing_enabled":true,"_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}]}}