EM 12c: ORA-60 Deadlocks on SELECT CURRENT_STATUS,TARGET_GUID FROM EM_CURRENT_AVAILABILITY in Enterprise Manager 12c Cloud Control Repository Database Alert Log
(Doc ID 2063089.1)
Last updated on JANUARY 17, 2023
Applies to:
Enterprise Manager Base Platform - Version 12.1.0.4.0 to 12.1.0.5.0 [Release 12.1]Information in this document applies to any platform.
Symptoms
Repository database alert log has the following deadlock messages:
Example:
ORA-00060: Deadlock detected.
More info in file <diagnostic_dest>/diag/rdbms/emrep/emrep/trace/emrep_ora_18180.trc.
From the trace file we can see the deadlock on
current SQL:
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
Cause
To view full details, sign in with your My Oracle Support account. |
|
Don't have a My Oracle Support account? Click to get started! |
In this Document
| Symptoms |
| Cause |
| Solution |
| References |