Last updated on JUNE 24, 2017
Applies to:Enterprise Manager Base Platform - Version 188.8.131.52.0 and later
Information in this document applies to any platform.
Repository database alert log has the following deadlock messages:
ORA-00060: Deadlock detected.
More info in file /orapool/oracle/diag/rdbms/emrep/emrep/trace/emrep_ora_18180.trc.
From the trace file we can see the deadlock on
SELECT CURRENT_STATUS,TARGET_GUID FROM EM_CURRENT_AVAILABILITY WHERE TARGET_GUID IN (SELECT TARGET_GUID FROM MGMT_TARGETS WHERE EMD_URL = :B4 AND (DYNAMIC_PROPERTY_STATUS = :B3 OR TARGET_TYPE IN (:B2 , :B1 ))) ORDER BY TARGET_GUID FOR UPDATE
Sign In with your My Oracle Support account
Don't have a My Oracle Support account? Click to get started
My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms