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
Comments
: 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!
: : 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!
:
:
:
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.
Select * from v$version;
Thanks, for help.