How to display Oracle version currently running? - Programmers Heaven

Howdy, Stranger!

It looks like you're new here. If you want to get involved, click one of these buttons!

Categories

How to display Oracle version currently running?

Bob_MitchellBob_Mitchell Posts: 9Member
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

  • Ara_camAra_cam Posts: 37Member
    [b][red]This message was edited by the Ara_cam at 2002-2-12 6:40:39[/red][/b][hr]
    : 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!


  • Bob_MitchellBob_Mitchell Posts: 9Member
    : [b][red]This message was edited by the Ara_cam at 2002-2-12 6:40:39[/red][/b][hr]
    : : 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!
    :
    :
    :

  • kevingkeving Posts: 20Member
    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.

  • mhammadqmhammadq Posts: 1Member
    Try this.

    Select * from v$version;


Sign In or Register to comment.