Dear guru,
I have problem with my OGG system. My database topology is Primary RAC 2 nodes on Linux 64bit, synchronize data to Logical standby RAC 2 nodes and to physical standby as usual.
My database system is running well. I have project synchronize data from schema on Logical standby to DR site. Then I use Oracle Goldengate 12.2.0.1 for this project. I tried classic capture for this. Everything is okay. But I have problems with this solution. That cannot synchronize compress table or any compress actions. Solution for this problem, they suggested me use Integrated capture. I changed my solution to Capture method. I tried with this without DOWNSTREAM_REAL_TIME_MINE, It is running well. But we need real time capture then I use DOWNSTREAM_REAL_TIME_MINE. I got problem when i started process with that parameter.
Source Context :
SourceModule : [er.redo.oraxo]
SourceID : [/scratch/aime/adestore/views/aime_adc4150378/oggcore/OpenSys/src/app/er/redo/oracle/redooraix.c]
SourceFunction : [REDOORAIX_set_outbound_params]
SourceLine : [8888]
ThreadBacktrace : [14] elements
: [/oracle_acfs/OGG12c/libgglog.so(CMessageContext::AddThreadContext()+0x1b) [0x7f6f52eb4f8b]]
: [/oracle_acfs/OGG12c/libgglog.so(CMessageFactory::CreateMessage(CSourceContext*, unsigned int, ...)+0x134) [0x7f6f52eaf114]]
: [/oracle_acfs/OGG12c/libgglog.so(_MSG_ERR_OIX_INVALID_PARAM(CSourceContext*, char const*, char const*, CMessageFactory::MessageDisposition)+0x3a) [0x7f6f52e86179]
]
: [/oracle_acfs/OGG12c/extract [0x7fa768]]
: [/oracle_acfs/OGG12c/extract(REDOORAIX_validate_config()+0x803) [0x7fbeb3]]
: [/oracle_acfs/OGG12c/extract(REDO_validate_config(bool, unsigned int*, bool&)+0x677) [0x764277]]
: [/oracle_acfs/OGG12c/extract(ggs::er::OraTranLogDataSource::setup()+0x6c) [0x75b99c]]
: [/oracle_acfs/OGG12c/extract [0x5f3b56]]
: [/oracle_acfs/OGG12c/extract(ggs::gglib::MultiThreading::MainThread::ExecMain()+0x60) [0x6d0400]]
: [/oracle_acfs/OGG12c/extract(ggs::gglib::MultiThreading::Thread::RunThread(ggs::gglib::MultiThreading::Thread::ThreadArgs*)+0x14d) [0x6d15ed]]
: [/oracle_acfs/OGG12c/extract(ggs::gglib::MultiThreading::MainThread::Run(int, char**)+0xb1) [0x6d16d1]]
: [/oracle_acfs/OGG12c/extract(main+0x3b) [0x5f4feb]]
: [/lib64/libc.so.6(__libc_start_main+0xf4) [0x3a8141d9c4]]
: [/oracle_acfs/OGG12c/extract [0x5630f9]]
2016-06-06 17:49:17 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_adc4150378/oggcore/OpenSys/src/gglib/ggdbora/ixoci.c]
SourceFunction : [IXOCI_setParameter]
SourceLine : [1551]
ThreadBacktrace : [15] elements
: [/oracle_acfs/OGG12c/libgglog.so(CMessageContext::AddThreadContext()+0x1b) [0x7f6f52eb4f8b]]
: [/oracle_acfs/OGG12c/libgglog.so(CMessageFactory::CreateMessage(CSourceContext*, unsigned int, ...)+0x134) [0x7f6f52eaf114]]
: [/oracle_acfs/OGG12c/libgglog.so(_MSG_ERR_OIX_OCI_ERROR(CSourceContext*, int, CMessageFactory::MessageDisposition)+0x30) [0x7f6f52e85ee5]]
: [/oracle_acfs/OGG12c/extract(IXOCI_setParameter(OCISESS_context_def*, ggs::gglib::ggunicode::UString const&, ggs::gglib::ggunicode::UString const&, ggs::gglib::gg
unicode::UString const&, bool)+0x35c) [0x742e1c]]
: [/oracle_acfs/OGG12c/extract [0x7f87b4]]
: [/oracle_acfs/OGG12c/extract(REDOORAIX_validate_config()+0x803) [0x7fbeb3]]
: [/oracle_acfs/OGG12c/extract(REDO_validate_config(bool, unsigned int*, bool&)+0x677) [0x764277]]
: [/oracle_acfs/OGG12c/extract(ggs::er::OraTranLogDataSource::setup()+0x6c) [0x75b99c]]
: [/oracle_acfs/OGG12c/extract [0x5f3b56]]
: [/oracle_acfs/OGG12c/extract(ggs::gglib::MultiThreading::MainThread::ExecMain()+0x60) [0x6d0400]]
: [/oracle_acfs/OGG12c/extract(ggs::gglib::MultiThreading::Thread::RunThread(ggs::gglib::MultiThreading::Thread::ThreadArgs*)+0x14d) [0x6d15ed]]
: [/oracle_acfs/OGG12c/extract(ggs::gglib::MultiThreading::MainThread::Run(int, char**)+0xb1) [0x6d16d1]]
: [/oracle_acfs/OGG12c/extract(main+0x3b) [0x5f4feb]]
: [/lib64/libc.so.6(__libc_start_main+0xf4) [0x3a8141d9c4]]
: [/oracle_acfs/OGG12c/extract [0x5630f9]]
2016-06-06 17:49:17 ERROR OGG-02042 OCI Error 26,764.
2016-06-06 17:49:17 ERROR OGG-01668 PROCESS ABENDING.
-----------------
My Extract group parameter:
extract extmat
userid ogg, password ogg
TRANLOGOPTIONS INTEGRATEDPARAMS (MAX_SGA_SIZE 500, DOWNSTREAM_REAL_TIME_MINE y)
--TRANLOGOPTIONS ASMUSER sys@ltest1_asm1 ASMPASSWORD sys
--checkparams
--NODYNAMICRESOLUTION
exttrail /oracle_acfs/OGG12c/dirdat/ma
LOGALLSUPCOLS
UPDATERECORDFORMAT COMPACT
DDL &
INCLUDE MAPPED
table report_admin.TRANS_BACKEND_V2;
My Extract pump parameter:
extract pumpmat
passthru
rmthost 172.16.17.120, mgrport 7809
rmttrail /oracle/OGG12c/dirdat/ma
table report_admin.trans_backend_v2;
--------------
I read a note on MOSC Integrated Downstream Real Time Capture Extract Fails With OGG-02032 and OGG-02042 (Doc ID 2105193.1) which solve this problem. But I tried it for my case. It cannot solve my problem. Would you please help me this issue?
Many thanks,
Khue