Skip to Main Content

GoldenGate

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

goldengate for udb extract could not start

3194070Mar 14 2016 — edited Mar 15 2016

Oracle GoldenGate Command Interpreter for DB2

Version 12.1.2.1.10 21604177 OGGCORE_12.1.2.1.0OGGBP_PLATFORMS_150902.1337

Linux, x64, 64bit (optimized), DB2 10.5 on Sep  2 2015 18:40:35

Operating system character set identified as UTF-8.

2016-03-14 16:25:34  INFO    OGG-01515  Positioning to begin time Mar 14, 2016 4:25:23 PM.

Source Context :
  SourceModule            : [er.redo.db2]
  SourceID                : [/scratch/aime1/adestore/views/aime1_adc4150488/oggcore/OpenSys/src/app/er/redo/db2luw/redodb2.c]
  SourceFunction          : [REDO_position]
  SourceLine              : [1423]
  ThreadBacktrace         : [13] elements
                          : [/oracle/goldengate/libgglog.so(CMessageContext::AddThreadContext()+0x26) [0x7fe1e38ef476]]
                          : [/oracle/goldengate/libgglog.so(CMessageFactory::CreateMessage(CSourceContext*, unsigned int, ...)+0x2af) [0x7fe1e38e733f]]
                          : [/oracle/goldengate/libgglog.so(_MSG_ERR_ABORT(CSourceContext*, CMessageFactory::MessageDisposition)+0x84) [0x7fe1e38bcfe4]]
                          : [/oracle/goldengate/extract(REDO_position(void*, unsigned int, char (&) [2048], bool)+0x174c) [0x7a758c]]
                          : [/oracle/goldengate/extract(START_EXTRACT_CHECKPOINT(chkpt_context_t*, char (&) [2048], char*, char*, short, int, int, int, char*, short)+0x
1e7) [0x4cdca7]]
                          : [/oracle/goldengate/extract(extract_start_point(time_elt_def*, time_elt_def*)+0xa5) [0x54c7b5]]
                          : [/oracle/goldengate/extract(extract_main(int, char**)+0x3a2) [0x599fd2]]
                          : [/oracle/goldengate/extract(ggs::gglib::MultiThreading::MainThread::ExecMain()+0x6f) [0x72898f]]
                          : [/oracle/goldengate/extract(ggs::gglib::MultiThreading::Thread::RunThread(ggs::gglib::MultiThreading::Thread::ThreadArgs*)+0x11a) [0x72678a]
]
                          : [/oracle/goldengate/extract(ggs::gglib::MultiThreading::MainThread::Run(int, char**)+0x128) [0x7276f8]]
                          : [/oracle/goldengate/extract(main+0x4a) [0x598e6a]]
                          : [/lib64/libc.so.6(__libc_start_main+0xfd) [0x3b03e1ed5d]]
                          : [/oracle/goldengate/extract() [0x4beb49]]

2016-03-14 16:25:36  ERROR   OGG-00001  Execution cannot continue - Program Terminating.

Source Context :
  SourceModule            : [er.redo.db2.ops]
  SourceID                : [/scratch/aime1/adestore/views/aime1_adc4150488/oggcore/OpenSys/src/app/er/redo/db2luw/db2ops.c]
  SourceFunction          : [DB2OPS_readSingle]
  SourceLine              : [1818]
  ThreadBacktrace         : [16] elements
                          : [/oracle/goldengate/libgglog.so(CMessageContext::AddThreadContext()+0x26) [0x7fe1e38ef476]]
                          : [/oracle/goldengate/libgglog.so(CMessageFactory::CreateMessage(CSourceContext*, unsigned int, ...)+0x2af) [0x7fe1e38e733f]]
                          : [/oracle/goldengate/libgglog.so(_MSG_ERR_DB2LUW_DB2READLOG_SQL_ERROR(CSourceContext*, char const*, CMessageFactory::MessageDisposition)+0x42
) [0x7fe1e38a1962]]
                          : [/oracle/goldengate/extract(DB2OPS_readSingle+0x374) [0x779624]]
                          : [/oracle/goldengate/extract() [0x78b64b]]
                          : [/oracle/goldengate/extract(DB2RDR_positionToTimestamp+0x354) [0x78d964]]
                          : [/oracle/goldengate/extract(REDO_position(void*, unsigned int, char (&) [2048], bool)+0x1328) [0x7a7168]]
                          : [/oracle/goldengate/extract(START_EXTRACT_CHECKPOINT(chkpt_context_t*, char (&) [2048], char*, char*, short, int, int, int, char*, short)+0x
1e7) [0x4cdca7]]
                          : [/oracle/goldengate/extract(extract_start_point(time_elt_def*, time_elt_def*)+0xa5) [0x54c7b5]]
                          : [/oracle/goldengate/extract(extract_main(int, char**)+0x3a2) [0x599fd2]]
                          : [/oracle/goldengate/extract(ggs::gglib::MultiThreading::MainThread::ExecMain()+0x6f) [0x72898f]]
                          : [/oracle/goldengate/extract(ggs::gglib::MultiThreading::Thread::RunThread(ggs::gglib::MultiThreading::Thread::ThreadArgs*)+0x11a) [0x72678a]
]
                          : [/oracle/goldengate/extract(ggs::gglib::MultiThreading::MainThread::Run(int, char**)+0x128) [0x7276f8]]
                          : [/oracle/goldengate/extract(main+0x4a) [0x598e6a]]
                          : [/lib64/libc.so.6(__libc_start_main+0xfd) [0x3b03e1ed5d]]
                          : [/oracle/goldengate/extract() [0x4beb49]]

2016-03-14 16:25:36  ERROR   OGG-00817  db2ReadLog error [SC=2654:SQL2654W  The database log has been asynchronously read to the end of the current active log].

2016-03-14 16:25:36  ERROR   OGG-01668  PROCESS ABENDING.

I have tried to reboot the database without luck.

Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Apr 12 2016
Added on Mar 14 2016
7 comments
1,817 views