HI ALL,
I am trying to create classic extract in goldengate microservices architecture(19.22.0.0.240124) via goldengate hub machine on database 11g(11.2.0.4) but i am facing ERROR OGG-02830 Formatting error, ERROR OGG-01668 PROCESS ABENDING.
Below is my report file of extract:-
***********************************************************************
Oracle GoldenGate Capture for Oracle
Version 19.22.0.0.240124 OGGCORE_19.22.0.0.0OGGRU_PLATFORMS_240125.1200_FBO
Linux, x64, 64bit (optimized), Oracle 19c on Jan 25 2024 16:06:37
Copyright (C) 1995, 2024, Oracle and/or its affiliates. All rights reserved.
Starting at 2025-02-18 12:40:07
***********************************************************************
Operating System Version:
Linux
Version #1 SMP Thu Mar 14 14:20:09 EDT 2024, Release 4.18.0-513.24.1.el8_9.x86_64
Node: localhost.localdomain
Machine: x86_64
soft limit hard limit
Address Space Size : unlimited unlimited
Heap Size : unlimited unlimited
File Size : unlimited unlimited
CPU Time : unlimited unlimited
Process id: 917082
Description: extract from 11g(src)
***********************************************************************
** Running with the following parameters **
***********************************************************************
2025-02-18 12:40:07 INFO OGG-03059 Operating system character set identified as UTF-8.
2025-02-18 12:40:07 INFO OGG-02695 ANSI SQL parameter syntax is used for parameter parsing.
2025-02-18 12:40:07 INFO OGG-01360 EXTRACT is running in Classic mode.
EXTRACT ext_11g
USERIDALIAS gg_tgt DOMAIN OracleGoldenGate
EXTTRAIL mm
TRANLOGOPTIONS DBLOGREADER
table test.table1;
2025-02-18 12:40:08 INFO OGG-02734 Using heartbeat table from schema ggadmin.
2025-02-18 12:40:08 INFO OGG-01635 BOUNDED RECOVERY: not used. NORMAL RECOVERY only used due to altered checkpoint.
2025-02-18 12:40:08 INFO OGG-01815 Virtual Memory Facilities for: BR
anon alloc: mmap(MAP_ANON) anon free: munmap
file alloc: mmap(MAP_SHARED) file free: munmap
target directories:
/micro_gg/servers/deploy2/var/run/BR/EXT_11G.
Bounded Recovery Parameter:
BRINTERVAL = 4HOURS
BRDIR = /micro_gg/servers/deploy2/var/run/
2025-02-18 12:40:08 INFO OGG-01851 filecaching started: thread ID: 140108793992960.
2025-02-18 12:40:08 INFO OGG-01815 Virtual Memory Facilities for: COM
anon alloc: mmap(MAP_ANON) anon free: munmap
file alloc: mmap(MAP_SHARED) file free: munmap
target directories:
/micro_gg/servers/deploy2/var/temp.
2025-02-18 12:40:08 INFO OGG-25340
Database Version:
Oracle Database 11g Enterprise Edition Release 11.2.0.4.0 - 64bit Production
PL/SQL Release 11.2.0.4.0 - Production
CORE 11.2.0.4.0 Production
TNS for Solaris: Version 11.2.0.4.0 - Production
NLSRTL Version 11.2.0.4.0 - Production.
2025-02-18 12:40:08 INFO OGG-25341
Database Language and Character Set:
NLS_LANGUAGE = "AMERICAN"
NLS_TERRITORY = "AMERICA"
NLS_CHARACTERSET = "WE8MSWIN1252".
2025-02-18 12:40:08 INFO OGG-06604 Database ORCL CPU info: CPU Count 4, CPU Core Count 4, CPU Socket Count 1.
Maximum supported ASM read buffer size is 4096 KB
2025-02-18 12:40:08 INFO OGG-02089 Source redo compatibility version is: 11.2.0.4.0.
2025-02-18 12:40:08 INFO OGG-02776 Native data capture is enabled for Oracle NUMBER data type.
2025-02-18 12:40:08 INFO OGG-01515 Positioning to begin time 2025 M02 18 12:36:25.
Source Context :
SourceModule : [er.redo.ora.rdr]
SourceID : [er/redo/oracle/redoorardr.c]
SourceMethod : [getLogPosition]
SourceLine : [5594]
ThreadBacktrace : [15] elements
: [/micro_gg/gg_home/bin/../lib/libgglog.so(CMessageContext::AddThreadContext())]
: [/micro_gg/gg_home/bin/../lib/libgglog.so(CMessageFactory::CreateMessage(CSourceContext*, unsigned int, ...))]
: [/micro_gg/gg_home/bin/../lib/libgglog.so(_MSG_DateTime_String(CSourceContext*, int, timeval, char const*, CMessageFactory::MessageDisposition))]
: [/micro_gg/gg_home/bin/extract()]
: [/micro_gg/gg_home/bin/extract(RedoClassic::positionIntoRedoLogFile(int, bool, bool, bool))]
: [/micro_gg/gg_home/bin/extract(ggs::er::OraTranLogDataSource::establishStartPoint(char))]
: [/micro_gg/gg_home/bin/extract(ggs::gglib::ggapp::ReplicationContext::establishStartPoints(char, ggs::gglib::ggdatasource::DataSourceParams const&))]
: [/micro_gg/gg_home/bin/extract(ggs::gglib::ggapp::ReplicationContext::initializeDataSources(ggs::gglib::ggdatasource::DataSourceParams&))]
: [/micro_gg/gg_home/bin/extract()]
: [/micro_gg/gg_home/bin/extract(ggs::gglib::MultiThreading::MainThread::ExecMain())]
: [/micro_gg/gg_home/bin/extract(ggs::gglib::MultiThreading::Thread::RunThread(ggs::gglib::MultiThreading::Thread::ThreadArgs*))]
: [/micro_gg/gg_home/bin/extract(ggs::gglib::MultiThreading::MainThread::Run(int, char**))]
: [/micro_gg/gg_home/bin/extract(main)]
: [/lib64/libc.so.6(__libc_start_main)]
: [/micro_gg/gg_home/bin/extract()]
2025-02-18 12:40:32 ERROR OGG-02830 Formatting error.
2025-02-18 12:40:32 ERROR OGG-01668 PROCESS ABENDING.
I can't use Integrated extract on my 11g(11.2.0.4) as it requires Patch 17030189 but i cant install any patch on my DB due to some restrictions
Also i tried TRANLOGOPTIONS DBLOGREADER parameter , but still error persisits
Any guess on what could be the problem?
Thanks in advance