RE: Version of Oracle Database without connecting to the database.
- From: "Mercadante, Thomas F (LABOR)" <Thomas.Mercadante@xxxxxxxxxxxxxxxxx>
- To: <paul.baumgartel@xxxxxxxxxxxxxxxxx>, <ballester.david@xxxxxxxxx>, <fuadar@xxxxxxxxx>
- Date: Fri, 24 Oct 2008 14:37:40 -0400
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@xxxxxxxxxxxxx
[mailto:oracle-l-bounce@xxxxxxxxxxxxx] On Behalf Of Baumgartel, Paul
Sent: Friday, October 24, 2008 12:24 PM
To: ballester.david@xxxxxxxxx; fuadar@xxxxxxxxx
Cc: Bradd Piontek; oracle-l@xxxxxxxxxxxxx
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@xxxxxxxxxxxxxxxxx
www.credit-suisse.com
________________________________
From: oracle-l-bounce@xxxxxxxxxxxxx
[mailto:oracle-l-bounce@xxxxxxxxxxxxx] On Behalf Of David Ballester
Sent: Friday, October 24, 2008 12:21 PM
To: fuadar@xxxxxxxxx
Cc: Bradd Piontek; oracle-l@xxxxxxxxxxxxx
Subject: Re: Version of Oracle Database without connecting to the
database.
2008/10/24 Fuad Arshad <fuadar@xxxxxxxxx>
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
========================================================================
======
Other related posts:
