Find incomplete patching by running sql query.
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 2 of 2

Thread: Find incomplete patching by running sql query.

  1. #1
    Join Date
    Mar 2008
    Posts
    1

    Find incomplete patching by running sql query.

    Hi,

    I am applying a oracle 11i apps patch, while patching i want to find :

    1. Monitor the patching activities by running sql query.

    2. while patching the system goes down or reboot then how to find which patch is incomplete by running sql query.

    Thanks in advance.

    Ramesh J C

  2. #2
    Join Date
    Sep 2002
    Posts
    376
    I guess, You cannot monitor by sql query.,,

    But you can monitor the activity in the log file., may be u can say
    tail -f to get continouls updates.

    Also, to find out if the patch is complete or not, you have to rely on logfiles.
    You can find the patch completion message at the end of the file.

    Also, Next time when you restart the adpatch, It asks you if you want to continue the previous stopped patch....
    ------------------------------------------------------------------------
    The most enjoyable things in the world are either Immoral or too Expensive or otherwise Inaccessible anyway

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