My Oracle Support Banner

EM 13c: Saving a "Monitoring Configuration" in the Console Fails With Error "ORA-01422: Exact Fetch Returns More than Requested Number of Rows" (Doc ID 2655591.1)

Last updated on NOVEMBER 16, 2022

Applies to:

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

Symptoms

When updating the configuration information of the database target from the menu below, ORA-01422 error occurs and the update fails.


Login to OEM Console -> Navigate to the Database target -> Configuration -> Monitoring Configuration -> Configure Database Instance:Review


 "ORA-01422: Exact Fetch Returns More than Requested Number of Rows"

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


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