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

From: Baumgartel, Paul <paul.baumgartel_at_credit-suisse.com>
Date: Fri, 24 Oct 2008 12:24:18 -0400
Message-ID: <21469B88E0EA11498818517F210335310455B788@EPRI17P32001A.csfb.cs-group.com>


David is right. I'd suggest another solution, such as inspecting oratab.  

Paul Baumgartel
CREDIT SUISSE
Information Technology
Prime Services Databases Americas
One Madison Avenue
New York, NY 10010
USA
Phone 212.538.1143
paul.baumgartel_at_credit-suisse.com
www.credit-suisse.com  


From: oracle-l-bounce_at_freelists.org
[mailto:oracle-l-bounce_at_freelists.org] On Behalf Of David Ballester Sent: Friday, October 24, 2008 12:21 PM
To: fuadar_at_yahoo.com
Cc: Bradd Piontek; oracle-l_at_freelists.org Subject: Re: Version of Oracle Database without connecting to the database.

2008/10/24 Fuad Arshad <fuadar_at_yahoo.com>

	here is what i did to get my solution 
	sqlplus -v | awk -F"." '{ print $1 }' | awk '{ print $NF }'
	
	the answer gives me what i  was looking for 
	
	Thanks all.



May be I'm wrong but, sqlplus -v gives you the sqlplus binary version, not the server one. You can have a client in 11g and several databases in 11g, 10g, 9i... in the same host

D.



Please access the attached hyperlink for an important electronic communications disclaimer:

http://www.credit-suisse.com/legal/en/disclaimer_email_ib.html


--
http://www.freelists.org/webpage/oracle-l
Received on Fri Oct 24 2008 - 11:24:18 CDT

Original text of this message