This issue has occurred when we do applying the patches on the Apps_Tier.
The cause of this is auto patch previous sessions are still exists in the server and failing the ad workers
with the following error.
Error
11 workers have quit. Waiting for 9 more.
12 workers have quit. Waiting for 8 more.
All workers have quit.
Completed: file apgtxlat.sql on worker 1 for product ap username AP.
Error running SQL and EXEC commands in parallel
You should check the file
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:
Kill the ad patch sessions and try to apply the patch again.
1. [applmgr@oracle log]$ ps -eaf | grep adpatch
appluat 14552 14525 0 08:15 pts/4 00:00:00 grep adpatch
OR
[applmgr@oracle log]$ ps -efa | grep adworker
2.[applmgr@oracle log]$ Mydb>kill -9 <pid>
No comments:
Post a Comment