Error running SQL and EXEC commands in parallel

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:

SHRD0014: GLLEZL - process exiting with failure

  SYMPTOMS Journal Import completes with the following error: Error ------ ORA-01653 : unable to extend table GL.GL_IMPORT_REFERENCES ORA-01...