Discussions
Categories
- 17.9K All Categories
- 3.4K Industry Applications
- 3.3K Intelligent Advisor
- 63 Insurance
- 535.7K On-Premises Infrastructure
- 138.1K Analytics Software
- 38.6K Application Development Software
- 5.6K Cloud Platform
- 109.3K Database Software
- 17.5K Enterprise Manager
- 8.8K Hardware
- 71K Infrastructure Software
- 105.2K Integration
- 41.5K Security Software
Oracle Golden Gate 19.1 and Oracle DB 12.1 - error starting extract OGG-02830

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
-
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