Category: Uncategorized

Posted on

OPatch Options!

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' mode.
Prerequisite check "CheckRollbackSid" failed.

Patch ID: 12834800
The details are:
The specified online patch(es) are installed on the following Database Instances (SIDs) "xyzprod".
The SIDs given for rollback are not the same. OPatch cannot continue.
[ Error during Prerequisite for rollback Phase]. Detail: RollbackSession failed during prerequisite checks: Prerequisite check "CheckRollbackSid" failed.
Log 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
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

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… Adding the -connectString xyzdev:sys:passsword:  did not work either….

I did not know until I reviewed the OPatch documentation, it has a lot of cool options in 11gR2… See documentation.

Thanks to Oracle support, for identifying the right option to remove the patch from the inventory.

$ORACLE_HOME/OPatch/opatch rollback -id 12834800 -no_sysmod -connectString xyzdev:sys:passsword: -local

$ORACLE_HOME/OPatch/opatch rollback -id 13004894 -no_sysmod -connectString xyzdev:sys:passsword: -local

Now, able to apply the PSU without issue…

 

 

 

Posted on

Time Flies!

Just thought that I have not updated the blog for sometime, but did not realize it is almost 10 months since the last update… Time really flies…

Oracle Openworld is here, though this is my sixth or seventh OOW at SFO, 2012 is the first OOW where I am part of the event outside of participation…

Will be presenting on Thu 10/4 – EBS performance improvement tips… I know it is the last day of the conference and many may not stay back to attend the afternoon sessions in particular… If you are around and you are supporting an Oracle EBS instance [11i or R12], I think you would learn a thing or two from this presentation. As the title of the presentation “Improving Performance of E-Business Suite Application – Practical Tips from a DBA’s Diary…” says, the presentation is full of proven tips and techniques. If you happen to attend, please provide me feedback…

I will be at the Oracle Certification Lounge on Wed 10/3 at 1PM for a meet the author session. If you have any certification related questions or need guidance, don’t forget to stop by… you may also discuss the contents of  my 11g OCA certification exam study guide, and how it can help you get certified…

Also, I will be available most of the Exhibition hall hours at the OneNeck booth [415 Moscone South]… Stop by to say hello, or if you need to have a quick chat on architecture, tuning,  upgrades, administration or any topic related to EBS system administration or Oracle administration… No Exadata or EM12c yet 🙁

Have a great day!