RE: Version of Oracle Database without connecting to the database.
Date: Fri, 24 Oct 2008 14:37:40 -0400
Message-ID: <ABB9D76E187C5146AB5683F5A07336FFE09411@EXCNYSM0A1AJ.nysemail.nyenet>
Except that Oratab only gives the location of the Oracle home - not the
version of the software.
I could create an Oracle home of "/tom/msaccess" and that's what would be in oratab.
Further, once you patch an Oracle home, oratab does not get touched. It only names the disk location of the software.
From: oracle-l-bounce_at_freelists.org
[mailto:oracle-l-bounce_at_freelists.org] On Behalf Of Baumgartel, Paul
Sent: Friday, October 24, 2008 12:24 PM
To: ballester.david_at_gmail.com; fuadar_at_yahoo.com
Cc: Bradd Piontek; oracle-l_at_freelists.org
Subject: RE: Version of Oracle Database without connecting to the
database.
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-lReceived on Fri Oct 24 2008 - 13:37:40 CDT