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.