My Oracle Support Banner

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 AUGUST 04, 2018

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

To view full details, 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 a vibrant support community of peers and Oracle experts.