OGG-01837 Fetch requires database redo compatible version 11.2.0.0 or higher and OGG-02078 Extract encountered a fatal error in a processing thread and is abending

Mehmet Salih Deveci

6 years ago

Hi,

You can get ” OGG-01837 Fetch requires database redo compatible version 11.2.0.0 or higher and OGG-02078 Extract encountered a fatal error in a processing thread and is abending ” error.

Details of error are as follows.

2020-04-24 15:40:53  ERROR   OGG-01837  Fetch requires database redo compatible version 11.2.0.0 or higher.

Source Context :
  SourceModule            : [er.redo.ora.IXFormatter]
  SourceID                : [er/redo/oracle/IXFormatter.cpp]
  SourceMethod            : [getResult]
  SourceLine              : [761]
  ThreadBacktrace         : [15] elements
                          : [/ggateb01/goldengate/product/19.1.0.0.4/libgglog.so(CMessageContext::AddThreadContext())]
                          : [/ggateb01/goldengate/product/19.1.0.0.4/libgglog.so(CMessageFactory::CreateMessage(CSourceContext*, unsigned int, ...))]
                          : [/ggateb01/goldengate/product/19.1.0.0.4/libgglog.so(_MSG_(CSourceContext*, int, CMessageFactory::MessageDisposition))]
                          : [/ggateb01/goldengate/product/19.1.0.0.4/extract()]
                          : [/ggateb01/goldengate/product/19.1.0.0.4/extract(RedoIE::readLCR(ggs::gglib::gglcr::CommonLCR**, long&, bool&))]
                          : [/ggateb01/goldengate/product/19.1.0.0.4/extract(ggs::er::OraTranLogDataSource::readLCR(ggs::gglib::gglcr::CommonLCR**, long&, bool&))]
                          : [/ggateb01/goldengate/product/19.1.0.0.4/extract(ggs::er::ExtractContext::processExtractLoop())]
                          : [/ggateb01/goldengate/product/19.1.0.0.4/extract(ggs::er::ExtractContext::run())]
                          : [/ggateb01/goldengate/product/19.1.0.0.4/extract()]
                          : [/ggateb01/goldengate/product/19.1.0.0.4/extract(ggs::gglib::MultiThreading::MainThread::ExecMain())]
                          : [/ggateb01/goldengate/product/19.1.0.0.4/extract(ggs::gglib::MultiThreading::Thread::RunThread(ggs::gglib::MultiThreading::Thread::ThreadAr
gs*))]
                          : [/ggateb01/goldengate/product/19.1.0.0.4/extract(ggs::gglib::MultiThreading::MainThread::Run(int, char**))]
                          : [/ggateb01/goldengate/product/19.1.0.0.4/extract(main)]
                          : [/lib64/libc.so.6(__libc_start_main)]
                          : [/ggateb01/goldengate/product/19.1.0.0.4/extract()]

2020-04-24 15:40:53  ERROR   OGG-02078  Extract encountered a fatal error in a processing thread and is abending.

To solve this problem, Use classic capture. Because Classic capture support the following:

Use the following command to convert integrated extract to Classic.

ALTER EXTRACT EXTMSD01, DOWNGRADE INTEGRATED TRANLOG

You can convert classic extract to integrated again as follows.

ALTER EXTRACT <EXTRACT_NAME>, INTEGRATED

 ALTER EXTRACT EXTMSD01, UPGRADE INTEGRATED TRANLOG

Do you want to learn Oracle Goldengate from scratch, then read the following Goldengate Tutorial articles.

https://ittutorial.org/goldengate-tutorials-oracle-for-beginners/