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

At first, perhaps Opatch utility (which can be installed without affecting current software version) has a "lsinventory" argument which shows the installation path of the product.

But, if Oracle software has been installed without any "reference mark" of its version, I think the only way is connecting to database.

Alessandro

>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