Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: How to find Oracle Version?

Re: How to find Oracle Version?

From: Sybrand Bakker <postbus_at_sybrandb.demon.nl>
Date: Tue, 6 Jul 1999 14:04:22 +0200
Message-ID: <931262620.29504.0.pluto.d4ee154e@news.demon.nl>


Hi,
SELECT * from v$version
connected as internal or sys.
This solution is platform-independent.
On unix port you should also be able to get your info by cat $ORACLE_HOME/rdbms/install/unix.rgs, but this most likely is an Unix-dependent solution

Hth,

Sybrand Bakker, Oracle DBA

<mike_coutts_at_my-deja.com> wrote in message news:7lsi8q$9tr$1_at_nnrp1.deja.com...
>
>
> Hi,
> I am a new guy as well and have run into a
> problem with this solution.
>
> What happens when there is no 'inspdver' program
> in the orainst directory? How do you find out
> then?
>
>
> In article <7jg3c0$psq$1_at_caley.wire.net.au>,
> "Roger Jackson" <rjackson_at_wire.net.au> wrote:
> > Mitch,
> >
> > FYI
> >
> > You can find out the version of all the Oracle
> products installed on your HP
> > box by going to $ORACLE_HOME/orainst and
> typing "inspdver" also without even
> > logging onto the database.
> >
> > Cheers,
> >
> > Roger.
> >
> > Mitch Robinson <ddfudge_at_primenet.com> wrote in
> message
> > news:375A003C.2EE34303_at_primenet.com...
> > > To whom it may be apparent.(smile)
> > >
> > > New Guy!!
> > > I am documenting our server (HP-UX 11.0).
> > > What command do I type into the shell to
> retrieve the version of oracle
> > > currently installed on our system?
> > >
> > > Thanks.
> > >
> > > Mitch
> > >
> > >
> > >
> > >
> >
> >
>
>
>
> Sent via Deja.com http://www.deja.com/
> Share what you know. Learn what you don't.
Received on Tue Jul 06 1999 - 07:04:22 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US