checking patches
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 5 of 5

Thread: checking patches

  1. #1
    Join Date
    Mar 2004
    Location
    DC,USA
    Posts
    650

    Cool checking patches

    Can we check which patches have been applied to the database successfully?

    1) at the db level
    2) at the o/s level

    Have a good day!
    "What is past is PROLOGUE"

  2. #2
    Join Date
    Apr 2004
    Location
    Riyadh
    Posts
    12

    Checking Patches Applied at O/sLevel

    Dear,

    If ur operating system is one of the unix flavours then u can go for he below command to find out the patches applied to the opertaing system:

    > /usr/sbin/swlist -l patch
    Md. Shiraz Mustafa
    Oracle Consultant

  3. #3
    Join Date
    Jun 2001
    Location
    Helsinki. Finland
    Posts
    3,938

    Re: checking patches

    For patchsets, check:

    select * from v$version;

    For one time patches, it is not that simple.
    Oracle Certified Master
    Oracle Certified Professional 6i,8i,9i,10g,11g
    email: ocp_9i@yahoo.com

  4. #4
    Join Date
    Mar 2004
    Location
    DC,USA
    Posts
    650
    At the os level should i need to install the swlist as it is not listed in my /usr/sbin dir (solaris 5.6).

    At the db level apart from the v$version is there any FND_ tables to check?
    "What is past is PROLOGUE"

  5. #5
    Join Date
    Nov 2000
    Location
    greenwich.ct.us
    Posts
    9,092
    Oracle has a tool called patchset_tool that looks at the version of all the modules you have installed.
    Jeff Hunter
    marist89@yahoo.com
    http://marist89.blogspot.com/
    Get Firefox!
    "I pledge to stop eating sharks fin soup and will not do so under any circumstances."

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