Integrated Replicat Abends with OGG-00665 (ORA-26815/ORA-01722: invalid number)
(Doc ID 1908513.1)
Last updated on MAY 11, 2022
Applies to:
Oracle GoldenGate - Version 12.1.2.0.0 and laterInformation in this document applies to any platform.
Symptoms
Integrated Replicat Abends randomly with OGG-00665 randomly while replicating different tables with the following stack:
Source Context :
SourceModule : [ggdb.ora.sess]
SourceID :
[/scratch/aime1/adestore/views/aime1_adc4150281/oggcore/OpenSys/src/gglib/ggdb
ora/ocisess.c]
SourceFunction : [oci_try]
SourceLine : [801]
2014-03-14 15:32:50 ERROR OGG-00665 OCI Error Flushing database inbound server, 'OGG$<REPLICAT>' (status = 26815-ORA-26815: Error from Apply Network
Receiver for Apply "OGG$<REPLICAT>" and Capture "replicat". ORA-01722: invalid number), SQL<select status, deferrable from dba_constraints where owner =UPPER('demo') and
table_name=UPPER('test') and constraint_type = 'P' >.
Changes
Introduced LOGALLSUPCOLS in the EXTRACT parameter file.
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 |