DomainKey-Signature: a=rsa-sha1; c=nofws;        d=gmail.com; s=gamma;        h=message-id:date:from:to:subject:cc:in-reply-to:mime-version         :content-type:references;        b=bmoTaH/B8HC0bYb+VOmDwVyjxT/gFRX+emgws3nItADsrINniNynjNKB7FcnyF1B9e         h671pbxXl3XkX1tK3P23MzrCyDEaM/RVraeki8QK4cBxZFdMNPT+sOo39qiMZVXuEJjY         TnrW0FAKucUhoreebPDfoZOp/z7A78SgdH30c=
Message-ID: <e9569ef30810240858u31382b8ew9749f7eb608eacba@mail.gmail.com>
Date: Fri, 24 Oct 2008 10:58:31 -0500
From: "Bradd Piontek" <piontekdd@gmail.com>
To: fuadar@yahoo.com
Subject: Re: Version of Oracle Database without connecting to the database.
Cc: oracle-l@freelists.org
In-Reply-To: <901945.31761.qm@web82106.mail.mud.yahoo.com>
MIME-Version: 1.0
Content-Type: multipart/alternative; boundary="----=_Part_4122_6223577.1224863911623"
References: <901945.31761.qm@web82106.mail.mud.yahoo.com>
Sender: oracle-l-bounce@freelists.org
Errors-to: oracle-l-bounce@freelists.org
Precedence: normal
Reply-to: piontekdd@gmail.com
------=_Part_4122_6223577.1224863911623
Content-Type: text/plain; charset=ISO-8859-1
Content-Transfer-Encoding: 7bit
Content-Disposition: inline

or you could try  "sqlplus -v'
# sqlplus -v

SQL*Plus: Release 10.2.0.3.0 - Production

sqlplus doesnt' always match the exact patchset of the database, but it'll
get you the major level.
I'd use that in conjuction with the oratab to get the oracle_homes.

opatch is nice, but it assumes you know the oracle_home already.

Bradd Piontek
  "Next to doing a good job yourself,
        the greatest joy is in having someone
        else do a first-class job under your
        direction."
 -- William Feather


On Fri, Oct 24, 2008 at 10:45 AM, Fuad Arshad <fuadar@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
>
>
>

------=_Part_4122_6223577.1224863911623
Content-Type: text/html; charset=ISO-8859-1
Content-Transfer-Encoding: 7bit
Content-Disposition: inline

or you could try&nbsp; &quot;sqlplus -v&#39; <br># sqlplus -v<br><br>SQL*Plus: Release 10.2.0.3.0 - Production<br><br>sqlplus doesnt&#39; always match the exact patchset of the database, but it&#39;ll get you the major level.<br>
I&#39;d use that in conjuction with the oratab to get the oracle_homes.<br><br>opatch is nice, but it assumes you know the oracle_home already.<br><br clear="all">Bradd Piontek<br> &nbsp; &quot;Next to doing a good job yourself, <br>
 &nbsp; &nbsp; &nbsp; &nbsp; the greatest joy is in having someone <br> &nbsp; &nbsp; &nbsp; &nbsp; else do a first-class job under your &nbsp;<br> &nbsp; &nbsp; &nbsp; &nbsp; direction.&quot;<br> &nbsp;-- William Feather<br>
<br><br><div class="gmail_quote">On Fri, Oct 24, 2008 at 10:45 AM, Fuad Arshad <span dir="ltr">&lt;<a href="mailto:fuadar@yahoo.com">fuadar@yahoo.com</a>&gt;</span> wrote:<br><blockquote class="gmail_quote" style="border-left: 1px solid rgb(204, 204, 204); margin: 0pt 0pt 0pt 0.8ex; padding-left: 1ex;">
Folks,<br>
I&#39;m trying to find a way to script finding &nbsp;an approximation of the version of the database without connecting to the database itself.<br>
The goal is to try to find out of the Oracle_home is a Oracle 10 home , 9 home etc .<br>
<br>
right now i&#39;m doiing something like<br>
DATAVERSION1=`echo $ORACLE_HOME | awk -F/ &#39;{print $6}&#39;`<br>
expecting that $6 &nbsp;would lead me to something like /usr/local/oracle/product/10.2<br>
<br>
but this is not a very foolproof implementation since installs can take various forms and break this implementation.<br>
<br>
<br>
Any ideas of how i can get the oracle version info considering that i &nbsp;will always know the value of $ORACLE_HOME.<br>
<font color="#888888">--<br>
<a href="http://www.freelists.org/webpage/oracle-l" target="_blank">http://www.freelists.org/webpage/oracle-l</a><br>
<br>
<br>
</font></blockquote></div><br>

------=_Part_4122_6223577.1224863911623--
--
http://www.freelists.org/webpage/oracle-l