My Oracle Support Banner

EM 13c : Updating Monitoring Configuration To Changing Database Monitoring Credentials Via GUI Fails With ORA-1422 (Doc ID 2636185.1)

Last updated on MARCH 21, 2020

Applies to:

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

Symptoms

Updating Monitoring Configuration to changing database monitoring credentials via GUI fails with ORA-1422

Database Menu -> Setup -> Monitoring Configuration -> Submit -> Error
Monitoring Configuration Saving - Failed
Changes Not Saved:
<TARGET_NAME> : ORA-1422: exact fetch returns more than requested number of

emoms.trc
--------------
<DATE> [[ACTIVE] ExecuteThread: '15' for queue: 'weblogic.kernel.Default (self-tuning)'] ERROR mntrconfig.DbMntrConfigTrainBean logp.251 - Database Monitoring Config, exception caught while saving changes
java.lang.Exception: <TARGET_NAME> : ORA-01422: exact fetch returns more than requested number of rows
ORA-06512: at "SYSMAN.EM_TARGET", line 7258
ORA-06512: at "SYSMAN.EM_TARGET", line 7673
ORA-06512: at line 1

Changes

 

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
Changes
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.