Patch 2669606 11.5.9 Maintenance Pack Deadlock Errors during install
While applying patch 2669606 on the admin tier, all workers (8) fail with errors due to deadlocks. The first process that fails is :
HIDEPW: sqlplus -s APPS/APPS @/fintest/appl/admin/fintest/out/p05invok.sql
sqlplus -s APPS/***** @/fintest/appl/admin/fintest/out/p05invok.sql
CREATE or REPLACE PACKAGE WSH_DETAILS_VALIDATIONS AUTHID CURRENT_USER as
*
ERROR at line 1:
ORA-04020: deadlock detected while trying to lock object
APPS.WSH_DELIVERY_AUTOCREATE
Subsequent failures occur when uploading one of these three objects: FLOOD-DATABASE, AS_PERSON, WSH_DELIVERY_DETAILS_GRP. About 90% of the failures occur when uploading the object FLOOD-DATABASE. Here is the second error -