Re: How do I see Oracle patches applied?

From: Jeremiah Wilton <jeremiah_at_wolfenet.com>
Date: Wed, 7 Oct 1998 23:00:31 -0700
Message-ID: <Pine.OSF.3.95.981007223749.24251B-100000@gonzo.wolfenet.com>

On Wed, 7 Oct 1998, Ros O'Mahony wrote:
>
> Melisa Thompson wrote:
> >
> > Does anyone know how to see what Oracle patches have been applied to the
> > Oracle RDBMS product?
> >
> look for the adpatch log file. Where it is depends on your OS

Hmm, I think She wants to know the patch level for the Oracle RDBMS, not the Applications.

In Oracle8, there is a new tool in $ORACLE_HOME/bin called "owhat." If you run owhat against the Oracle RDBMS executable, it is supposed to list the one-off RDBMS patches you have installed.

Example:
owhat $ORACLE_HOME/bin/oracle

Unfortunately, it doesn't work on the version I am running, Oracle 8.0.4.2 on Digital Unix. It just gives no output, and I just installed a one-off patch.

For previous versions, there is a way to check the version of specific modules within the RDBMS, like kdx or kmcdvc, but I'm not sure how to do it.

--
Jeremiah Wilton
http://www.wolfenet.com/~jeremiah Received on Thu Oct 08 1998 - 01:00:31 CDT