Hello!

I need to know current version of Oracle running on our Sun Solaris box.

I was able to find the following directory:

/RDBMS/app/oracle/product/8.1.5

by using the command: echo $ORAHOME

I had thought there was a command that can be used from the Unix command line to tell one the current version of Oracle.

Thanks!
Bob Mitchell

This message was edited by the Ara_cam at 2002-2-12 6:40:39

---

: I need to know current version of Oracle running on our Sun Solaris box.
: I was able to find the following directory:
: /RDBMS/app/oracle/product/8.1.5
: by using the command: echo $ORAHOME
: I had thought there was a command that can be used from the Unix command line to tell one the current version of Oracle.
: Thanks!
: Bob Mitchell

Not sure how to do this from a unix prompt, but if you can connect to the database using sqlplus, it will show you the current version number after you log in. The Sql*Plus screen should look something like this:

SQL*Plus: Release 8.1.6.0.0 - Production on Tue Feb 12 07:44:19 2002

(c) Copyright 1999 Oracle Corporation. All rights reserved.


Connected to:
Oracle8i Enterprise Edition Release 8.1.6.3.0 - Production
With the Partitioning option
JServer Release 8.1.6.3.0 - Production


Which shows you that your client (SQL*Plus) is version 8.1.6.0, and you are connected to an enterprise edition of Oracle, version 8.1.6.3.

Hope this helps!

: This message was edited by the Ara_cam at 2002-2-12 6:40:39

---

: : I need to know current version of Oracle running on our Sun Solaris box.
: : I was able to find the following directory:
: : /RDBMS/app/oracle/product/8.1.5
: : by using the command: echo $ORAHOME
: : I had thought there was a command that can be used from the Unix command line to tell one the current version of Oracle.
: : Thanks!
: : Bob Mitchell
:
: Not sure how to do this from a unix prompt, but if you can connect to the database using sqlplus, it will show you the current version number after you log in. The Sql*Plus screen should look something like this:
:
: SQL*Plus: Release 8.1.6.0.0 - Production on Tue Feb 12 07:44:19 2002
:
: (c) Copyright 1999 Oracle Corporation. All rights reserved.
:
:
: Connected to:
: Oracle8i Enterprise Edition Release 8.1.6.3.0 - Production
: With the Partitioning option
: JServer Release 8.1.6.3.0 - Production
:
:
: Which shows you that your client (SQL*Plus) is version 8.1.6.0, and you are connected to an enterprise edition of Oracle, version 8.1.6.3.
:
: Hope this helps!
:
:
:

You could also use:
SELECT version FROM v$instance;
This would allow you to do it programmatically if required.
There is also other useful stuff in v$instance, such as the host and SID.

Try this.

Select * from v$version;