Re: Version of Oracle Database without connecting to the database.
- From: Dennis Yurichev <dennis@xxxxxxxxxx>
- To: fuadar@xxxxxxxxx
- Date: Tue, 04 Nov 2008 19:16:13 +0200
-----BEGIN PGP SIGNED MESSAGE-----
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.
- --
My PGP public key: http://yurichev.com/dennis.yurichev.asc
-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.4.8 (MingW32)
Comment: Using GnuPG with Mozilla - http://enigmail.mozdev.org
iEYEARECAAYFAkkQg10ACgkQ1YPmFmJG++M1OwCgxKzhoNdGwoDBhoTvz2BaqRcj
tC0AoM+QXRktl8U9KT6lsECuPclRccr7
=WkmL
-----END PGP SIGNATURE-----
--
//www.freelists.org/webpage/oracle-l
Other related posts:
