Thursday, April 24, 2014

How to update patch adwork process manually


Hi All,

Here the way to update patch adwork process manually when the process is stuck during the patch apply:

1. Update the worker status :
UPDATE applsys.fnd_install_processes
SET status = 'F'   --- F = Failed
WHERE worker_id = 1 --- Number of stuck adworker process

2. Find the SID and the SERIAL# of stuck adworker process

select sid,serial#  from v$session where sid=xxx;

3. Kill the session
alter system kill session 'xxx,yyy';

Useful documentation:
Inadvertently Closing a Session of Adpatch Causes 'Unable to find job ' Error (Doc ID 257505.1)

Good Luck ....

5 comments:

  1. This comment has been removed by a blog administrator.

    ReplyDelete
  2. Thanks For Posting Valuable Information..And keep posting Upon the tutorials of Selenium

    ReplyDelete
  3. Need To Increase Your ClickBank Banner Traffic And Commissions?

    Bannerizer made it easy for you to promote ClickBank products with banners, simply go to Bannerizer, and grab the banner codes for your favorite ClickBank products or use the Universal ClickBank Banner Rotator Tool to promote all of the available ClickBank products.

    ReplyDelete