Re: How to tell which PATCH I have in Oracle 8.1.7.4?

dominica_at_gmail.com wrote:
> Hi All,
>
>
> Sorry this is pretty DUMB question.
> I have applied the patch for alert 68 recently.
> I check V$version table or even v$instance in Oracle.
> Somehow, I have trouble finding which PATCH (of Oracle ) I am using.
>
> I am using Oracle 8.1.7.4 on Solaris 5.9.
> How could I find out ??
>
>
> Thanks,
>
>
>
> Dominica

You can use the same tool which you used to install SA 68: opatch.

$opatch lsinventory

...
  Installed Patch List:

1. Patch 3811887 applied on Thu Dec 02 06:24:00 EST 2004 [ Base Bug(s): 3828166 3811887 ]

hth

CharlieB Received on Tue May 03 2005 - 09:22:51 CDT