How to restart and skip the job from adctrl

Many times , we need to either restart the failed worker in adpatch or skip the job .This is performed through the AD utility adctrl .I will demonstrate this below

Start adctrl

It will prompt for apps username and password and will display below menu

press [Return] to go back to the menu :

AD Controller Menu
—————————————————

1. Show worker status

2. Tell worker to restart a failed job

3. Tell worker to quit

4. Tell manager that a worker failed its job

5. Tell manager that a worker acknowledges quit

6. Restart a worker on the current machine

7. Exit

Enter your choice [1] :

 

To display the status of the Job, Press 1
Enter your choice [1] : 1
Control
Worker Code Context Filename Status
—— ——– —————– ————————– ————–
1 Run AutoPatch R120 apcardwu21.sql FAILED
2 Run AutoPatch R120 apcardwu21.sql FAILED
3 Run AutoPatch R120 apcardwu21.sql FAILED
4 Run AutoPatch R120 apcardwu21.sql FAILED
5 Run AutoPatch R120 Wait
6 Run AutoPatch R120 apcardwu21.sql FAILED
7 Run AutoPatch R120 apcardwu21.sql FAILED
8 Run AutoPatch R120 apcardwu21.sql FAILED
9 Run AutoPatch R120 Wait
10 Run AutoPatch R120 apcardwu21.sql FAILED
11 Run AutoPatch R120 apcardwu21.sql FAILED
12 Run AutoPatch R120 apcardwu21.sql FAILED
13 Run AutoPatch R120 apcardwu21.sql FAILED
14 Run AutoPatch R120 apcardwu21.sql FAILED
15 Run AutoPatch R120 apcardwu21.sql FAILED
16 Run AutoPatch R120 apcardwu21.sql FAILED
17 Run AutoPatch R120 apcardwu21.sql FAILED
18 Run AutoPatch R120 apcardwu21.sql FAILED
19 Run AutoPatch R120 apcardwu21.sql FAILED
20 Run AutoPatch R120 Wait

Review the messages above, then press [Return] to continue.

AD Controller Menu
—————————————————

1. Show worker status

2. Tell worker to restart a failed job

3. Tell worker to quit

4. Tell manager that a worker failed its job

5. Tell manager that a worker acknowledges quit

6. Restart a worker on the current machine

7. Exit

 

To restart the failed worker, press 2

Enter your choice [1] : 2

Enter the worker number(s)/range(s) or ‘all’ for all workers,
or press [Return] to go back to the menu : 1,2,3,4,6,7,8,10,11,12,13,14,15,16,17,18,19
Status changed to ‘Fixed, restart’ for worker 1.
Status changed to ‘Fixed, restart’ for worker 2.
Status changed to ‘Fixed, restart’ for worker 3.
Status changed to ‘Fixed, restart’ for worker 4.
Status changed to ‘Fixed, restart’ for worker 6.
Status changed to ‘Fixed, restart’ for worker 7.
Status changed to ‘Fixed, restart’ for worker 8.
Status changed to ‘Fixed, restart’ for worker 10.
Status changed to ‘Fixed, restart’ for worker 11.
Status changed to ‘Fixed, restart’ for worker 12.
Status changed to ‘Fixed, restart’ for worker 13.
Status changed to ‘Fixed, restart’ for worker 14.
Status changed to ‘Fixed, restart’ for worker 15.
Status changed to ‘Fixed, restart’ for worker 16.
Status changed to ‘Fixed, restart’ for worker 17.
Status changed to ‘Fixed, restart’ for worker 18.
Status changed to ‘Fixed, restart’ for worker 19.
Review the messages above, then press [Return] to continue.
AD Controller Menu
—————————————————

1. Show worker status

2. Tell worker to restart a failed job

3. Tell worker to quit

4. Tell manager that a worker failed its job

5. Tell manager that a worker acknowledges quit

6. Restart a worker on the current machine

7. Exit

Enter your choice [1] : 1
Control
Worker Code Context Filename Status
—— ——– —————– ————————– ————–
1 Run AutoPatch R120 Wait
2 Run AutoPatch R120 Wait
3 Run AutoPatch R120 Wait
4 Run AutoPatch R120 Wait
5 Run AutoPatch R120 Wait
6 Run AutoPatch R120 Wait
7 Run AutoPatch R120 Wait
8 Run AutoPatch R120 Wait
9 Run AutoPatch R120 Wait
10 Run AutoPatch R120 Wait
11 Run AutoPatch R120 Wait
12 Run AutoPatch R120 Wait
13 Run AutoPatch R120 Wait
14 Run AutoPatch R120 Wait
15 Run AutoPatch R120 Wait
16 Run AutoPatch R120 Wait
17 Run AutoPatch R120 Wait
18 Run AutoPatch R120 apcardwu21.sql Failed
19 Run AutoPatch R120 Wait
20 Run AutoPatch R120 Wait

Review the messages above, then press [Return] to continue.

Review the messages above, then press [Return] to continue.

AD Controller Menu
—————————————————

1. Show worker status

2. Tell worker to restart a failed job

3. Tell worker to quit

4. Tell manager that a worker failed its job

5. Tell manager that a worker acknowledges quit

6. Restart a worker on the current machine

7. Exit

Enter your choice [1] : 1

To skip the job, enter the hidden option 8

Enter the worker number(s)/range(s) or ‘all’ for all workers,
or press [Return] to go back to the menu : 8

Status changed to ‘skipped, restart’ for worker 8.

 

If you run adctrl when no adpatch  is running , You will below error

Enter your choice [1] :

Error: The FND_INSTALL_PROCESSES table does not exist.
This table is used for communication with the
worker processes, and if it does not exist, it
means that the workers are not running,because
the ad utility has not started them yet.

You should check the file
adctrl.log

for errors.

Related articles on Apps Patching 

Autopatch PART I

Autopatch PART II

Autopatch/adpatch PART III(fnd_install_processes )

Autopatch(Driver files) PART -4

40 Adpatch question every DBA should know