What version of Oracle am I running

[Ratzie]

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?

[Steven E. Protter]

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

[Slawomir Gora]

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]

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

[Geoff Wild]

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

Rgds...Geoff

[Geoff Wild]

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

[Fred Ruffet]

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

[Ratzie]

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]

Hi there,

Try this:

SQL> select version from v$instance;

MB.

[Jean-Luc Oudart · Accepted solution]

Connect with SQlplus
enter the query

select * from v$version

you will get the answer

Regards
Jean-Luc