ADCONTROLER in oracle APPS
ADCONTROLER in oracle APPS
You can review worker status, restart a failed worker, restart a terminated worker and shutdown a worker by using ADCTRL utility at the time of patching.
What should we do when a worker fails?
Step 1 first determine why a worker fails
Step 2 Resolve the error
Step 3 Restart fail worker by using adctrl utility
How to Determine why a worker fail?
Step 1 Execute ADCTRL Utility
Step 2 Review worker status and confirm the failed status of the worker and check name of the file that failed to run.
Step 3 Check worker log file (adworkxx.log) in $APPL_TOP/admin/log for error
Step 4 Resolve the error.
How to Restart a Failed worker?
Step 1 Execute ADCTRL Utility
Step 2 Tell the worker to restart a failed job. When prompted, enter the number of the worker that failed.
How to Restarting a Failed patch process?
If a worker fails and can not be restarted the do following steps:
Step 1 Execute ADCTRL Utility
Step 2 Choose options 4 (Tell the manager that a worker fails it’s job)
Step 3 Choose options 5 (Tell the manager that a worker ask no values)
Step 4 Exit AD utility
Step 5 Restart the Patch
How to terminating a Hanging worker process?
Step 1 Determine what the worker process is doing using ADCTRL utility.
Step 2 Get the Worker process ID.
#ps –a | grep adworker
Step 3 Kill the hanging Process
#kill –
Step 4 Fix the issue that cause the worker a hang
Step 5 Restart the Job / Worker
What are various stages of adpatch workers?
If no error: waithin>assigned>running>complete
If error: waiting>assigned>running>failed>fix>restart>complete
What is Default number of workers?
Number of CPU + 2
How many workers should I use?
Number of CPU + 2
What happens when we choose more then default?
It may be bog your database server down and cause the patch to run slower.
Responses