Re: security patches in any views?

On Mar 18, 3:03 pm, Mark D Powell <Mark.Pow..._at_eds.com> wrote:
> On Mar 18, 2:20 pm, bdbafh <bdb..._at_gmail.com> wrote:
>
>
>
>
>
> > On Mar 18, 1:31 pm, NetComrade <netcomradeNS..._at_bookexchange.net>
> > wrote:
>
> > > Is there are a way to query all the security patches applied on a db?,
> > > or is that a function of opatch only?
>
> > > Need for '3rd party' auditing purposes.
>
> > > thanks
> > > .......
> > > We run Oracle 9iR2,10gR2, 10g2RAC on RH4/RH5 and Solaris 10 (Sparc)
> > > remove NSPAM to email
>
> > This is a RH 4 box (U5) running 32 bit Oracle, 32 bit Linux.
> > Its current and hasn't had the 10.2.0.4 patchset applied yet (but its
> > sister test box has).
>
> > $ sqlplus / as sysdba
>
> > SQL*Plus: Release 10.2.0.3.0 - Production on Tue Mar 18 14:17:35 2008
>
> > Copyright (c) 1982, 2006, Oracle.  All Rights Reserved.
>
> > Connected to:
> > Oracle Database 10g Release 10.2.0.3.0 - Production
>
> > SQL> select * from registry$history;
>
> > ACTION_TIME
> > ---------------------------------------------------------------------------
> > ACTION                         NAMESPACE
> > ------------------------------ ------------------------------
> > VERSION                                ID
> > ------------------------------ ----------
> > COMMENTS
> > ---------------------------------------------------------------------------­­-----
>
> > 17-FEB-08 09.23.10.145133 AM
> > CPU                            SERVER
> > 10.2.0.3.0                        6646853
> > CPUJan2008
>
> > 17-FEB-08 09.39.24.356214 AM
> > CPU
> >                                   6452863
> > view recompilation
>
> > hth.
>
> > -bdbafh
>
> Nice to know about though this only works on 10g+ and I had to use a
> sysdba connection as just selecting via the DBA role did not work.
>
> With the version 9 databases I would think the $ORACLE_HOME/OPatch/
> opatch lsinventory
> command is we have.
>
> HTH -- Mark D Powell --- Hide quoted text -
>
> - Show quoted text -

I find it also works on 9.2.0.8.0:

SQL> select * From registry$history;

ACTION_TI ACTION                         NAMESPACE
--------- ------------------------------
------------------------------
VERSION                                ID
------------------------------ ----------

                                  6079582

SQL> select version from v$instance;

VERSION

SQL> David Fitzjarrell Received on Tue Mar 18 2008 - 15:10:40 CDT