What Are My Patch Prerequisites?
By StuRamage on Jun 14, 2011
It is always a large task attempting to download and apply patches to a CC&B once it is live in Production, since typically most installations are a couple of Service Packs behind, as a result I have been working on a method to document the requirements for each installation easily, using a number of different tools available to most installations.
This should be the first place that all installations go to, to determine the current patch level available for Oracle Utilities CC&B and FW. using a query similar to:
This returns a set of available patches similar to:
Using these query tools, I recommend downloading all applicable Service Packs, Convenience Roll-ups and sundry patches to a directory on your server or desktop.
Unzip these into a common mount point, but do not attempt to install them until full analysis of your needs and the impact on your environments has been performed.
It should also be noted that the ‘Hot Topics’ section under the Settings menu option can be used to craft automated daily/weekly/monthly email triggers based on patches being released for your product set:
Once these patches have been downloaded and unzipped your mount point should contain a list of sub-directories similar to:
2. You can then run a Perl script similar to this, which prompts for the following:
and produces the following:
This should allow installations to analyse these patches and determine any pre-requisites necessary. The resulting output has been designed to be entered directly into https://support.oracle.com to provide a detailed listing of the content of each of these pre-requisite patches to allow sites to determine the risk of implementing, and the regression testing required for each.
Update: I have been supplied with a similar concept, written by Chris Waite (from Aurora Energy), as a VB Script, which generates a similar list of pre-requisites. Attached here