My Oracle Support Banner

ORA-01422 In OEM Repository Database (Doc ID 2698310.1)

Last updated on AUGUST 23, 2020

Applies to:

Oracle Database - Enterprise Edition - Version 19.6.0.0.0 and later
Information in this document applies to any platform.

Symptoms

Obserging ORA-1422 from OEM.

----- Error Stack Dump -----
<error barrier> at 0x7ffde7128a50 placed dbkda.c@296
ORA-01422: exact fetch returns more than requested number of rows
----- Current SQL Statement for this session (sql_id=f2qj21uc48413) -----
SELECT LTRIM(RETENTION,'+0') FROM DBA_HIST_WR_CONTROL INNER JOIN V$DATABASE USING (DBID)

When running select query on dba_hist_wr_control, it shows duplicate rows. 

As we can see, dba_hist_wr_control, has duplicate DBID 2033563455 which corresponds to CDB$ROOT



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.