RE: Finding installed patches (I was wrong)

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_at_teleos-web.de] 

> 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  

> 

--
http://www.freelists.org/webpage/oracle-l