General
cancel
Showing results for 
Search instead for 
Did you mean: 

What version of Oracle am I running

SOLVED
Go to solution
Ratzie
Super Advisor

What version of Oracle am I running

How do I tell what version of Oracle I am running.

I know if I go to /opt/app/oracle/product it tells me 8.1.7

But I need to get more granual.
The oracle sercurity alert says it is for...
Oracle8i Database Server Release 3, version 8.1.7.4

How can I fid that out?
12 REPLIES
Steven E. Protter
Exalted Contributor

Re: What version of Oracle am I running

8.1.7 is the major version.

8.1.7.4 is the patches version.

sqlplus

connect and check database status.

Check the dba_views or the v$database

That will give you a version number.

Write your own query.

SEP
Steven E Protter
Owner of ISN Corporation
http://isnamerica.com
http://hpuxconsulting.com
Sponsor: http://hpux.ws
Twitter: http://twitter.com/hpuxlinux
Founder http://newdatacloud.com
Slawomir Gora
Honored Contributor

Re: What version of Oracle am I running

Hi,

find file alert_${SID}.log there will be
log from startup DB.
ex:
Starting up ORACLE RDBMS Version: 9.2.0.1.0.

or you can log to database

sqlplus /nolog
there will be line:
SQL*Plus: Release 9.2.0.4.0 - Production on Thu Sep 2 16:29:40 2004
Jeff Schussele
Honored Contributor

Re: What version of Oracle am I running

Hi,

You can check the Oracle logs. Here, our DBAs locate the export log at
/oracle/admin/common/log/SID_NAME & it's named exp/se
It may be different at your site.

It would contain a line like:

Export: Release 8.1.7.4.0 - Production on Thu Sep 2 01:00:07 2004

There are probably several other logs that would contain the *exact" release level. Search your system for them.

HTH,
Jeff
PERSEVERANCE -- Remember, whatever does not kill you only makes you stronger!
Geoff Wild
Honored Contributor

Re: What version of Oracle am I running

You will have to make a connection to the database....best to ask your DBA.

Rgds...Geoff
Proverbs 3:5,6 Trust in the Lord with all your heart and lean not on your own understanding; in all your ways acknowledge him, and he will make all your paths straight.
Geoff Wild
Honored Contributor

Re: What version of Oracle am I running

Just got this from our dba:

You can log on, and see the version on connect:

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

Since you don't have our database passwords, but you are UNIX gods, you can go sqlplus '/ as sysdba' from our oracle userid.


Rgds...Geoff
Proverbs 3:5,6 Trust in the Lord with all your heart and lean not on your own understanding; in all your ways acknowledge him, and he will make all your paths straight.
Fred Ruffet
Honored Contributor

Re: What version of Oracle am I running

SEP is right. You must connect to DB and query v$database.

Other solutions like looking at exp log or sqlplus banner will only give you utilities versions.

Regards,

Fred
--

"Reality is just a point of view." (P. K. D.)
Ratzie
Super Advisor

Re: What version of Oracle am I running

when I query the v$database, it does not give me the version, I get version time, created, but not the version...
Marcel Boogert_1
Trusted Contributor

Re: What version of Oracle am I running

Hi there,

Try this:

SQL> select version from v$instance;

MB.
Jean-Luc Oudart
Honored Contributor
Solution

Re: What version of Oracle am I running

Connect with SQlplus
enter the query

select * from v$version

you will get the answer

Regards
Jean-Luc
fiat lux
Yogeeraj_1
Honored Contributor

Re: What version of Oracle am I running

hi,

querying the v$version should give you the exact version.

e.g.
yd@MYDB.MU> select * from v$version;

BANNER
________________________________________________________________
Oracle8i Enterprise Edition Release 8.1.7.4.0 - 64bit Production
PL/SQL Release 8.1.7.4.0 - Production
CORE 8.1.7.0.0 Production
TNS for HPUX: Version 8.1.7.4.0 - Production
NLSRTL Version 3.4.1.0.0 - Production

5 rows selected.

Elapsed: 00:00:00.03
yd@MYDB.MU>

regards
Yogeeraj
No person was ever honoured for what he received. Honour has been the reward for what he gave (clavin coolidge)
Emilio Brusa
Frequent Advisor

Re: What version of Oracle am I running

Hi,
In SQlplus

select * from v$version

E.

Ratzie
Super Advisor

Re: What version of Oracle am I running

Thanks