Re: Version of Oracle Database without connecting to the database.
- From: "Niall Litchfield" <niall.litchfield@xxxxxxxxx>
- To: guillermo.bort@xxxxxxx, fuadar@xxxxxxxxx, oracle-l@xxxxxxxxxxxxx
- Date: Fri, 24 Oct 2008 18:06:33 +0100
Not in all versions. 8i for example didnt do the patch level in the
sqlplus banner.
On 10/24/08, Bort, Guillermo <guillermo.bort@xxxxxxx> wrote:
> You can try running sqlplus from the Oracle Home (without connecting
> i.e. sqlplus /nolog), that will give you the version down to the
> patchset.
>
> Guillermo Alan Bort
> DBA / DBA Main Team
>
> EDS, an HP company
>
> -----Original Message-----
> From: oracle-l-bounce@xxxxxxxxxxxxx
> [mailto:oracle-l-bounce@xxxxxxxxxxxxx] On Behalf Of Fuad Arshad
> Sent: Friday, October 24, 2008 1:45 PM
> To: oracle-l@xxxxxxxxxxxxx
> Subject: Version of Oracle Database without connecting to the database.
>
> 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.
> --
> //www.freelists.org/webpage/oracle-l
>
>
> --
> //www.freelists.org/webpage/oracle-l
>
>
>
--
Sent from Google Mail for mobile | mobile.google.com
Niall Litchfield
Oracle DBA
http://www.orawin.info
--
//www.freelists.org/webpage/oracle-l
Other related posts:
