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

PSU/CPU doesn't apply at all on Windows. Windows for some time has never had CPU patches (which were typically small) but Patch Bundles which are similar to, but larger in scope than, *nix PSU patches. That is to apply the latest Windows CPU patches you have to apply the first patch bundle which contains them - this is the patch# in the release notes for the CPU - and run the appropriate catbundle.sql script after patching the home. This *will* get you the security patches, *may* get you the PSU patches and likely will also get you some other recommended patches.

It's also well worth testing the Windows patch bundles on a "disposable" test system since the release quality hasn't always been reliable. for eg both of an issue and the lack of picking it up in a timely manner see 1142826.1.

On Wed, Jul 20, 2011 at 2:22 PM, Taylor, Chris David < ChrisDavid.Taylor_at_ingrambarge.com> wrote:

> I should mention this is WINDOWS so maybe the terms CPUs and PSUs don't
> mean the same because I found this in the docs:
>
> Oracle Database 10.2.0.4: Oracle Database Home
>
> Unix: CPU Patch 12419249, or PSU Patch 12419397
> Microsoft Windows x64 (64-bit): Bundle Patch 12429521
>
> Note 1323616.1
>
> Chris
>
> -----Original Message-----
> From: oracle-l-bounce_at_freelists.org [mailto:oracle-l-bounce_at_freelists.org]
> On Behalf Of Taylor, Chris David
> Sent: Wednesday, July 20, 2011 8:14 AM
> To: 'oracle-l_at_freelists.org'
> Subject: Oracle Patches - PSUs/CPUs/Caveats question/confusion
>
> 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 10.2.0.4.0.
>
> Patch Set Updates can be applied on the base release version or on any
> earlier Patch Set Update. For example, 11.1.0.7.2 can be applied on
> 11.1.0.7.1 and 11.1.0.7.0.
>
> 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 10.2.0.1 base with the following patches:
> Oracle Database 10g Release 2 Patch Set 3 (10.2.0.4)
>
> I have the following Patch installed on top of that:
> Patch 8708078: ORACLE 10G 10.2.0.4 PATCH 24 BUG FOR WINDOWS (X64) AMD
> PLATFORM
>
> Questions:
> 1. patch 8708078 is a CPU not a PSU, correct? Or is it something else?
> 2. The 10.2.0.4 Patch Set (Patch Set 3) is a base release version though,
> is that correct? So - we can apply CPUs to 10.2.0.4 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
>
> --
> http://www.freelists.org/webpage/oracle-l
>
>
>
>
> --
> http://www.freelists.org/webpage/oracle-l
>
>
>

-- 
Niall Litchfield
Oracle DBA
http://www.orawin.info

--
http://www.freelists.org/webpage/oracle-l