EM 12c: Enterprise Manager 12c Cloud Control Repository Database Deadlocks Reported on SELECT T.ENTITY_GUID TARGET_GUID, T.EMD_URL EMD_URL, T.ENTITY_NAME TARGET_NAME (Doc ID 2167225.1)

Last updated on APRIL 25, 2017

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

The Enterprise Manager (EM) 12.1.0.4 Cloud Control repository database alert log reports deadlocks, which are affecting EM 12c OMS functionality:

ORA-00060: Deadlock detected. More info in file /orahome/Database/diag/rdbms/emrepcta/EMREPCTA/trace/EMREPCTA_ora_31716.trc.
Wed Jun 15 04:00:54 2016
ORA-00060: Deadlock detected. More info in file /orahome/Database/diag/rdbms/emrepcta/EMREPCTA/trace/EMREPCTA_ora_31714.trc.
Wed Jun 15 04:00:59 2016
ORA-00060: Deadlock detected. More info in file /orahome/Database/diag/rdbms/emrepcta/EMREPCTA/trace/EMREPCTA_ora_32728.trc.
Wed Jun 15 04:01:03 2016
ORA-00060: Deadlock detected. More info in file /orahome/Database/diag/rdbms/emrepcta/EMREPCTA/trace/EMREPCTA_ora_32734.trc.
Wed Jun 15 04:01:07 2016
ORA-00060: Deadlock detected. More info in file /orahome/Database/diag/rdbms/emrepcta/EMREPCTA/trace/EMREPCTA_ora_32732.trc.
Wed Jun 15 04:47:29 2016
Thread 1 advanced to log sequence 6412 (LGWR switch)
Current log# 7 seq# 6412 mem# 0: /orahome/Database/oradata/EMREPCTA/redo07.log

 

This is the responsible sql query (related to EM 12c repository maintenance):

current SQL:
SELECT T.ENTITY_GUID TARGET_GUID, T.EMD_URL EMD_URL, T.ENTITY_NAME TARGET_NAME, T.ENTITY_TYPE TARGET_TYPE, T.MONITORING_MODE MONITORING_MODE FROM EM_MANAGEABLE_ENTITIES T WHERE T.ENTITY_GUID IN (SELECT TARGET_GUID FROM MGMT_TARGET_AGENT_ASSOC A WHERE A.AGENT_GUID = :B3 AND A.PROMOTE_STATUS >= :B2 ) AND T.MANAGE_STATUS = :B1 ORDER BY ENTITY_TYPE, ENTITY_NAME FOR UPDATE OF T.MANAGE_STATUS

 

Changes

 

Cause

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