Dead Locks occured while applying Jan CPU EBS Application Patch #19873049
Hi Team,
Dead Locks occured while applying Jan CPU EBS Application Patch#19873049.
Error in Worker Logfile.
sqlplus -s APPS/***** @/dev_oraapp/cmpdev/apps/apps_st/appl/ad/12.0.0/patch/115/sql/ADFIXUSER.sql
Connected.
begin
*
ERROR at line 1:
ORA-00060: deadlock detected while waiting for resource
ORA-06512: at "SYS.AD_ZD_SYS", line 39
ORA-06512: at line 2
We have fallowend 3 times for the Error Applying CPU JAN 2015 Patch 19873049 while Executing ADFIXUSER.sql PLS-00201: identifier 'SYS.AD_ZD_SYS' must be declared (Doc ID 1965199.1) Note but no luck.
the version of adgrants.sql is as follows ,
[oratst@DBDVIR03 admin]$ strings -a adgrants.sql|grep Header