Hi All,
I never faced this type of error before.
I'm trying to run GoldenGate 19.1.0.0.4 for Oracle on Linux x86_64, for a remote old Oracle Database 11.2.0.4.0 in classic extract mode.
I can run the initialload extract normally, but the primary extracts ABENDs with OGG-02830 Formatting error.
I already checked the certification matrix https://www.oracle.com/technetwork/middleware/ogg-19-1-0-0-0-cert-matrix-5491855.xls and 11.2.0.4 is fully compatible for Goldengate 19.1.0.0.4.
This is the report file for the primary extract:
> view report edbps01d
***********************************************************************
Oracle GoldenGate Capture for Oracle
Version 19.1.0.0.4 OGGCORE_19.1.0.0.0_PLATFORMS_191017.1054_FBO
Linux, x64, 64bit (optimized), Oracle 11g on Oct 17 2019 23:13:30
Copyright (C) 1995, 2019, Oracle and/or its affiliates. All rights reserved.
Starting at 2020-06-19 22:00:48
***********************************************************************
Operating System Version:
Linux
Version #2 SMP Fri May 29 14:56:41 PDT 2020, Release 4.14.35-1902.303.4.1.el7uek.x86_64
Node: goldengatestaging
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: 31638
Description:
***********************************************************************
** Running with the following parameters **
***********************************************************************
2020-06-19 22:00:48 INFO OGG-03059 Operating system character set identified as UTF-8.
2020-06-19 22:00:48 INFO OGG-02695 ANSI SQL parameter syntax is used for parameter parsing.
Extract edbps01d
UserIDAlias ogg_user_dev
EXTTRAIL ./dirdat/ab
GETTRUNCATES
LOGALLSUPCOLS
2020-06-19 22:00:48 WARNING OGG-04033 LOGALLSUPCOLS has set the NOCOMPRESSDELETES and GETUPDATEBEFORES parameters on.
NOCOMPRESSUPDATES
TABLE FDSPPRD.PS_PHYSICAL_INV;
TABLE FDSPPRD.PS_STOR_LOC_INV;
TABLE FDSPPRD.PS_CM_PERPAVG_COST;
TABLE FDSPPRD.PS_BUS_UNIT_TBL_IN;
2020-06-19 22:00:48 INFO OGG-01635 BOUNDED RECOVERY: not used. NORMAL RECOVERY only used due to altered checkpoint.
2020-06-19 22:00:48 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:
/u01/app/goldengate/BR/EDBPS01D.
Bounded Recovery Parameter:
BRINTERVAL = 4HOURS
BRDIR = /u01/app/goldengate/
2020-06-19 22:00:48 INFO OGG-01851 filecaching started: thread ID: 139908194506496.
2020-06-19 22:00:48 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:
/u01/app/goldengate/dirtmp.
2020-06-19 22:00:48 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 IBM/AIX RISC System/6000: Version 11.2.0.4.0 - Production
NLSRTL Version 11.2.0.4.0 - Production.
2020-06-19 22:00:48 INFO OGG-25341
Database Language and Character Set:
NLS_LANGUAGE = "AMERICAN"
NLS_TERRITORY = "AMERICA"
NLS_CHARACTERSET = "WE8ISO8859P1".
2020-06-19 22:00:48 INFO OGG-06604 Database DBPSDEV CPU info: CPU Count 10, CPU Core Count 16, CPU Socket Count 0.
2020-06-19 22:00:49 INFO OGG-02089 Source redo compatibility version is: 11.2.0.4.0.
2020-06-19 22:00:49 INFO OGG-02776 Native data capture is enabled for Oracle NUMBER data type.
2020-06-19 22:00:49 INFO OGG-01515 Positioning to begin time 2020 M06 19 22:00:43.
Source Context :
SourceModule : [er.redo.ora.rdr]
SourceID : [er/redo/oracle/redoorardr.c]
SourceMethod : [getLogPosition]
SourceLine : [5548]
ThreadBacktrace : [15] elements
: [/u01/app/goldengate/libgglog.so(CMessageContext::AddThreadContext())]
: [/u01/app/goldengate/libgglog.so(CMessageFactory::CreateMessage(CSourceContext*, unsigned int, ...))]
: [/u01/app/goldengate/libgglog.so(_MSG_DateTime_String(CSourceContext*, int, timeval, char const*, CMessageFactory::MessageDisposition))]
: [/u01/app/goldengate/extract()]
: [/u01/app/goldengate/extract(RedoClassic::positionIntoRedoLogFile(int, bool, bool, bool))]
: [/u01/app/goldengate/extract(ggs::er::OraTranLogDataSource::establishStartPoint(char))]
: [/u01/app/goldengate/extract(ggs::gglib::ggapp::ReplicationContext::establishStartPoints(char, ggs::gglib::ggdatasource::DataSourceParams con
st&))]
: [/u01/app/goldengate/extract(ggs::gglib::ggapp::ReplicationContext::initializeDataSources(ggs::gglib::ggdatasource::DataSourceParams&))]
: [/u01/app/goldengate/extract()]
: [/u01/app/goldengate/extract(ggs::gglib::MultiThreading::MainThread::ExecMain())]
: [/u01/app/goldengate/extract(ggs::gglib::MultiThreading::Thread::RunThread(ggs::gglib::MultiThreading::Thread::ThreadArgs*))]
: [/u01/app/goldengate/extract(ggs::gglib::MultiThreading::MainThread::Run(int, char**))]
: [/u01/app/goldengate/extract(main)]
: [/lib64/libc.so.6(__libc_start_main)]
: [/u01/app/goldengate/extract()]
2020-06-19 22:01:13 ERROR OGG-02830 Formatting error.
2020-06-19 22:01:13 ERROR OGG-01668 PROCESS ABENDING.
Any guess on what could be the problem?
Thanks in advance,
Junqueira