Oracle patch prerequisite check OPatch OEM MOS

Oracle database patching is one of the most frequently executed maintenance activities that every DBA does in his life. The task is fairly simple and straight forward using the patch instructions from My Oracle Support (MOS). However in this article I’d like to highlight the importance of different Patch Prerequisite Checks that you have to perform before doing the patching itself. I think the entire success of patching exercise depends mostly on this step as seen on the below table that represents major PSU patching steps and approximate time lines. The rest of this draft document describes some best practices, tips and code examples for doing patch prerequisite checks using OEM Cloud Control, MOS and OPatch utility. Comments, adjustments, other tips and ideas are welcome and will be included in this post.

Oracle DB PSU patching steps

Oracle database PSU patching steps

Read more »

Patching Oracle with Patch Set best practices

Patch Set is an Oracle major patch bundle that provides bug fixes only. It is a mechanism for delivering fully tested and integrated product fixes that do not include new functionality. All of the fixes in the Patch Set have been tested and are certified to work with each other. Read more »

PSU simplify Oracle patching

What are Oracle Patches?

Oracle patching is not always straight forward. Patch sets, patch bundles, one-off and interim patches, critical patch updates,… so many product version numbers. What should I install on my Oracle systems and how often?
Read more »

DBMS Blog Updates : Subscribe RSS RSS: Subscribe to Articles · Subscribe to Comments Subscribe RSS Receive site updates via email