Tuesday Jun 14, 2011

What Are My Patch Prerequisites?

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.

1. https://support.oracle.com

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:


Path associated with the complete set of available patches[C:/Users/sramage/Desktop]: c:\temp\
Patch Number being installed[0000000]: 7702037
Path associated with the installed_fixes.txt for this CC&B Installation[C:/Users/sramage/Desktop]: c:\temp\etc\


and produces the following:

-----------------------------------------------------------------------------

Analysing Level 1 Dependencies..
-- Patch #8408935 not installed, added to list
-- Patch #1122345 already installed!

Analysing Level 2 Dependencies..
-- Patch #1122345 already installed!
-- Patch #1122346 not installed, added to list

Analysing Level 3 Dependencies..
-- Patch #1122345 already installed!


----------------------------------------------------------------------------
----------------------------------------------------------------------------
The following patch/es need to be installed as pre-requisites to patch 7702037:
8408935, 1122346
----------------------------------------------------------------------------
----------------------------------------------------------------------------



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

Wednesday Dec 02, 2009

Service with a Smile

Oracle Utilities Framework 2.2.0 SP6 (Patch number 9042811) and Customer Care & Billing 2.2.0 SP6 (Patch number 9042819) are now available for download from My Oracle Support. 
About

Stuart Ramage

I am a Consulting Technical Manager for Oracle Corporation, and a member of the OU Black Belt Team, based in Hobart Tasmania.
I have worked in the Utility arena since 1999 on the Oracle UGBU product line, in a variety of roles including Conversion, Technical and Functional Architect.

Contact me on:

Search

Categories
Archives
« April 2014
SunMonTueWedThuFriSat
  
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
   
       
Today