Re: Find out oracle version

Kevin/Andy,

In Oracle7.3 there is a utility to provide the same information. It is $ORACLE_HOME/orainst/inspdver

Here is a sample output from it:

4.0.0.8.0            Oracle Unix Installer and Documentation Viewer
7.3.2.3.0            ORACLE Common Libraries and Utilities
2.3.2.1.0            SQL*Net (V2)
2.3.2.1.0            TCP/IP Protocol Adapter (V2)
1.3.2.0.0            Remote Operations
7.3.2.1.0            SLAX: parser
2.3.2.3.0            PL/SQL V2
7.3.2.3.0            ORACLE7 Distributed Database option
7.3.2.3.0            ORACLE7 Parallel Query option
7.3.2.3.0            Advanced Replication Option
2.3.2.0.0            Oracle Server Manager
7.3.2.3.0            ORACLE7 Server (RDBMS)
1.0.0.0.1            <Database Startup> Load Files
7.3.2.0.0            Oracle Intelligent Agent
7.3.2.3.0            ORACLE7 XA Library
7.3.2.1.0            Precomp
2.2.2.0.0            Pro*C
1.8.2.0.0            Pro*COBOL
3.3.2.0.0            SQL*Plus

Hope this gives you what you need.
Mike Morgan

Kevin Reardon <kreardon_at_cerere.na.astro.it> wrote in article <33EB6322.4E7F_at_cerere.na.astro.it>...
> Andy Harrison wrote:
> > Anyone know a way to find the version of rdbms from the command line,
> > as I have about 3000 machines on which I need to audit
>
> Andy,
>
> The installed writes a file called unix.rgs (in the newsletter they
> called it un-ix.prd, but no such file exists in my 7.3.2 installation)
> in the $ORACLE_HOME/orainst directory.

[snip of awk script ]

>
> kevin reardon
> Osservatorio Astronomico di Capodimonte
>
Received on Fri Aug 08 1997 - 00:00:00 CDT