RE: Version of Oracle Database without connecting to the database.
- From: "Bort, Guillermo" <guillermo.bort@xxxxxxx>
- To: <fuadar@xxxxxxxxx>, <oracle-l@xxxxxxxxxxxxx>
- Date: Fri, 24 Oct 2008 11:47:07 -0500
You can try running sqlplus from the Oracle Home (without connecting
i.e. sqlplus /nolog), that will give you the version down to the
patchset.
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 Fuad Arshad
Sent: Friday, October 24, 2008 1:45 PM
To: oracle-l@xxxxxxxxxxxxx
Subject: Version of Oracle Database without connecting to the database.
Folks,
I'm trying to find a way to script finding an approximation of the
version of the database without connecting to the database itself.
The goal is to try to find out of the Oracle_home is a Oracle 10 home ,
9 home etc .
right now i'm doiing something like
DATAVERSION1=`echo $ORACLE_HOME | awk -F/ '{print $6}'`
expecting that $6 would lead me to something like
/usr/local/oracle/product/10.2
but this is not a very foolproof implementation since installs can take
various forms and break this implementation.
Any ideas of how i can get the oracle version info considering that i
will always know the value of $ORACLE_HOME.
--
//www.freelists.org/webpage/oracle-l
--
//www.freelists.org/webpage/oracle-l
Other related posts:
