EM 12c: INSERT Statement Failing With ORA-00001 by SYSMAN User on the Enterprise Manager 12c Cloud Control Repository (Doc ID 2131995.1)

Last updated on JUNE 10, 2016

Applies to:

Oracle Database - Enterprise Edition - Version 11.2.0.4 and later
Enterprise Manager Base Platform - Version 12.1.0.4.0 to 13.1.0.0.0 [Release 12.1 to 13.1]
Information in this document applies to any platform.

Symptoms

With Auditing enabled on the Enterprise Manager (EM) 12c Cloud Control Repository, there are many INSERT statements against the MGMT views that are failing with ORA-00001 by SYSMAN user:

MGMT_HA_MTTR
MGMT_DB_HDM_METRIC_HELPER
EM_METRIC_VALUES
EM_METRIC_ITEMS
MGMT_DB_FEATUREUSAGE
MGMT_JOB_QUEUES
MGMT_CLUSTERWARE_EVENTS

 

This causes the AUD$ table to quickly fill with millions of rows generated.

 

Changes

Auditing for failed transactions has been enabled on the repository.

 

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