ADFIXUSER.sql issue deadlock detected while waiting for resource "SYS.AD_ZD_SYS", line 638
I get this warning when I apply some patches using adop in 12.2.8 , my patches do run to completion successfully .
I run what they suggest but the first script (ADFIXUSER.sql breaks with a deadlock error.
[WARNING] SYS.DUAL table has incorrect privileges
Shut down the application tier services and then run the following commands in the order shown
sqlplus apps/<APPS_Password> @ $AD_TOP/patch/115/sql/ADFIXUSER.sql
sqlplus apps/<APPS_Password> @ $AD_TOP/sql/adutlrcmp.sql
SQL> @$AD_TOP/patch/115/sql/ADFIXUSER.sql
begin
*
ERROR at line 1:
ORA-00060: deadlock detected while waiting for resource
ORA-06512: at "SYS.AD_ZD_SYS", line 638