Re: Oracle Patches - PSUs/CPUs/Caveats question/confusion

From: Wayne Smith <>
Date: Thu, 21 Jul 2011 13:53:08 -0400
Message-ID: <>

I can provide a little information, but I don't do windows ...
  • 8708078 appears to be a "Patch Bundle". Patch bundles were/are a convenience for applying lots of (recommended) fixes. Though it resembles a CPU/PSU, it appears to be different (to me). A big difference for me is that it isn't necessarily a security-related set of patches and it doesn't have the CheckPreReq that I love about PSUs.
  • *Patch Sets are not patch set updates.*
  • Patch Sets are applied to a base release and may be applied over a previous Patch Set. The installation tool is OUI. For example, was a base release. Applying Patch Set 1 gets you to Applying Patch Set 3 gets you to (For version and beyond, Patch Sets do not require a base release install and basically may be thought of as being installed into a new home).
    • CPUs are bundles of security fixes that are applied on top of a base release/patch set. The installation tool is opatch. As I prefer PSUs, I'll not say more about CPUs.
    • PSUs are produced on the same schedule as CPUs and are bundles that include CPU patches plus other selected fixes. If you choose to use PSUs, you don't, and may not, use CPUs. I love PSUs. With the prerequisite checker, I know before I shutdown the home whether the PSU will apply. Wonderful! On at least one platform, CPUs are no longer available. If you apply PSU#1 to, your database will be at level (though 10.2 and 11.1 do not update the final digit on most references, leaving it at, for example. "opatch lsinventory" will display the entire

Hope this helps!

Cheers, Wayne

This is what happens when the people writing the software never have to use it themselves... (T. Poder)

On Wed, Jul 20, 2011 at 9:14 AM, Taylor, Chris David <> wrote:

> We're working on our patching strategy and I realize now that I'm a bit
> confused, or perhaps I'm now confused vs. not being confused before.
> Here's the note that has caused me some confusion:
> ----------------------
> Note 1323616.1
> 1.4 Oracle Database Critical Patch Updates and Patch Set Updates
> The Database Patch Set Updates and Critical Patch Updates that are released
> each quarter contain the same security fixes. However, they use different
> patching mechanisms, and Patch Set Updates include both security and
> recommended bug fixes. Consider the following guidelines when you are
> deciding to apply Patch Set Updates instead of Critical Patch Updates.
> Critical Patch Updates are applied only on the base release version, for
> example
> Patch Set Updates can be applied on the base release version or on any
> earlier Patch Set Update. For example, can be applied on
> and
> Once a Patch Set Update has been applied, the recommended way to get
> future security content is to apply subsequent Patch Set Updates. Reverting
> from an applied Patch Set Update back to the Critical Patch Update, while
> technically possible, requires significant time and effort, and is not
> advised.
> For more information on Patch Set Updates, see Note 854428.1, Patch Set
> Updates for Oracle Products.
> ------------------------
> Here's what I have:
> Oracle 10g base with the following patches:
> Oracle Database 10g Release 2 Patch Set 3 (
> I have the following Patch installed on top of that:
> Patch 8708078: ORACLE 10G PATCH 24 BUG FOR WINDOWS (X64) AMD
> Questions:
> 1. patch 8708078 is a CPU not a PSU, correct? Or is it something else?
> 2. The Patch Set (Patch Set 3) is a base release version though,
> is that correct? So - we can apply CPUs to which is itself a PSU?
> (See my confusion?)
> 3. If patch set updates (PSUs) are release each quarter also, why are there
> not as many PSUs as there are CPUs? (Unless question #1 above is not a CPU)
> I think I'm still "missing something" here.
> Thanks,
> Chris
> --

Received on Thu Jul 21 2011 - 12:53:08 CDT

Original text of this message