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

From: Alessandro Vercelli <>
Date: Fri, 24 Oct 2008 18:01:05 +0200
Message-Id: <K9935T$>

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.


>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.

Received on Fri Oct 24 2008 - 11:01:05 CDT

Original text of this message