DOWNSTREAM CAPTURE EXTRACT ABENDS: OGG-02032 Failed to set TRANLOGOPTIONS INTEGRATEDPARAMS (DOWNSTREAM_REAL_TIME_MINE, Y).

(Doc ID 2153657.1)

Last updated on FEBRUARY 14, 2017

Applies to:

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

Symptoms

downstream capture integrated extract abends with:

2016-05-16 10:33:50 ERROR OGG-02032 Failed to set TRANLOGOPTIONS
INTEGRATEDPARAMS (DOWNSTREAM_REAL_TIME_MINE, Y).
.
Source Context :
SourceModule : [ggdb.ora.ixoci]
SourceID :
[/scratch/aime/adestore/views/aime_adc4150408/oggcore/OpenSys/src/gglib/ggdbor
a/ixoci.c]
SourceFunction : [IXOCI_setParameter]
SourceLine : [1551]
ThreadBacktrace : [15] elements
:
[/u01/oracle/ORADML/Ggate12cR2/libgglog.so(CMessageContext::AddThreadContext()
+0x1b) [0x7eff6d7110bb]]
:
[/u01/oracle/ORADML/Ggate12cR2/libgglog.so(CMessageFactory::CreateMessage(CSou
rceContext*, unsigned int, ...)+0x134) [0x7eff6d70b254]]
:
[/u01/oracle/ORADML/Ggate12cR2/libgglog.so(_MSG_ERR_OIX_OCI_ERROR(CSourceConte
xt*, int, CMessageFactory::MessageDisposition)+0x30) [0x7eff6d6e2005]]
:
[/u01/oracle/ORADML/Ggate12cR2/extract(IXOCI_setParameter(OCISESS_context_def*
, ggs::gglib::ggunicode::UString const&, ggs::gglib::ggunicode::UString
const&, ggs::gglib::ggunicode::UString const&, bool)+0x35c) [0x75375c]]
: [/u01/oracle/ORADML/Ggate12cR2/extract()
[0x808854]]
:
[/u01/oracle/ORADML/Ggate12cR2/extract(REDOORAIX_validate_config()+0x6e0)
[0x80be30]]
:
[/u01/oracle/ORADML/Ggate12cR2/extract(REDO_validate_config(bool, unsigned
int*, bool&)+0x677) [0x778c27]]
:
[/u01/oracle/ORADML/Ggate12cR2/extract(ggs::er::OraTranLogDataSource::setup()+
0x6c) [0x76c20c]]
: [/u01/oracle/ORADML/Ggate12cR2/extract()
[0x603b76]]
:
[/u01/oracle/ORADML/Ggate12cR2/extract(ggs::gglib::MultiThreading::MainThread:
:ExecMain()+0x60) [0x6e05e0]]
:
[/u01/oracle/ORADML/Ggate12cR2/extract(ggs::gglib::MultiThreading::Thread::Run
Thread(ggs::gglib::MultiThreading::Thread::ThreadArgs*)+0x14d) [0x6e17cd]]
:
[/u01/oracle/ORADML/Ggate12cR2/extract(ggs::gglib::MultiThreading::MainThread:
:Run(int, char**)+0xb1) [0x6e18b1]]
: [/u01/oracle/ORADML/Ggate12cR2/extract(main+0x3b)
[0x60500b]]
: [/lib64/libc.so.6(__libc_start_main+0xfd)
[0x3cb861ed5d]]
: [/u01/oracle/ORADML/Ggate12cR2/extract()
[0x573069]]
.
2016-05-16 10:33:50 ERROR OGG-02042 OCI Error 23605.
.
2016-05-16 10:33:50 ERROR OGG-01668 PROCESS ABENDING. 

 

When using parameter (DOWNSTREAM_REAL_TIME_MINE, N), the extract works fine.

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