Re: Version of Oracle Database without connecting to the database.
Date: Tue, 4 Nov 2008 13:53:13 -0800
Message-ID: <bf46380811041353q72996481r61ed714e047aaaa0@mail.gmail.com>
Here's yet another way:
grep -iE 'RDBMS version number|RDBMS release number'
$ORACLE_HOME/rdbms/admin/dbmsutil.sql
version constant pls_integer := 9; -- RDBMS version number
release constant pls_integer := 2; -- RDBMS release number
Jared Still
Certifiable Oracle DBA and Part Time Perl Evangelist
On Fri, Oct 24, 2008 at 7:45 AM, Fuad Arshad <fuadar_at_yahoo.com> 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.
>
>
> 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-lReceived on Tue Nov 04 2008 - 15:53:13 CST