My Oracle Support Banner

EM12c, EM13c : Adding a new Rule to Compliance Standard results Duplicate error (Doc ID 2194100.1)

Last updated on MARCH 09, 2020

Applies to:

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


In Enterprise Manager (EM) Cloud Control system

Adding a new compliance standard rule to an existing compliance standard in Enterprise Manager Cloud Control fails with this error:

Duplicate Compliance Standard can not be created

From the EM OMS, the .../gc_inst/em/MEGC_OMS1/sysman/log/emoms.trc file (DEBUG enabled) shows the following stack:


[ACTIVE] ExecuteThread: '39' for queue:
'weblogic.kernel.Default (self-tuning)'] DEBUG util.ComplianceUtil logp.251 - EXCEPTION
java.sql.SQLException: ORA-20759: Can not acquire lock
ORA-06512: at "SYSMAN.EM_COMPLIANCE_LOCK", line 1750
ORA-06512: at line 1

at oracle.jdbc.driver.T4CTTIoer.processError(
at oracle.jdbc.driver.T4CTTIoer.processError(
at oracle.jdbc.driver.T4C8Oall.processError(
at oracle.jdbc.driver.T4CTTIfun.receive(


See the following reference for instructions on how to establish a DEBUG trace level on the emoms.trc log:

Enterprise Manager Cloud Control Administrator's Guide
12c Release 5
Chapter 23 Locating and Configuring Enterprise Manager Log Files
23.4 Locating and Configuring Oracle Management Service Log and Trace Files
23.4.4 Controlling the Contents of the Oracle Management Service Trace File


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

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