Re: Version of Oracle Database without connecting to the database.
- From: "Roman Podshivalov" <roman.podshivalov@xxxxxxxxx>
- To: fuadar@xxxxxxxxx
- Date: Fri, 24 Oct 2008 12:02:47 -0400
# $ORACLE_HOME/OPatch/opatch lsinventory | grep 'Oracle Database'
Oracle Database 10g
10.2.0.1.0
Oracle Database 10g Products
10.2.0.1.0
Oracle Database 10g Release 2 Patch Set 2
10.2.0.3.0
But you still depend on correctness of the installation, i.e. oraInst.loc
should exists and point to correct inventory and inventory itself shouldn't
be corrupted...
--romas
On Fri, Oct 24, 2008 at 11:45 AM, Fuad Arshad <fuadar@xxxxxxxxx> 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.
> --
> //www.freelists.org/webpage/oracle-l
>
>
>
Other related posts:
