Monday 4 June 2012

AutoPatch error:ATTENTION: All workers either have failed or are waiting:FAILED: file xxxx on worker x.

AutoPatch error:ATTENTION: All workers either have failed or are waiting:FAILED: file xxxx on worker x.



Here what you are going to do if you face the below error while applying patches using adpatch

ATTENTION: All workers either have failed or are waiting:
FAILED: file xxxx on worker x.
ATTENTION: Please fix the above failed worker(s) so the manager can continue


Check the worker ID log file ( adworkerxx.log ) from $APPL_TOP/admin/$SID/log , the exact issue should be mentioned in it, take an action and resolve the issue then do the following to proceed with the adpatch:


Run adctrl
Choose option 1 "Show Worker Status" which should show the status failed.
Then choose option "2. Tell worker to restart a failed job". Enter the number of worker which you want to restart.
The status will change to "fixed,restart" and the patch will progress.

My issue was like:

Issue:

ERROR at line 1:
ORA-24001: cannot create QUEUE_TABLE, APPLSYS.WF_SMTP_O_1_TABLE already exists
ORA-06512: at "APPS.WF_QUEUE", line 2665
ORA-06512: at line 22

Solution:
exec dbms_aqadm.drop_queue_table(queue_table => 'APPLSYS.WF_SMTP_O_1_TABLE', force => TRUE); 


Then restart the failed worker.



1 comment:

Number of Visitors