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 > > > -- > //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. -- //www.freelists.org/webpage/oracle-l -- //www.freelists.org/webpage/oracle-l