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

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-----
From: oracle-l-bounce@xxxxxxxxxxxxx
[mailto:oracle-l-bounce@xxxxxxxxxxxxx] On Behalf Of Pete Finnigan
Sent: Friday, October 24, 2008 4:35 PM
To: kmoore@xxxxxxxxxxxx
Cc: fuadar@xxxxxxxxx; oracle-l@xxxxxxxxxxxxx
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

cheers

Pete

Keith Moore wrote:
> Some of the other suggestions may be better but this will also work:
> 
> sqlplus /nolog
> 
> SQL*Plus: Release 10.2.0.3.0 - 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
> 
> 
> --
> http://www.freelists.org/webpage/oracle-l
> 
> 
> 

-- 

Pete Finnigan
Principal Consultant
PeteFinnigan.com 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
email: pete@xxxxxxxxxxxxxxxx
site : http://www.petefinnigan.com

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 PeteFinnigan.com Limited.  This email is
not intended nor should it be taken to create any legal relations,
contractual or otherwise.

--
http://www.freelists.org/webpage/oracle-l


--
http://www.freelists.org/webpage/oracle-l

Other related posts: