DBAsupport.com Forums - Powered by vBulletin
Results 1 to 6 of 6

Thread: Urgent - Oracle Patches

  1. #1
    Join Date
    Nov 2000
    Posts
    416
    How can I know what is the latest patches applied to our Oracle Server. I query v$version and I saw this :

    Oracle8 Enterprise Edition Release 8.0.5.0.0 - Production

    Does it mean there is no patches applied to this machine??

    An ounce of prevention is worth a pound of cure

  2. #2
    Join Date
    Mar 2002
    Location
    Mesa, Arizona
    Posts
    1,204
    This is a good question.

    A patch that replaces a library file or two then recompiles the oracle executable doesn't change the v$version number.

    I've tried running the executable ... for command line switches that return the current version... but that doesn't work...

    oracle -version
    oracle /version
    oracle -help
    oracle /help

    I'm stumped...
    "I do not fear computers. I fear the lack of them." Isaac Asimov
    Oracle Scirpts DBA's need

  3. #3
    Join Date
    Mar 2002
    Posts
    12

    Smile

    Hello, here's what I got on one of our server:

    SVRMGR> select * from v$version;
    BANNER
    ----------------------------------------------------------------
    Oracle8i Enterprise Edition Release 8.1.7.3.0 - Production
    PL/SQL Release 8.1.7.3.0 - Production
    CORE 8.1.7.0.0 Production
    TNS for DEC OSF/1 AXP: Version 8.1.7.3.0 - Production
    NLSRTL Version 3.4.1.0.0 - Production
    5 rows selected.

    I've just applied the 8.1.7.3 patch set and nothing else.

    Regards,
    Noel.

  4. #4
    Join Date
    Mar 2002
    Location
    Mesa, Arizona
    Posts
    1,204
    Noel, you're right. Sometimes the v$version information is updated. But certainly not always, I've got a number of examples of that.
    "I do not fear computers. I fear the lack of them." Isaac Asimov
    Oracle Scirpts DBA's need

  5. #5
    Join Date
    Nov 2000
    Posts
    416
    Then the question is if v$version for some reasons doesn't show the last patches, any other way ???
    An ounce of prevention is worth a pound of cure

  6. #6
    Join Date
    Mar 2002
    Location
    Mesa, Arizona
    Posts
    1,204
    Checked MetaLink and found the following:

    How to Determine Database Version After Applying Patch

    I have recently upgraded/patched my Windows 2000 8.1.7.0.0 installation to 8.1.7.1.1 and then to 8.1.7.1.5. When I query v$version I get:

    BANNER
    ----------------------------------------------------------
    Oracle8i Enterprise Edition Release 8.1.7.1.1 - Production
    PL/SQL Release 8.1.7.1.0 - Production
    CORE 8.1.7.0.0 Production
    TNS for 32-bit Windows: Version 8.1.7.1.0 - Production
    NLSRTL Version 3.4.1.0.0 - Production

    Also, when I run OUI, all I get is a listing for the 81711 patchset, not the 81715.

    The patch notes mention that "not all components will display the 81715 version number because of cumulative patch", but I can't find any that have this number.

    Is there anything I can do to confirm that a database has been patched to 8.1.7.1.5? The 81715 patch was simply a file copy - I suppose one could check the files in question and see if they match the date/time stamp and size of the ones included in the patch, but is there a better way?


    SUPPORT's REPLY:

    This is expected and do not know of any other way than the one you already mentioned. There was another customer with exact issue and versions which you refer by using the advanced search,
    Doc ID: 262585.999 Subject: Patch not reflected in database version
    "I do not fear computers. I fear the lack of them." Isaac Asimov
    Oracle Scirpts DBA's need

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