DBAsupport.com Forums - Powered by vBulletin
Page 1 of 2 12 LastLast
Results 1 to 10 of 16

Thread: How to check the version number?

  1. #1
    Join Date
    May 2002
    Posts
    26
    How to check the version number of an Oracle installation?

    (a) Use OUI (Oracle Universal Installer)
    (b) select * from v$version;


    How to check the version number of an Oracle database?
    (a) Use OUI (Oracle Universal Installer)
    (b) select * from v$version;


    Could you please help? Thank you!

  2. #2
    Join Date
    Apr 2000
    Location
    Baltimore, MD
    Posts
    759
    select * from v$version;

  3. #3
    Join Date
    May 2002
    Posts
    26
    Are you sure v$version can display the version number of the database? I heard the v$version only display the version number of the Oracle installation.

    Please advise. My concern is that we have a database that is not updated to the latest version. When I use 8172 point to it, the v$version shows 8172. This is not correct because the database has not been updated.

    So, if you are not sure whether the db has been updated or not, how do you know the correct version number of the db?

  4. #4
    Join Date
    Aug 2001
    Posts
    75
    Lisa,
    You are correct that v$version does not show the version of database. It only shows versions numbers of product installed.
    I have downloaded the patch 9.0.1.3.0 and only installed patch by using Installer and did not run Oracle scripts (catalog, catproc etc) but still v$version shows that I have 9.0.1.3.0

    I don't know how you can see this information.
    Originally posted by DBA_Lisa
    Are you sure v$version can display the version number of the database? I heard the v$version only display the version number of the Oracle installation.

    Please advise. My concern is that we have a database that is not updated to the latest version. When I use 8172 point to it, the v$version shows 8172. This is not correct because the database has not been updated.

    So, if you are not sure whether the db has been updated or not, how do you know the correct version number of the db?
    OCP 8i

  5. #5
    Join Date
    Aug 2000
    Location
    Singapore
    Posts
    323
    Try with sqlplus system/manager and see...


    Nagesh

  6. #6
    Join Date
    May 2002
    Posts
    26
    What do you mean?

  7. #7
    Join Date
    Oct 2001
    Posts
    126
    How about this.
    select version from v$instance;

    Susan

  8. #8
    Join Date
    May 2002
    Posts
    26
    I don't think ANY v$ views can tell the version about the database. Here is my reasoning:

    1. start an instance in NOMOUNT.
    2. Now you can check v$version, v$instance

    However, the datafiles have not been accessed. The v$ views are actually derived from the Oracle Kernal. It's about the version number of installed Oracle product. It's NOT for the database's version number.

    So, doesn anybody there can answer this question?

  9. #9
    Join Date
    Aug 2001
    Posts
    75
    Lisa,
    I don't think you can find this information. If oracle patch has been Installed but you did not applied the patch instructions, I guess there is no way to tell. If these is difference between major version of datafile and software installed e.g. If the datafiles are 8.1.6 version and suppose you use oracle 9i software to mount oracle 8i database, I am sure , you will get error.

    Sanjay

    Originally posted by DBA_Lisa
    I don't think ANY v$ views can tell the version about the database. Here is my reasoning:

    1. start an instance in NOMOUNT.
    2. Now you can check v$version, v$instance

    However, the datafiles have not been accessed. The v$ views are actually derived from the Oracle Kernal. It's about the version number of installed Oracle product. It's NOT for the database's version number.

    So, doesn anybody there can answer this question?
    OCP 8i

  10. #10
    Join Date
    May 2002
    Posts
    26
    Thanks!

    Are there any comments on this?

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  


Click Here to Expand Forum to Full Width