ORA-00060: deadlock detected while applying R12 Upgrade driver patch
Hi,
We are upgrading Oracle EBS 11i to R12 version and while running major upgrade driver we have received "ORA-00060: deadlock detected" error in ADPATCH and worked got failed and stuck for couple of hours.
The log file is showing :
----------------
ackage /u01/oracle/apps/apps_st/appl/hxt/12.0.0/patch/115/sql/hxtotcri.pkh
AD Worker error:
ORA-00060: deadlock detected while waiting for resource
Failed to execute statement. Statement is
CREATE OR REPLACE PACKAGE hxt_otc_retrieval_interface AS
/* $Header: h ...
AD Worker error:
ORA-00060: deadlock detected while waiting for resource
-----------------
What are the steps to be done to fix this kind of deadlock errors.
We are upgrading Oracle EBS 11i to R12 version and while running major upgrade driver we have received "ORA-00060: deadlock detected" error in ADPATCH and worked got failed and stuck for couple of hours.
The log file is showing :
----------------
ackage /u01/oracle/apps/apps_st/appl/hxt/12.0.0/patch/115/sql/hxtotcri.pkh
AD Worker error:
ORA-00060: deadlock detected while waiting for resource
Failed to execute statement. Statement is
CREATE OR REPLACE PACKAGE hxt_otc_retrieval_interface AS
/* $Header: h ...
AD Worker error:
ORA-00060: deadlock detected while waiting for resource
-----------------
What are the steps to be done to fix this kind of deadlock errors.
Tagged:
0