Oracle Golden Gate 19.1 and Oracle DB 12.1 - error starting extract OGG-02830

User_DDKH9

Hello everyone,

I've installed the Oracle Golden Gate 19.1.0.0.4 and I am using Oracle database 12.1.0.2.

I' trying to start a extract but I got the following error:

----------------------------------------------------------------------------------------------------

Source Context :

 SourceModule      : [er.redo.ora.rdr]

 SourceID        : [er/redo/oracle/redoorardr.c]

 SourceMethod      : [getLogPosition]

 SourceLine       : [5548]

 ThreadBacktrace     : [15] elements

             : [/u01/app/oracle/product/19c.ogg/libgglog.so(CMessageContext::AddThreadContext())]

             : [/u01/app/oracle/product/19c.ogg/libgglog.so(CMessageFactory::CreateMessage(CSourceContext*, unsigned int, ...))]

             : [/u01/app/oracle/product/19c.ogg/libgglog.so(_MSG_DateTime_String(CSourceContext*, int, timeval, char const*, CMessageFactory::MessageDisposition))]

             : [/u01/app/oracle/product/19c.ogg/extract()]

             : [/u01/app/oracle/product/19c.ogg/extract(RedoClassic::positionIntoRedoLogFile(int, bool, bool, bool))]

             : [/u01/app/oracle/product/19c.ogg/extract(ggs::er::OraTranLogDataSource::establishStartPoint(char))]

             : [/u01/app/oracle/product/19c.ogg/extract(ggs::gglib::ggapp::ReplicationContext::establishStartPoints(char, ggs::gglib::ggdatasource::DataSourceParams const&))]

             : [/u01/app/oracle/product/19c.ogg/extract(ggs::gglib::ggapp::ReplicationContext::initializeDataSources(ggs::gglib::ggdatasource::DataSourceParams&))]

             : [/u01/app/oracle/product/19c.ogg/extract()]

             : [/u01/app/oracle/product/19c.ogg/extract(ggs::gglib::MultiThreading::MainThread::ExecMain())]

             : [/u01/app/oracle/product/19c.ogg/extract(ggs::gglib::MultiThreading::Thread::RunThread(ggs::gglib::MultiThreading::Thread::ThreadArgs*))]

             : [/u01/app/oracle/product/19c.ogg/extract(ggs::gglib::MultiThreading::MainThread::Run(int, char**))]

             : [/u01/app/oracle/product/19c.ogg/extract(main)]

             : [/lib64/libc.so.6(__libc_start_main)]

             : [/u01/app/oracle/product/19c.ogg/extract()]

2021-02-15 13:29:20 ERROR  OGG-02830 Formatting error.

2021-02-15 13:29:20 ERROR  OGG-01668 PROCESS ABENDING.

----------------------------------------------------------------------------------------------------

The parameters for extract is:

----------------------------------------------------------------------------------------------------

extract ext1

userid OGG, password *******

rmthost orasrv12gg2, mgrport 7809

rmttrail /u01/app/oracle/product/19c.ogg/dirdat/lt

ddl include mapped objname HRPRD.*;

table HRPRD.*;

----------------------------------------------------------------------------------------------------

Can somebody help me?

Thank you very much!

ORASCN

Hi,

Could you please share the full report file.

Whether the redo / archive logs are in ASM? If so, you need to use below in the extract parameter file.

TRANLOGOPTIONS DBLOGREADER

Did you select the correct database version during the OGG installation?

Regards,

Veera