1. You MUST read the Readme.txt file included in opatch file, look for any prereq. steps/ post installation steps or and DB related changes. Also, make sure that you have the correct opatch version required by this patch.
2.Make sure you have a good backup of database.
3. Make a note of all Invalid objects in the database prior to the patch.
4. Shutdown All the Oracle Processes running from that Oracle Home , including the Listener and Database instance, Management agent etc.
5. You MUST Backup your oracle Home and Inventory
tar cvf - $ORACLE_HOME $ORACLE_HOME/oraInventory | gzip > Backup_Software_Version.tar.gz
6. Unzip the patch in $ORACLE_HOME/patches
7. cd to the patch direcory and do opatch -apply to apply the patch.
8. Read the output/log file to make sure there were no errors.
How to Rollback a patch?
opatch rollback -id (Patch Number)
I messed up my Oracle home/ opatch rollback is failing , what to do now?
Remember, we took the backup of the ORACLE_HOME and main importantly the Oracle inventory, you can just restore (uncompress) the software and the inventory and you are all set. Also for fixing the corrupt inventory, please refer to this OracleMetaLink Note:298906.1
Subscribe to:
Post Comments (Atom)
2 comments:
Hi Sridhar.,
nice work & useful links in ur blog
i want to know for metalink to register wht is the process..bcoz its asking me some code. i am not able to
signin metalink ., can u help me in this matter... oradb.diva@gmail.com
Regds,
Diva
Diva,
You can't register to Oracle Metalink, just like any other website. It is given to Individuals/Companies who buy Support from Oracle.
PS:: Thanks for the comment and your time.
Post a Comment