OGG Extracts Abends with OGG-00446 Error

(Doc ID 1662433.1)

Last updated on JULY 03, 2017

Applies to:

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

Symptoms

Extract abending with the following:

Maximum supported ASM read buffer size is 28 KB

2014-04-10 15:24:15 WARNING OGG-01423 No valid default archive log destination directory found for thread 1.

Maximum supported ASM read buffer size is 28 KB

2014-04-10 15:24:15 WARNING OGG-01423 No valid default archive log destination directory found for thread 2.

2014-04-10 15:24:16 INFO OGG-00546 Default thread stack size: 33554432.

2014-04-10 15:24:16 INFO OGG-01515 Positioning to begin time Apr 9, 2014 9:00:00 AM.

2014-04-10 15:24:36 INFO OGG-01516 Positioned to (Thread 1) Sequence 83, RBA 414058496, SCN 0.0, Apr 9, 2014 9:00:00 AM.

2014-04-10 15:24:36 INFO OGG-01515 Positioning to begin time Apr 9, 2014 9:00:00 AM.

Source Context :
 SourceModule : [er.common]
 SourceID : [/scratch/aime1/adestore/views/aime1_adc4150256/oggcore/OpenSys/src/app/er/common.cpp]
 SourceFunction : [extract_start_point]
 SourceLine : [2090]
 ThreadBacktrace : [7] elements
  : [/app/oracle/ggs/libgglog.so(CMessageContext::AddThreadContext()+0x1e) [0x2ba78741470e]]
  : [/app/oracle/ggs/libgglog.so(CMessageFactory::CreateMessage(CSourceContext*, unsigned int, ...)+0x2cc) [0x2ba78740d6ac]]
  : [/app/oracle/ggs/libgglog.so(_MSG_ERR_CHECKPOINT_GENERIC(CSourceContext*, char const*, CMessageFactory::MessageDisposition)+0x31) [0x2ba7873fee09]]
  : [/app/oracle/ggs/extract(extract_start_point(time_elt_def*, time_elt_def*)+0x14e) [0x545abe]]
  : [/app/oracle/ggs/extract(main+0x3d7) [0x5738b7]]
  : [/lib64/libc.so.6(__libc_start_main+0xf4) [0x33ae61d994]]
  : [/app/oracle/ggs/extract(__gxx_personality_v0+0x38a) [0x4edaba]]

2014-04-10 15:25:54 ERROR OGG-00446 Could not find archived log for sequence 1 thread 2 under default destinations SQL

Changes

 

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