DBAsupport.com Forums - Powered by vBulletin
Results 1 to 2 of 2
  1. #1
    Join Date
    Mar 2008

    Find incomplete patching by running sql query.


    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
    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

We have made updates to our Privacy Policy to reflect the implementation of the General Data Protection Regulation.