how to find oracle version?

[brian_31]

Team:

Please help me to find out the version of oracle i run on a given 11.0 64 bit hp-ux 9000 server.

Thanks

Brian.

[Nicolas Dumeige]

select version from v$instance;
or
alerteSID.log

[Robert-Jan Goossens]

Hi Brian,

Check this link,

http://www.techonthenet.com/oracle/questions/version.htm

Regards,
Robert-Jan

[Sundar_7]

Hi Brian,

Setup the environment variables for an instance and use the svrmgrl.

It gives you the version number

Sundar

[Nicolas Dumeige]

or check the oraInventory/InstallAction.log

but, you seem ta have posted twice the same question... double checking ? ;)

[Hein van den Heuvel]

Sundar wrote:

" Setup the environment variables for an instance and use the svrmgrl."

If that works, then you know you are still running an old version before 9i, (or you played around with the images).
svrmgrl was retired as of 9i in favor of sqlplus for everything.

With sqlplus you will get the server Oracle version listed right after the "Connected to:" message (or to corresponding NLS text).
Do NOT get confused with the initial version reported which is that of SQL*Plus itself. Often (for a local connecttion!) it is the same, but it may well be different. Example below.

Hein.

4> svrmgrl
svrmgrl: Command not found.
5> sqlplus

SQL*Plus: Release 9.2.0.4.0 - Production on Wed Mar 31 16:02:53 2004

Copyright (c) 1982, 2002, Oracle Corporation. All rights reserved.

Enter user-name: / as sysdba

Connected to:
Oracle9i Enterprise Edition Release 9.2.0.4.0 - 64bit Production
With the Partitioning option
JServer Release 9.2.0.4.0 - Production

[twang]

select * from v$version

[Sathish C]

Hi
One of the other easy way is just call the sqlplus binary and she will tell you what is the exact version , you don't even has to have oracle user name .

Thanx

[Hein van den Heuvel]

Sathish,
" sqlplus binary... will tell you what is the exact version , you don't even has to have oracle user name . "

Right. And that may well suffice. BUT...
Without username it will tell you the SQL*Plus version, which may or might not match the Server version. Often they match, but not always. You have to be carefull, specifically for tnsnames connections and when using multiple Oracle instances on one box.

[Any solution with a 'select' is kinda redundant because sqlplus/svrmgrl will already have displayed the version :^]

Hein.

[SANTOSH S. MHASKAR]

Use svrmgrl or sqlplus it will give u the version number of Oracle server.

-Santosh

[Volker Borowski]

Hi,

as already said, sqlplus can have a very diffrent release that the database itself.

Some additional checks:

# strings $ORACLE_HOME/bin/oracle | grep Version
NLSRTL Version 9.2.0.1.0 - Production
#

SELECT * FROM DBA_REGISTRY -- Release 9 and up


Hope this helps
Volker

[Geoff Wild]

Only way I know - is to login via sqlplus - as it displays Oracle version in banner...

Rgds..Geoff

[Jim Mallett]

If your Oracle Admin trusts you as little as you trust him, you may not be able to run a query against an Oracle instance.

What I do to see what versions are running (because you can be running multiple versions), is check the oratab file. I believe the default location is /etc/oratab

prod:/u01/dba/oracle/prodora/8.1.7:Y
delta:/u01/dba/oracle/prodora/8.1.6:Y
test:/u01/dba/oracle/prodora/8.1.6:N
corp:/u01/dba/oracle/prodora/8.1.6:Y

[Nathan Hayden]

So is there no way to detect the version without actually firing up Oracle? (I'm actually trying to detect it across several platforms)

[Jeff Schussele]

Hi,

I just run
ps -fu oracle
or whatever the controlling user is..
and check the path to the listener.
Most DBAs will set up a path like:
/oracle/product/8.1.7 or
/oracle/product/9.2.0
to clue you in.
Be advised that one *can* run multiple versions.
And IF your DBAs aren't doing this, then adjust their attitude. I find a Louisville slugger fits the bill - usually.

My 2 cents,
Jeff

[Navin Bhat_2]

Open the Oracles alert log and you can find the version from there.