Dead Locks occured while applying patch# 21314548
sqlplus -s APPS/***** @/u02/app/oracle/PROD/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
The error is a lock on object.
1. stop you patch application
2. Stop and start your database
3. re-apply the patch .
2 comments:
It works for me :)
Whilw applying ebs security patch Jan2016, I was facing this issue
ADFIXUSER.sql failed with adworker
Workaround:
Bounce the database
execute adgrants.sql
re-applied patch successfully
Thanks & Regards,
Himanshu Nayak
@Himanshu Nayak thnx a lot bro
Post a Comment