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

From: Dennis Yurichev <>
Date: Tue, 04 Nov 2008 19:16:13 +0200
Message-ID: <>

Hash: SHA1

Fuad Arshad wrote:
> 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.

oracommon(9|10|11).dll contain exported variable "_vsnnum", which is 32-bit DWORD and reflect precise Oracle 4d or 5d version. This information is used in V$VERSION view.

iEYEARECAAYFAkkQg10ACgkQ1YPmFmJG++M1OwCgxKzhoNdGwoDBhoTvz2BaqRcj tC0AoM+QXRktl8U9KT6lsECuPclRccr7

Received on Tue Nov 04 2008 - 11:16:13 CST

Original text of this message