How to check the complete version of Oracle
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 7 of 7

Thread: How to check the complete version of Oracle

  1. #1
    Join Date
    Dec 2001
    Location
    USA
    Posts
    620
    Hi all,

    I want to check the whole version of our Oracle. When I connect to sqlplus, it shows just 8.0.6.0.0.

    I want to know the complete ver. like 8.0.6.1.3 or something.

    How to do that?

    Thanks in Adv.
    Sam
    ------------------------
    To handle yourself, use your head. To handle others, use your heart

  2. #2
    Join Date
    Oct 2000
    Location
    Saskatoon, SK, Canada
    Posts
    3,925
    Code:
         sqlplus user_with_dba_priv
         
           SELECT version 
             FROM v$instance;
    Sam
    Thanx
    Sam



    Life is a journey, not a destination!


  3. #3
    Join Date
    Sep 2001
    Posts
    163
    What you see from sqlplus is what you get. The complete version display depends on Oracle and where they choose to have the patches update the version information. I ran into the same issue when I applied patches 1 and 2 to our 8.1.7.0.0 install. After the first patch it showed 8.1.7.2.1 but after the second patch it still showed only 8.1.7.2.1, not 8.1.7.2.5 like it should have. The readme.txt sent with the patch will tell you if it will change the version numbers.

    Personally, I think it stinks. If I apply a patch, I should see it in the version numbers. How else are you going to know what patch you applied.


  4. #4
    Join Date
    Dec 2001
    Location
    USA
    Posts
    620
    Hi Sam,
    SELECT version
    FROM v$instance;

    shows me Oracle8i Enterprise Edition Release 8.1.7.3.0 - Production.

    Actually, we have server partition with Oracle Apps 11i. We have two Homes 8i and 806. I know 8i ver. it is 81730.

    I want to check similarly for 806 home.

    With sqlplus, it shows 8.0.6.0.0.

    I still can't check that.

    Any help?

    Thanks,

    Sam
    ------------------------
    To handle yourself, use your head. To handle others, use your heart

  5. #5
    Join Date
    Oct 2000
    Location
    Saskatoon, SK, Canada
    Posts
    3,925
    Looks like that is the 8.0.6 base and there had not been any patches applied to it.

    Sam
    Thanx
    Sam



    Life is a journey, not a destination!


  6. #6
    Join Date
    Sep 2001
    Location
    NJ, USA
    Posts
    1,287
    Try to check:

    ../oraInventory/Components/oracle.rdbms/*
    It should to show oracle version and all pathes for rdbms.

  7. #7
    Join Date
    Oct 2000
    Location
    Saskatoon, SK, Canada
    Posts
    3,925
    Did oracle inventory play any role in 8.0 version? oraInventory was in use as of 8i I presume. One other place to look for the database version would be the alert_log

    I might be wrong!

    Sam
    Thanx
    Sam



    Life is a journey, not a destination!


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