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

From: Taylor, Chris David <ChrisDavid.Taylor_at_ingrambarge.com>
Date: Wed, 20 Jul 2011 10:07:10 -0500
Message-ID: <C5533BD628A9524496D63801704AE56D6A31218B58_at_SPOBMEXC14.adprod.directory>

Thanks Niall, much appreciated.

Chris Taylor
Sr. Oracle DBA
Ingram Barge Company
Nashville, TN 37205
Office: 615-517-3355
Cell: 615-663-1673
Email: chris.taylor_at_ingrambarge.com<mailto:chris.taylor_at_ingrambarge.com>

CONFIDENTIALITY NOTICE: This e-mail and any attachments are confidential and may also be privileged. If you are not the named recipient, please notify the sender immediately and delete the contents of this message without disclosing the contents to anyone, using them for any purpose, or storing or copying the information on any medium.

From: Niall Litchfield [mailto:niall.litchfield_at_gmail.com] Sent: Wednesday, July 20, 2011 9:30 AM
To: Taylor, Chris David
Cc: oracle-l_at_freelists.org
Subject: Re: Oracle Patches - PSUs/CPUs/Caveats question/confusion

Chris

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<mailto: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<http://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> [mailto: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<mailto: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

--

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

--

http://www.freelists.org/webpage/oracle-l Received on Wed Jul 20 2011 - 10:07:10 CDT

This message: [ Message body ]
Next message: kyle Hailey: "Re: Database Time Spent Waiting"
Previous message: Hameed, Amir: "RE: DISM in 11.2.0.2 on Solaris 10"
In reply to: Niall Litchfield: "Re: Oracle Patches - PSUs/CPUs/Caveats question/confusion"
Next in thread: Wayne Smith: "Re: Oracle Patches - PSUs/CPUs/Caveats question/confusion"

Contemporary messages sorted: [ by date ] [ by thread ] [ by subject ] [ by author ]

Original text of this message