Install, Upgrade, Clone, Patch - EBS (MOSC)

MOSC Banner

ADFIXUSER.sql issue deadlock detected while waiting for resource "SYS.AD_ZD_SYS", line 638

edited Aug 6, 2020 5:00PM in Install, Upgrade, Clone, Patch - EBS (MOSC) 2 commentsAnswered

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

Tagged:

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center