Re: How to determine the patch level of a database ?

From: Daniel Morgan <damorgan_at_x.washington.edu>
Date: Fri, 09 Jul 2004 15:41:57 -0700
Message-ID: <1089412932.389500@yasure>

Le JeanMimi wrote:

> Hello,
>
> We have upgraded our 9.2.0.1.0 oracle server to the 9.2.0.5.0 version
> (AIX 5L) :
>
> - we patched the software binaries with O.U.I
>
> - we patched some of the databases running on the machine ... but not
> all.
>
> The problem is : we don't remember exactly which databases were
> patched.
>
> Is it possible to retrieve this information somewhere ? (patch level
> of the datafiles ?)
>
>
> Thanks in advance.

SELECT ... FROM v_$version;
or
SELECT ... FROM dba_registry;

Daniel Morgan Received on Fri Jul 09 2004 - 17:41:57 CDT