How to identify if a patch is available within a PSU

Within MoS there are a set of notes which list all the patches of each PSU and show in which PSU they came in (PSUs are cumulative). The READme.html file with each PSU does not contain this information

11.1.0.7 Patch Set Updates – List Of Fixes In Each PSU [ID 1337836.1]
11.2.0.1 Patch Set Updates – List Of Fixes In Each PSU [ID 1340010.1]
11.2.0.2 Patch Set Updates – List Of Fixes In Each PSU [ID 1340011.1]
11.2.0.3 Patch Set Updates – List Of Fixes In Each PSU [ID 1449750.1] 

However beware if you are looking for a patch that is called Merged or something similar as you have to search the MoS notes for the included patches, not the merged patch itself

 As an example Patch 12640090 is an ASM fix but it is not found in note 1337836.1

But if you look at patch 12640090 in MoS you find the information about the included patches

 (4) Bugs Fixed by This Patch

———————————

The following are the bugs fixed by this patch:

  9007102: KFNMCLIENTSREGISTER12 WHEN HUNG UFG RECOVERS AND REGS FREED GPN

  9029156: ADDITIONAL TRACING FOR ASMB AND ASMB CONNECTIONS

 From note 1337836.1 I can see that 9007102 was included in PSU 8 but 9029156 is not quite as clear but it suggests it is included in PSU 13

Patch Details

 Patch 9029156: ADDITIONAL TRACING FOR ASMB AND ASMB CONNECTIONS 

Last Updated 21-Oct-2012 21:42 (2+ months ago)
Product Oracle Database Family Release Oracle 11.1.0.7.13

Size 104.5 KB
Download Access Extended Support
Classification General
Patch Tag 

Prerequisite Patches
14275623
DATABASE PATCH SET UPDATE 11.1.0.7.13 (INCLUDES CPUOCT2012)

 I understand Oracle have an easier tool for this but it is not generally available. I am sure there is a good reason for that but it escapes me

About these ads