If you are restarting a failed patch session in oracle applications, sometimes you may encounter the error
AutoPatch error:
The worker should not have status 'Running' or 'Restarted' at this point.
Telling workers to quit...
All workers have quit.
Connecting to APPS......Connected successfully.
AutoPatch error:
Error running SQL and EXEC commands in parallel
Cause:
1. adpatch or adop process was killed from OS level while patch is being applied
2. Database shutdown or terminated
Solution:
Using adctrl utility, use option 4 to change the worker status to Failed
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] : 4
Enter the worker number(s)/range(s) or 'all' for all workers,
or press [Return] to go back to the menu : all
Status changed to 'Failed' for worker 1.
Status changed to 'Failed' for worker 2.
Status changed to 'Failed' for worker 3.
Status changed to 'Failed' for worker 4.
Review the messages above, then press [Return] to continue.
select option "1. Show Worker Status" , The worker status will be "Failed"
Now select option 2. "2. Tell worker to restart a failed job"
Enter the worker number(s)/range(s) or 'all' for all workers,
or press [Return] to go back to the menu : all
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.
Restart adpatch
In 11i, R12.1.X version of oracle applications
when applying patch using adpatch , Select option Yes When it prompts for
'Do you wish to Continue with Previous adpatch Session'
In R12.2.x, Use restart and abandon parameters
adop phase=apply patches=123456 restart=yes abandon=no
To restart the patch session from where it failed.
AutoPatch error:
The worker should not have status 'Running' or 'Restarted' at this point.
Telling workers to quit...
All workers have quit.
Connecting to APPS......Connected successfully.
AutoPatch error:
Error running SQL and EXEC commands in parallel
Cause:
1. adpatch or adop process was killed from OS level while patch is being applied
2. Database shutdown or terminated
Solution:
Using adctrl utility, use option 4 to change the worker status to Failed
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] : 4
Enter the worker number(s)/range(s) or 'all' for all workers,
or press [Return] to go back to the menu : all
Status changed to 'Failed' for worker 1.
Status changed to 'Failed' for worker 2.
Status changed to 'Failed' for worker 3.
Status changed to 'Failed' for worker 4.
Review the messages above, then press [Return] to continue.
select option "1. Show Worker Status" , The worker status will be "Failed"
Now select option 2. "2. Tell worker to restart a failed job"
Enter the worker number(s)/range(s) or 'all' for all workers,
or press [Return] to go back to the menu : all
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.
Restart adpatch
In 11i, R12.1.X version of oracle applications
when applying patch using adpatch , Select option Yes When it prompts for
'Do you wish to Continue with Previous adpatch Session'
In R12.2.x, Use restart and abandon parameters
adop phase=apply patches=123456 restart=yes abandon=no
To restart the patch session from where it failed.
Really helped in a great way , struggled almost 2 hours to resolve.
ReplyDeleteThanks for the blog
wow this saintly however ,I love your enter plus nice pics might be part personss negative love being defrent mind total poeple , pop over to this web-site
ReplyDeleteNow, everyone is interested in having a high profile career and their career development.Career
ReplyDelete