R12.2 Apps DBA. Powered by Blogger.

ORA-00060: deadlock detected while waiting for resource

No comments :
sqlplus -s APPS/***** @/apps/M1PROD/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
Solution:
1. Edit the adgrants.sql and remove the apostrophe after DataPump on line 488 and save.

2. Re-test running adgrants.sql after the update.

No comments :

Post a Comment

Note: only a member of this blog may post a comment.