Integrated Extract Fails During Startup With OGG-00662 OCI Error ORA-01422, OGG-02078.

(Doc ID 2345909.1)

Last updated on JANUARY 12, 2018

Applies to:

Oracle GoldenGate - Version 12.1.2.0.0 to 12.3.0.1.3 [Release 12.1 to 12.3]
Oracle Database - Enterprise Edition - Version 11.2.0.4 to 11.2.0.4 [Release 11.2]
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 : [/scratch/jkrath/view_storage/jkrath_oggsolsparcfbo/oggcore/OpenSys/src/app/er/redo/oracle/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 : [/scratch/jkrath/view_storage/jkrath_oggsolsparcfbo/oggcore/OpenSys/src/app/er/redo/oracle/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

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms