My Oracle Support Banner

EM 13c Cannot Remove A Target From A Compliance Standard (Doc ID 2572513.1)

Last updated on JANUARY 14, 2020

Applies to:

Enterprise Manager Base Platform - Version 13.2.0.0.0 and later
Information in this document applies to any platform.

Symptoms

When try to remove a target from compliance standard gets a popup error in the OEM Console as below. 


The database generating high volume of archive log files. There is always one session active in the database causing massive block changes. The sql-statements in that session are all related to 'compliance-objects', continuously setting end updating locks at a very high rate. 

Error message from the UI:
--------------------------
Error occurred while either the Associate Target operation or the Remove Association operation was still in progress. This error occurs when there is a backlog in batch processing. Retry the operation.


Error message from emoms.trc
----------------------------
2019-07-16 10:38:51,542 [[ACTIVE] ExecuteThread: '18' for queue: 'weblogic.kernel.Default (self-tuning)'] WARN  sysman.ComplianceAssocAMImpl logp.251 - SQL Exception
java.sql.SQLException: ORA-20759: Cannot acquire lock
ORA-06512: at "SYSMAN.EM_COMPLIANCE_LOCK", line 111
ORA-06512: at "SYSMAN.EM_COMPLIANCE_LOCK", line 846
ORA-06512: at line 1

       at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:466)
       at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:407)
       at oracle.jdbc.driver.T4C8Oall.processError(T4C8Oall.java:1113)
       at oracle.jdbc.driver.T4CTTIfun.receive(T4CTTIfun.java:546)


SQL-ID collection.txt
==================
SQL Details: aqqcws9j41722
BEGIN :1 := EM_COMPLIANCE_UTIL.xlock(:2 ,:3 ) ; END;


SQL Details: ajwc0fngn90aa
BEGIN :1 := EM_COMPLIANCE_UTIL.xlock(:2 ,:3 ,:4 ) ; END;


SQL Details: ak5crjygnpk60
UPDATE DBMS_LOCK_ALLOCATED SET EXPIRATION = SYSDATE + (:B1 /86400) WHERE ROWID = :B2

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


My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.