Forum Stats

  • 3,767,940 Users
  • 2,252,732 Discussions
  • 7,874,386 Comments

Discussions

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

User_DDKH9
User_DDKH9 Member Posts: 2 Red Ribbon

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!

Answers

  • ORASCN
    ORASCN Member Posts: 1,824 Gold Trophy
    edited Feb 18, 2021 5:28AM

    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