Re: Oracle patching

From: Goran <goran99_remove_at_yahoo.com>
Date: Thu, 11 Dec 2003 16:10:01 +0100
Message-ID: <bra1ca$a4c$1@fegnews.vip.hr>

<sybrandb_at_yahoo.com> wrote in message
news:a1d154f4.0312110652.20fefce5_at_posting.google.com...
> "Joel Brunger" <joel7773_at_blueyonder.co.uk> wrote in message
news:<miYBb.21433$kh4.807_at_news-binary.blueyonder.co.uk>...
> > Hello All,
> >
> > This is the way within the database to check what Oracle patches and
> > security patches ?
> >
> > I know about v$version and the product_component_version
> >
> > I need to confirm to the customer whether pacthes have been applied,
> > especially
> > the security patches. (e.g. alert #62)
> >
> > Thanks very much in advance,
> > Joel.
>
> You would need to use the OUI to get a list of installed products
> including versions. You won't be able to retrieve from the database.
>
> Sybrand Bakker
> Senior Oracle DBA

Unfortunatelly there are no records for particular one-off patches in OraInventory, so OUI is not able to give that information. Generally there is no way of knowing if some additional patches are applied over an existing patchset.

Regards... Received on Thu Dec 11 2003 - 09:10:01 CST