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

Not sure if you already thought of utilizing "oratab"

Regards,
Santhosh Channa

-----Original Message-----

From: Fuad Arshad [mailto:fuadar_at_yahoo.com] Sent: Friday, October 24, 2008 11:45 AM
To: oracle-l_at_freelists.org
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.
--

http://www.freelists.org/webpage/oracle-l
--

http://www.freelists.org/webpage/oracle-l Received on Fri Oct 24 2008 - 10:53:47 CDT