DBAsupport.com Forums - Powered by vBulletin
Page 2 of 2 FirstFirst 12
Results 11 to 16 of 16

Thread: How to check the version number?

  1. #11
    Join Date
    May 2002
    Posts
    26
    Could somebody post a better solution?

    What if you get a db that did not tell you the version number? What are you gonna do?

  2. #12
    Join Date
    Jun 2000
    Location
    Madrid, Spain
    Posts
    7,447
    I never get that because I apply the scripts after patching

  3. #13
    Join Date
    Apr 2002
    Posts
    86

    Cool

    THE BEST SOLUTION :

    SELECT * FROM product_component_version;

    Harry

  4. #14
    Join Date
    Oct 2001
    Location
    Hornchurch, Essex UK
    Posts
    132
    product_component_version does not tell you all the patches that have been installed.

    I have installed a patch 8.1.7.1.5 but this only displays the first patch - 8.1.7.1.
    I'm afraid Oracle does not always update the version numbers.

  5. #15
    Join Date
    Mar 2002
    Posts
    301
    Hi,

    From Sanjay's mail:
    "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."

    Oracle does not give any error. This is a method which you will use for Oracle9i migration.

    Vijay.
    Say No To Plastics

  6. #16
    Join Date
    Mar 2001
    Posts
    314
    Originally posted by DBA_Lisa
    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?
    If you are on unix:

    $ strings system01.dbf | grep "NLS_RDBMS_VERSION"

    NLS_RDBMS_VERSION 8.1.7.2.0 RDBMS version for NLS parameters,

    $

    Put the correct name of your system tablespace data file in place of "system01.dbf".

    I am sure in NT also you can check for the same string "NLS_RDBMS_VERSION" using an utility (no idea what though!).

    -amar


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