Patching Oracle with Patch Set best practices

August 27, 2010 by 1 Comment 

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.

Oracle Patch Set can be applied on the base release version or on any of the earlier Patch Sets of the same base release. You can apply it not only to Oracle database but to the following list of Oracle installations:

  • Oracle Database
  • Oracle Real Application Clusters
  • Oracle Database Client
  • Oracle Database Companion CD
  • Oracle Clusterware
  • Oracle Database Vault

Based on Oracle, a Patch Set does not require you to certify applications or tools against the server because it includes only low impact patches. Nevertheless, based on my experience most of application vendors do certify Oracle Patch Sets. Besides in my long Oracle experience after the patching I faced sometimes different application issues like performance degradation, new errors, changed result sets, even SQL hangs. Therefore, I recommend to test applications thoroughly with the latest patch applied to avoid all those nasty things. Additionally, I always collect application and database performance baseline statistics before the patching to compare it with the figures after it.

I strongly recommend creating a backup of the Oracle Inventory, Oracle home binaries and your database before you install the Patch Set.

I count about 4 hours for Patchset installation. That does not include the database backup though. Below are major steps:

– Check database backup and perform clean shutdown of a DB instance

– Backup binaries

– Upgrade binaries

– Do postinstallation tasks (run catupgrade, compile invalid object etc)

– Restart database and conduct basic system test

Below are the latest Patch sets for major Oracle releases available at the moment

11.1.0.7.0 - Patchset #1 (for Oracle 11g Base Release 11.1.0.6.0)
10.2.0.5.0 - Patchset #4 (for Oracle 10gR2 Base Release 10.2.0.1.0)
10.1.0.5.0 - Patchset #3 (for Oracle 10g Base Release 10.1.0.2.0)
9.2.0.8 - Patchset #7 (for Oracle 9iR2 Base Release 9.2.0.1)
9.0.1.4 - Patchset #4 (for Oracle 9i Base Release 9.0.1.0)

Note: Do not mix up Patch Set and Patch Set Update (PSU). PSU is a minor bug fix bundle that is applied on top of the Patch Set. Therefore, my general recommendation is applying the latest Patchset and then the latest PSU. Read my article about PSU patching: PSU simplify Oracle patching.

Enjoyed this article? Please share it with others using the social site of your choice:

Comments

One Response to “Patching Oracle with Patch Set best practices”
  1. database company says:

    Well to be exact database patching is one important tool for database continuity.

Add a Comment

We welcome thoughtful and constructive comments from readers.
If you want your own picture to show with your comment?
Go get a Globally Recognized Avatar!

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