RE: Finding installed patches (I was wrong)

  • From: "Gogala, Mladen" <Mladen.Gogala@xxxxxxxx>
  • To: 'Uwe Weber' <uwe.weber@xxxxxxxxxxxxx>, "Gogala, Mladen" <Mladen.Gogala@xxxxxxxx>
  • Date: Wed, 15 Sep 2004 15:33:57 -0400

Here is what Metalink says. I could have sworn that it works on 8i as well.

Unix Installation/OS: RDBMS Technical Forum

                                

Displayed below are the messages of the selected thread.

Thread Status: Active

From: Liam Morrin 29-Apr-03 14:46
Subject: Keeping track of patches

RDBMS Version: 8.1.7.4
Operating System and Version: Solaris 8
Error Number (if applicable):
Product (i.e. SQL*Loader, Import, etc.):
Product Version:

Keeping track of patches

Good afternoon all,

Is there any way of telling which individual patches have been applied to a
database?

For instance I am running 8.1.7.4 (on Solaris 8) and have just applied patch
2832809 following a recent security alert. When I query v$version it still
shows as 8.1.7.4.0. How would anybody know that I have applied this patch?

I can find no reference to the patch number in ../oraInventory/Patches.

Many thanks,
Liam



From: Oracle, Kapil Malhotra 06-May-03 14:07
Subject: Re : Keeping track of patches

Hi Liam,

There is no straight cut method or utility in Oracle 8i which can tell what
all patches have been applied. Ya, from Oracle 9i onwards a utility called
opatch is there to see the applied patches.

You have to keep track of those patches manually.

Thanks and Regards,
Kapil Malhotra


--
Mladen Gogala
A & E TV Network
Ext. 1216


> -----Original Message-----
> From: Uwe Weber [mailto:uwe.weber@xxxxxxxxxxxxx] 
> Sent: Wednesday, September 15, 2004 3:29 PM
> To: Gogala, Mladen
> Subject: Re: Finding installed patches
> 
> 
> Hi Mladen,
> 
> thanks for your very fast reply.
> 
> > Why is opatch not the best option? Opatch works on 8i and is 
> > downloadable from there.
> 
> Our senior dba told me that opatch does not work on 8i. Guess 
> I should 
> not believe everything a collegue tells me. 
> 
> Do I need a 8i specific version our will the one I downloaded for 9i 
> work.
> 
> Thanks and regards,
> uwe  
> 
--
//www.freelists.org/webpage/oracle-l

Other related posts: