RE: Version of Oracle Database without connecting to the database.

From: Bort, Guillermo <>
Date: Fri, 24 Oct 2008 13:37:38 -0500
Message-ID: <>

That's why I suggested the sqlplus in the same oracle home, given that he knows the location

Guillermo Alan Bort
DBA / DBA Main Team

EDS, an HP company

-----Original Message-----
[] On Behalf Of Pete Finnigan Sent: Friday, October 24, 2008 4:35 PM
Cc:; Subject: Re: Version of Oracle Database without connecting to the database.

Hi Keith,

Thats no good as that the version of sqlplus on your client, even if thats the server where the database is hosted its not guarenteed to be the same version as the database



Keith Moore wrote:
> Some of the other suggestions may be better but this will also work:
> sqlplus /nolog
> SQL*Plus: Release - Production on Fri Oct 24 11:01:34 2008
> Copyright (c) 1982, 2006, Oracle. All Rights Reserved.
> SQL>
> Or to not be stuck at the SQL prompt:
> echo 'exit' | sqlplus /nolog

>> lsnrctl status will give you the listener binary  version
>> may be can help

> --

Pete Finnigan
Principal Consultant Limited

Registered in England and Wales
Company No: 4664901

Specialists in database security.

If you need help to audit or secure an Oracle database, please ask for
details of our courses and consulting services

Phone: 0044 (0)1904 791188
Fax  : 0044 (0)1904 791188
Mob  : 0044 (0)7742 114223
site :

Please note that this email communication is intended only for the
addressee and may contain confidential or privileged information. The
contents of this email may be circulated internally within your
organisation only and may not be communicated to third parties without
the prior written permission of Limited.  This email is
not intended nor should it be taken to create any legal relations,
contractual or otherwise.


Received on Fri Oct 24 2008 - 13:37:38 CDT

Original text of this message