Re: Retrieve Oracle Version

From: Snewber <snew_at_snew.com>
Date: Tue, 14 Jun 2005 10:49:24 +1000
Message-ID: <d8l9ik$2o7a$1@bunyip2.cc.uq.edu.au>

To really check all the version information correctly you also need to do this:

SELECT comp_name, version, status FROM dba_registry;

It is possible to start an instance with the wrong oracle home.

Tom wrote:
> Hello.
>
> I am a Unix administrator, learning Oracle. I'd like to have a Perl
> script run and collect the Oracle version from numerous servers, all
> running HP-UX.
>
> I know that I can log in via sqlplus as the system user and run "SELECT
> * FROM V$VERSION" however, I was wondering if there was a way to get
> the Oracle version without accessing the system views. Ideally, I'd
> like to do this without connecting to the DB at all.
>
> I appreciate any help.
> Tom
>
Received on Mon Jun 13 2005 - 19:49:24 CDT