RE: 8.1.7.4 interim patch management strategy

From: Hallas, John, Tech Dev <John.Hallas_at_gb.vodafone.co.uk>
Date: Wed, 30 Jul 2003 08:34:29 -0800
Message-ID: <F001.005C7D9D.20030730083429@fatcity.com>

Always a difficult activity although the opatch utility available with 9i could prove a real benefit

Most sites I have worked on don't have a policy as such but they only apply patches as and when necessary. The other difficulty is that out of say the 180 patches you mention, many may apply to a specific executable and therefore over write each other.

The other problem is where many databases share a single OH. Applying a patch to one database impacts them all and requires a lot more testing, outage and overall management.

The only clean way is to have a new OH for each patch install, this is not very practicable

No easy answer I am afraid but I would only be applying patches when absolutely necessary

John

-----Original Message-----
Sent: 29 July 2003 23:55
To: Multiple recipients of list ORACLE-L

Hello All,

There are 188 interim patches after 8.1.7.4 patchset. I know that 8.1.7.4 is the last patchset.

1. What methods/strategy do you'll have for installing patches on a 8.1.7.4 64 bit hp-ux 11.11 database?
2. Is there opatch for 8.1.7.4? AFAIK opatch is only for 9i.
3. Should one install all the applicable patches (around 180 individual patches)? pessimistic (wait for the bug to hit and db to crash) optimistic (install applicable patches)
4. How to manage the interdependencies between these 180 individual patches?
5. Can we create a hp unix patch depot like "thing" for all these oracle patches?

pls dont advise putting an enhancement request and upgrading to 9i/10i :-)

Thanks,
Mandar
--

Please see the official ORACLE-L FAQ: http://www.orafaq.net
--

Author: Mandar A. Ghosalkar
  INET: mghosalk_at_byer.com

Fat City Network Services    -- 858-538-5051 http://www.fatcity.com
San Diego, California        -- Mailing list and web hosting services
---------------------------------------------------------------------

To REMOVE yourself from this mailing list, send an E-Mail message to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
--

Please see the official ORACLE-L FAQ: http://www.orafaq.net
--

Author: Hallas, John, Tech Dev
  INET: John.Hallas_at_gb.vodafone.co.uk

Fat City Network Services    -- 858-538-5051 http://www.fatcity.com
San Diego, California        -- Mailing list and web hosting services
---------------------------------------------------------------------

To REMOVE yourself from this mailing list, send an E-Mail message to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). Received on Wed Jul 30 2003 - 11:34:29 CDT