My Oracle Support Banner

Integrated Extract Fails During Startup With OGG-00662 OCI Error ORA-01422, OGG-02078. (Doc ID 2345909.1)

Last updated on SEPTEMBER 13, 2022

Applies to:

Oracle Database Cloud Schema Service - Version N/A and later
Gen 1 Exadata Cloud at Customer (Oracle Exadata Database Cloud Machine) - Version N/A and later
Oracle Cloud Infrastructure - Database Service - Version N/A and later
Oracle Database Exadata Express Cloud Service - Version N/A and later
Oracle Database Backup Service - Version N/A and later
Information in this document applies to any platform.

Symptoms

GoldenGate Integrated Extract will not start.

Report file shows:

Source Context :
SourceModule : [er.redo.oraxo]
SourceID : [<path_to>/redooraix.c]
SourceMethod : [handleReadError]
SourceLine : [15692]

2017-12-10 22:04:27 ERROR OGG-00662 OCI Error ORA-01422: exact fetch returns more than requested number of rows
(status = 1422).

Source Context :
SourceModule : [er.redo.ora.IXFormatter]
SourceID : [<path_to>/IXFormatter.cpp]
SourceMethod : [getResult]
SourceLine : [748]

2017-12-10 22:04:27 ERROR OGG-02078 Extract encountered a fatal error in a processing thread and is abending.

 

Database alert log will show: 

ORA-01422: exact fetch returns more than requested number of rows
ORA-06512: at "SYS.LOGMNR_GTLO3", line 630
ORA-06512: at line 1
OPIRIP: Uncaught error 447. Error stack:
ORA-00447: fatal error in background process
ORA-01422: exact fetch returns more than requested number of rows
ORA-06512: at "SYS.LOGMNR_GTLO3", line 630
ORA-06512: at line 1

 
Whenever collecting database ERRORSTACK trace for ORA-1422, the same will bring this failing query:

SELECT /*+ INDEX (logmnrc_gtlo logmnrc_gtlo_pk) */
lvlcnt, baseobj#, lvl1obj#, lvl2obj#, lvl0type#,
lvl1type#, lvl2type#, owner#, ownername,
lvl0name, lvl1name, lvl2name, assoc# , cols, intcols, kernelcols,
tab_flags, trigflag, obj_flags, ts#, tsname, property,
unsupportedcols, logmnrmcv, complextypecols, ntparentobjnum,
ntparentobjversion, ntparentintcolnum, logmnrtloflags,
PartType, SubPartType
FROM system.logmnrc_gtlo
WHERE logmnr_uid = 101 AND
keyobj# = :obj#_in AND
baseobjv# = :objv#_inout

  

 

 

Changes

Added a new integrated extract where there is already another integrated extract or Streams capture process created;

Deleted and added back the integrated extract or Streams capture process.

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.