My Oracle Support Banner

EM13.4:Save ECM Configuration failed With error ORA-00001: Unique Constraint (SYSMAN.MGMT_HA_RMAN_CONFIG_E) violated (Doc ID 2745020.1)

Last updated on FEBRUARY 01, 2021

Applies to:

Enterprise Manager for Oracle Database - Version 13.4.1.0.0 and later
Information in this document applies to any platform.

Symptoms

Save database target configuration from navigation path : Oracle database > Configuration > Save > Provide Name > Submit Job

OR

Creating a saved configuration job for database target using below emcli command :

emcli save_latest_config -name="<JOB_NAME>" -target_type="oracle_database" -target_name="<DB_NAME>"


Successfully saved latest configuration of the given target

But the saved configuration snapshot does not appear and the Job details show:


ERROR
-----------------------
ORA-00001: unique constraint (SYSMAN.MGMT_HA_RMAN_CONFIG_ECM_PK) violated
 
Could not execute pl/sql: [ORA-20846: An unexpected error was encountered while saving configuration snapshot data.
ORA-06512: at "SYSMAN.ECM_CT", line 6466
ORA-00001: unique constraint (SYSMAN.MGMT_HA_RMAN_CONFIG_ECM_PK) violated
ORA-06512: at "SYSMAN.ECM_CT", line 6099
ORA-06512: at line 1
ORA-06512: at "SYSMAN.ECM_CT", line 5936
ORA-06512: at "SYSMAN.ECM_CT", line 6052
ORA-06512: at "SYSMAN.ECM_CT", line 6152
ORA-06512: at "SYSMAN.ECM_CT", line 6438
ORA-06512: at line 1
(java.sql.SQLException)]

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.