Re: get version number with SQL query?

From: Daniel Morgan <damorgan_at_exxesolutions.com>
Date: Mon, 01 Sep 2003 16:43:36 -0700
Message-ID: <3F53D9A7.68ED78E8@exxesolutions.com>

kni wrote:

> "Daniel Morgan" <damorgan_at_exxesolutions.com> wrote in message
> news:3F536186.B9CB23E0_at_exxesolutions.com...
> > Niall Litchfield wrote:
> >
> > > "vipan" <dba_at_no_spam.netscape.net> wrote in message
> > > news:3F5332C0.6090001_at_no_spam.netscape.net...
> > > > Hi
> > > >
> > > > you can query DBA_REGISTRY view and get the version of installed
> > > components.
> > >
> > > Not on any of my 8i databases you can't.
> > >
> > > --
> > > Niall Litchfield
> > > Oracle DBA
> > > Audit Commission UK
> >
> > Not with 9i either as clearly shown by the following.
> > ===========================================
> >
> > In fact the following is what is produced:
> >
> > SQL*Plus: Release 9.2.0.2.0 - Production on Mon Sep 1 08:08:14 2003
> >
> > Copyright (c) 1982, 2002, Oracle Corporation. All rights reserved.
> >
> >
> > Connected to:
> > Oracle9i Enterprise Edition Release 9.2.0.2.1 - Production
> > With the Partitioning, OLAP and Oracle Data Mining options
> > JServer Release 9.2.0.2.0 - Production
> >
> > SQL> desc dba_registry
> > Name Null? Type
> > ----------------------------------------- -------- ---------------
> > COMP_ID NOT NULL VARCHAR2(30)
> > COMP_NAME VARCHAR2(255)
> > VERSION VARCHAR2(30)
> > STATUS VARCHAR2(11)
> > MODIFIED VARCHAR2(20)
> > CONTROL NOT NULL VARCHAR2(30)
> > SCHEMA NOT NULL VARCHAR2(30)
> > PROCEDURE VARCHAR2(61)
> > STARTUP VARCHAR2(8)
> > PARENT_ID VARCHAR2(30)
> >
> > SQL> select version from dba_registry;
> >
> > VERSION
> > ------------------------------
> > 9.2.0.1.0
> > 9.2.0.1.0
> > 9.2.0.1.0
> >
> > SQL>
> >
> > ===========================================
> >
> > dba_registry shows 9.2.0.1.0 and the fact, as indicating at login is
> > clearly different.
> >
> > --
> > Daniel Morgan
> > http://www.outreach.washington.edu/extinfo/certprog/oad/oad_crs.asp
> > http://www.outreach.washington.edu/extinfo/certprog/aoa/aoa_main.asp
> > damorgan_at_x.washington.edu
> > (replace 'x' with a 'u' to reply)
> >
> >
> This is what I receive as sysdba:

>

> SQL*Plus: Release 9.2.0.4.0 - Production on Man Sep 1 21:14:18

>

> Copyright (c) 1982, 2002, Oracle Corporation. All rights reserved.

>

> Connected to:
> Oracle9i Enterprise Edition Release 9.2.0.4.0 - Production
> With the Partitioning, OLAP and Oracle Data Mining options
> JServer Release 9.2.0.4.0 - Production

>

> SQL> select comp_name, version from dba_registry;

>

> Oracle9i Catalog Views 9.2.0.4.0
> Oracle9i Packages and Types 9.2.0.4.0
> Oracle Workspace Manager 9.2.0.1.0
> JServer JAVA Virtual Machine 9.2.0.4.0
> Oracle XDK for Java 9.2.0.6.0
> Oracle9i Java Packages 9.2.0.4.0
> Oracle interMedia 9.2.0.4.0
> Spatial 9.2.0.4.0
> Oracle Text 9.2.0.4.0
> Oracle XML Database 9.2.0.4.0
> Oracle Ultra Search 9.2.0.4.0
> Oracle Data Mining 9.2.0.4.0
> OLAP Analytic Workspace 9.2.0.4.0
> Oracle OLAP API 9.2.0.4.0
> OLAP Catalog 9.2.0.4.0

>
> 15 rows selected.

What is your point? The patch from 9.2.0.1 to 9.2.0.2 does not update dba_registry. It is, however, accurately reflected in v_$version.

If something is not always accurate it can not be depended upon.

--
Daniel Morgan
http://www.outreach.washington.edu/extinfo/certprog/oad/oad_crs.asp
http://www.outreach.washington.edu/extinfo/certprog/aoa/aoa_main.asp
damorgan_at_x.washington.edu
(replace 'x' with a 'u' to reply)

Received on Mon Sep 01 2003 - 18:43:36 CDT