Re: security patches in any views?

On Mar 18, 4:10 pm, "fitzjarr..._at_cox.net" <fitzjarr..._at_cox.net> wrote:
> 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
> ------------------------------ ----------
> COMMENTS
> ---------------------------------------------------------------------------­-----
> 17-NOV-07 CPU
>                                   6079582
> CPUJul2007
>
> SQL> select version from v$instance;
>
> VERSION
> -----------------
> 9.2.0.8.0
>
> SQL>
>
> David Fitzjarrell- Hide quoted text -
>
> - Show quoted text -

OK - I had tested on 9.2.0.6. I should have listed the full version.

• Mark D Powell --