Tuesday, 23 February 2016

ORA-00060: deadlock detected while waiting for RESOURCE DB PREP during Online Patching Enablement script (Database Preparation script) execution.

Error details:

ORA-00060: deadlock detected while waiting for RESOURCE DB PREP
begin APPS.ad_zd_mviews.upgrade('APPS','<Materialized View>'); end;

Related Bug:12901059  in R12.2

Workaround:
Re-run the script manually, outside the Online Patching.

SQL>begin APPS.ad_zd_mviews.upgrade('APPS','<Failed Materialized View>'); end;

(Ref: Doc ID 2050998.1)

No comments:

Post a Comment