Oracle Patch list
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 5 of 5

Thread: Oracle Patch list

  1. #1
    Join Date
    Jan 2007
    Location
    Georgia
    Posts
    9

    Oracle Patch list

    How to determine patch level of Oracle version ? Need to determine which patches have been applied and list of patches needed to apply.

    can anyone help ?

    ie. we are currently on 8.1.7.4 ... plans to upgrade soon, but need information for management on current version.

  2. #2
    Join Date
    Sep 2002
    Location
    England
    Posts
    7,333
    patch sets or patches (because there is a difference)

  3. #3
    Join Date
    Jan 2007
    Location
    Georgia
    Posts
    9

    Oracle Patch list

    patch sets

    Thanks

    I took over a database and need to find what level it is at ...

  4. #4
    Join Date
    Sep 2002
    Location
    England
    Posts
    7,333
    well you know the patchset (8.1.7.4) you can find this from the database or from sqlplus when you log in.

    If you need patches they may be harder, if they wer einstalled using opatch then you can do opatch lsinventory and it will display the patches installed.

    if they were hand installed they you wont be able to find out

  5. #5
    Join Date
    Jan 2001
    Posts
    3,131
    Login as SYS.

    select * from registry$history where action='CPU';
    I remember when this place was cool.

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