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/