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

Thread: Patch level

  1. #1
    Join Date
    May 2002
    Posts
    2
    Dear .....

    We are using oracle application 11i (11.5.5) and database 8.1.7 how to find out the patch level.

    The patches already has been applied on database as well as application level.

    is there any way to find out the patch level.Please let me know.


    Thanks in advance ....

    Regards
    Sanjay

  2. #2
    Join Date
    Dec 2001
    Posts
    26
    Please refer to the doc "Oracle Applications Current Patchsets Comparison Utility" in MetaLink

  3. #3
    Join Date
    Apr 2004
    Location
    Atlanta, Georgia USA
    Posts
    1
    You can look at the v$version view inside the database.

  4. #4
    Join Date
    Apr 2004
    Posts
    2

    Patchset level on 11i

    Run the following query on your 11i instance:

    select patch_level, application_name
    from fnd_product_installations fpi
    , fnd_application_tl fat
    where patch_level is not null
    and fpi.application_id = fat.application_id
    order by application_name;

    You can spool it to text and save it for multiple instances......

    Hope this helps.

  5. #5
    Join Date
    Jan 2006
    Posts
    1
    it is may be useable for you also:
    http://www.dba-village.com/village/d...A=0&SortA=Date

  6. #6
    Join Date
    Jul 2002
    Location
    Northampton, England
    Posts
    612
    Excellent stuff, a reply to a 1.5 year old post. That a late Christmas present is it?
    Assistance is Futile...

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