Locating Oracle Versions

From: Kevin Seneviratne <kevins_at_connect.com.au>
Date: Thu, 30 Jul 1998 17:16:07 +1000
Message-ID: <35C01DB7.ED3DAB4E@connect.com.au>

Hi All,

I need to figure out the exact version of the Oracle Server prior to establishing a connection.

A quick look shows $ORACLE_HOME/orainst/RELVER seems to have what I want, at least on Solaris w/ 7.3.2 and 8.0.4.

Will this work in most cases ?

Is there a smarter more reliable way to do this ?

Things like
SELECT * FROM product_component_version; are no use as I want the info prior to connection.

Many thanks in advance

Kevin Seneviratne Received on Thu Jul 30 1998 - 02:16:07 CDT