Howdy, Stranger!

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

Categories

Welcome to the new platform of Programmer's Heaven! We apologize for the inconvenience caused, if you visited us from a broken link of the previous version. The main reason to move to a new platform is to provide more effective and collaborative experience to you all. Please feel free to experience the new platform and use its exciting features. Contact us for any issue that you need to get clarified. We are more than happy to help you.

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.