OGG-02028 Failed to attach to logmining server Error code 14097, error message: ORA-14097: column type or size mismatch (Doc ID 2196368.1)

Last updated on JULY 17, 2017

Applies to:

Oracle GoldenGate - Version 12.2.0.1.0 and later
Information in this document applies to any platform.

Symptoms

2016-10-09 02:35:20 ERROR OGG-02028 Oracle GoldenGate Capture for Oracle, ep1v2.prm: Failed to attach to logmining server Error code 14097, error message: ORA-14097: column type or size mismatch

Changes

 +++++++++++++++++++++++++++ Report file of extract +++++++++++++++++++++++++++++++++++++++++++

***********************************************************************
Oracle GoldenGate Capture for Oracle
Version 12.2.0.1.1 OGGCORE_12.2.0.1.0_PLATFORMS_151211.1401_FBO
AIX 6, ppc, 64bit (optimized), Oracle 12c on Jan 22 2016 01:26:58

Copyright (C) 1995, 2015, Oracle and/or its affiliates. All rights reserved.

Starting at 2016-10-10 15:02:48
***********************************************************************

Operating System Version:
AIX
Version 7, Release 1
Node: RMUBBPORA0007
Machine: 00F98ECE4C00
soft limit hard limit
Address Space Size : unlimited unlimited
Heap Size : unlimited unlimited
File Size : unlimited unlimited
CPU Time : unlimited unlimited

Process id: 63046138

Description:

***********************************************************************
** Running with the following parameters **
***********************************************************************

2016-10-10 15:02:48 INFO OGG-03059 Operating system character set identified as ISO-8859-1.

2016-10-10 15:02:48 INFO OGG-02695 ANSI SQL parameter syntax is used for parameter parsing.
EXTRACT ep1v2
TRANLOGOPTIONS USE_ROOT_CONTAINER_TIMEZONE
useridalias c##oggadm@cpoisep

2016-10-10 15:02:49 INFO OGG-03522 Setting session time zone to source database time zone 'GMT'.
REPORTCOUNT EVERY 5 MINUTES, RATE
FETCHOPTIONS, NOUSESNAPSHOT, NOUSELATESTVERSION, MISSINGROW REPORT
STATOPTIONS REPORTFETCH
LOGALLSUPCOLS

2016-10-10 15:02:49 WARNING OGG-04033 LOGALLSUPCOLS has set the NOCOMPRESSDELETES and GETUPDATEBEFORES parameters on.
NOCOMPRESSUPDATES
GETUPDATEBEFORES
IGNOREDELETES
exttrail ./dirdat/l1
SOURCECATALOG ppoisep
TABLE <schema>.<table_name>

Cause

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms