ORA-01422 In OEM Repository Database
(Doc ID 2698310.1)
Last updated on AUGUST 23, 2020
Applies to:Oracle Database - Enterprise Edition - Version 18.104.22.168.0 and later
Information in this document applies to any platform.
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
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