EM 13c Cannot Remove A Target From A Compliance Standard
(Doc ID 2572513.1)
Last updated on MARCH 04, 2024
Applies to:
Enterprise Manager Base Platform - Version 13.2.0.0.0 and laterInformation 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
--------------------------
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 |