Replicat Abending With Eror OGG-00665 OCI Error Flushing Database Inbound Server (Doc ID 2290088.1)

Last updated on JULY 28, 2017

Applies to:

Oracle GoldenGate - Version 12.2.0.1.0 and later
Information in this document applies to any platform.

Symptoms

While trying to setup a new replication, the replicat process was abending with the error:

2017-07-19 10:51:39 INFO OGG-06506 Wildcard MAP resolved (entry CUSTOMER.*): MAP "CUSTOMER"."INVOICE_PREP", TARGET CUSTOMER."INVOICE_PREP".

Source Context :
SourceModule : [ggdb.ora.sess]
SourceID : [/scratch/jkrath/view_storage/jkrath_ogglinpatch/oggcore/OpenSys/src/gglib/ggdbora/ocisess.c]
SourceFunction : [oci_try]
SourceLine : [872]
ThreadBacktrace : [23] elements
: [/ggate/libgglog.so(CMessageContext::AddThreadContext()+0x1b) [0x7fa7192166eb]]
: [/ggate/libgglog.so(CMessageFactory::CreateMessage(CSourceContext*, unsigned int, ...)+0x135) [0x7fa7192107b5]]
: [/ggate/libgglog.so(_MSG_ERR_ORACLE_OCI_ERROR_WITH_DESC_SQL(CSourceContext*, int, char const*, char const*, char const*, CMessageFactory::MessageDisposition)+0x4e) [0x7fa7191fb5ab]]
: [/ggate/replicat(OCISESS_context_def::oci_try(int, char const*, ...)+0x531) [0x73cdf1]]
: [/ggate/replicat(IROCI_flush(OCISESS_context_def*, unsigned int)+0x11d) [0x75ec0d]]
: [/ggate/replicat(IROCI_flush_call(OCISESS_context_def*)+0x21) [0x75efd1]]
: [/ggate/replicat(query_handle::select_start(bool, ggs::gglib::ggunicode::UString const&, short, ...)+0x97) [0x73ffe7]]
: [/ggate/replicat(ORAUTIL_verifyDeferrableConstraint(ggs::gglib::ggapp::CQualDBObjName<(DBObjType)1> const&, int*)+0xdd) [0x751fad]]
: [/ggate/replicat(DBUTIL_verifyDeferrableConstraint(ggs::gglib::ggapp::CQualDBObjName<(DBObjType)1> const&, int*)+0x30) [0x65be60]]
: [/ggate/replicat(get_map_entry(ggs::gglib::ggunicode::UString const&, int, wc_def*, int, unsigned int, unsigned int, ggs::gglib::ggmetadata::CTblMetadata*, ggs::gglib::ggmetadata::CMetadataReader*, bool, bool, bool)+0x6d7) [0x5cfcb7]]
: [/ggate/replicat(wc_def::resolve_wc_entry(ggs::gglib::ggapp::CQualDBObjName<(DBObjType)1> const&, int, unsigned int*, ggs::gglib::ggapp::CQualDBObjName<(DBObjType)1>*, int, ggs::gglib::ggmetadata::CTblMetadata*, ggs::gglib::ggmetadata::CMetadataReader*)+0x1ee) [0x6a3e1e]]
: [/ggate/replicat(WILDCARD_check_table(ggs::gglib::ggapp::CQualDBObjName<(DBObjType)1> const*, int, unsigned int*, int, unsigned int, ggs::gglib::ggapp::CQualDBObjName<(DBObjType)1>*, int, ggs::gglib::ggmetadata::CTblMetadata*, ggs::gglib::ggmetadata::CMetadataReader*, bool)+0x195) [0x6a4435]]
: [/ggate/replicat(REP_find_source_file_wc(ggs::gglib::ggapp::CQualDBObjName<(DBObjType)1> const&, unsigned int, ggs::gglib::ggapp::CQualDBObjName<(DBObjType)1>*, int, ggs::gglib::ggmetadata::CTblMetadata*, ggs::gglib::ggmetadata::CMetadataReader*, bool)+0x1ad) [0x5cd33d]]
: [/ggate/replicat(source_file_lookup(ggs::gglib::gglcr::CommonLCR const*, ggs::gglib::ggmetadata::CMetadataReader*)+0x496) [0x5b2cb6]]
: [/ggate/replicat(ggs::er::ReplicatContext::processReplicatLoop(ggs::Heartbeat::MapGeneratorParams&)+0xd86) [0x5f6a66]]
: [/ggate/replicat(ggs::er::ReplicatContext::run(ggs::Heartbeat::MapGeneratorParams&)+0x29) [0x5eaeb9]]
: [/ggate/replicat() [0x633cfb]]
: [/ggate/replicat(ggs::gglib::MultiThreading::MainThread::ExecMain()+0x60) [0x6ecdf0]]
: [/ggate/replicat(ggs::gglib::MultiThreading::Thread::RunThread(ggs::gglib::MultiThreading::Thread::ThreadArgs*)+0x14d) [0x6ede0d]]
: [/ggate/replicat(ggs::gglib::MultiThreading::MainThread::Run(int, char**)+0xb1) [0x6edef1]]
: [/ggate/replicat(main+0x3b) [0x636eeb]]
: [/lib64/libc.so.6(__libc_start_main+0xf5) [0x7fa70fd71b35]]
: [/ggate/replicat() [0x56c559]]

2017-07-19 10:51:39 ERROR OGG-00665 OCI Error Flushing database inbound server, 'OGG$TCMRPT' (status = 26815-ORA-26815: Error from Apply Network Receiver for Apply "OGG$TCMRPT" and Capture "replicat".
ORA-21580: Message 21580 not found; product=RDBMS; facility=ORA; arguments: [4231] [SEARCH_STRING_CONTENT]), SQL<SELECT status, deferrable FRO

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