ERROR OGG-01828 Trail FORMAT RELEASE 12.1 Or Higher Is Required For Operation Extended VARCHAR2/N (Doc ID 2062020.1)

Last updated on MARCH 03, 2017

Applies to:

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

Symptoms

Extract is abending with the following;

***********************************************************************
  Oracle GoldenGate Capture for Oracle
  Version 12.1.2.1.0 OGGCORE_12.1.2.1.0_PLATFORMS_140727.2135.1_FBO
  Linux, x64, 64bit (optimized), Oracle 12c on Aug 7 2014 10:40:21

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


  Starting at 2015-08-14 23:02:48
***********************************************************************

Operating System Version:
Linux
Version #1 SMP Sun Nov 10 22:19:54 EST 2013, Release 2.6.32-431.el6.x86_64
Node: prdsecjmsdb03
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: 7238

Description:

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

2015-08-14 23:02:48 INFO OGG-03059 Operating system character set identified as UTF-8.

2015-08-14 23:02:48 INFO OGG-02695 ANSI SQL parameter syntax is used for parameter parsing.
EXTRACT EXT_ST
userid c##gg_user@stp.world password ***********

2015-08-14 23:02:48 INFO OGG-03522 Setting session time zone to source database time zone 'GMT'.
TRANLOGOPTIONS INTEGRATEDPARAMS (MAX_SGA_SIZE 200)
DDL INCLUDE MAPPED
DDLOPTIONS REPORT
TRANLOGOPTIONS _CONVERTBADNUMBER ZERO
TRANLOGOPTIONS _INFINITYTOZERO
EXTTRAIL ./dirdat/st, format release 11.2
DISCARDFILE ./dirrpt/ext_st.dsc, append
REPORTCOUNT EVERY 15 MINUTES, RATE
SOURCECATALOG AUDSTP
table STPMD.*;

2015-08-14 23:02:48 INFO OGG-02623 Default source catalog name AUDSTP will be used for source table name STPMD.* mapping.

2015-08-14 23:02:48 INFO OGG-02642 Trail file ./dirdat/st format does not support catalog names. The catalog name of the source table AUDSTP.STPMD.* specified in TABLE clause 'table STPMD.*' will be removed.
table STPTRADE.*;

2015-08-14 23:02:48 INFO OGG-02623 Default source catalog name AUDSTP will be used for source table name STPTRADE.* mapping.

2015-08-14 23:02:48 INFO OGG-02642 Trail file ./dirdat/st format does not support catalog names. The catalog name of the source table AUDSTP.STPTRADE.* specified in TABLE clause 'table STPTRADE.*' will be removed.

2015-08-14 23:02:48 INFO OGG-01635 BOUNDED RECOVERY: reset to initial or altered checkpoint.

2015-08-14 23:02: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:
  /u02/OGG12/bin/BR/EXT_ST.

Bounded Recovery Parameter:
BRINTERVAL = 4HOURS
BRDIR = /u02/OGG12/bin

2015-08-14 23:02:48 INFO OGG-01851 filecaching started: thread ID: 140287087208192.

2015-08-14 23:02:49 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:
  /u02/OGG12/bin/dirtmp.

CACHEMGR virtual memory values (may have been adjusted)
CACHESIZE: 64G
CACHEPAGEOUTSIZE (default): 8M
PROCESS VM AVAIL FROM OS (min): 128G
CACHESIZEMAX (strict force to disk): 96G

Database Version:
Oracle Database 12c Enterprise Edition Release 12.1.0.2.0 - 64bit Production
PL/SQL Release 12.1.0.2.0 - Production
CORE 12.1.0.2.0 Production
TNS for Linux: Version 12.1.0.2.0 - Production
NLSRTL Version 12.1.0.2.0 - Production

Database Language and Character Set:
NLS_LANGUAGE = "AMERICAN"
NLS_TERRITORY = "AMERICA"
NLS_CHARACTERSET = "AL32UTF8"

2015-08-14 23:02:49 INFO OGG-06495 OGG created a session pool with SESSIONPOOLMAX 10, SESSIONPOOLMIN 2 and SESSIONPOOLINCR 2.

2015-08-14 23:02:49 INFO OGG-02089 Source redo compatibility version is: 12.1.0.2.

2015-08-14 23:03:02 INFO OGG-02068 Integrated capture successfully attached to logmining server OGG$CAP_EXT_ST using OGGCapture API.

2015-08-14 23:03:02 INFO OGG-02086 Integrated Dictionary will be used.

2015-08-14 23:03:02 INFO OGG-01052 No recovery is required for target file ./dirdat/st000000, at RBA 0 (file not opened).

2015-08-14 23:03:02 INFO OGG-01478 Output file ./dirdat/st is using format RELEASE 11.2.

***********************************************************************
** Run Time Messages **
***********************************************************************


2015-08-14 23:03:02 INFO OGG-03522 Setting session time zone to source database time zone 'GMT'.

2015-08-14 23:03:15 INFO OGG-06508 Wildcard MAPTABLE resolved (entry AUDSTP.STPTRADE.*): table "AUDSTP"."STPTRADE"."QUICKFIX_MESSAGES".

2015-08-14 23:03:15 INFO OGG-06509 Using the following key columns for source table AUDSTP.STPTRADE.QUICKFIX_MESSAGES: BEGINSTRING, SENDERCOMPID, SENDERSUBID, SENDERLOCID, TARGETCOMPID, TARGETSUBID, TARGETLOCID, SESSION_QUALIFIER, MSGSEQNUM.

Source Context :
 SourceModule : [er.redo.oraxo]
 SourceID : [/scratch/aime1/adestore/views/aime1_adc4150384/oggcore/OpenSys/src/app/er/redo/oracle/redooraix.c]
 SourceFunction : [REDOORAIX_format_onecol]
 SourceLine : [6564]
 ThreadBacktrace : [15] elements
  : [/u02/OGG12/bin/libgglog.so(CMessageContext::AddThreadContext()+0x1e) [0x7f973ab05dae]]
  : [/u02/OGG12/bin/libgglog.so(CMessageFactory::CreateMessage(CSourceContext*, unsigned int, ...)+0x340) [0x7f973ab00ac0]]
  : [/u02/OGG12/bin/libgglog.so(_MSG_ERR_OPERATION_INCOMPATIBLE_WITH_TRAIL_FORMAT_RELEASE(CSourceContext*, char const*, char const*, CMessageFactory::MessageDisposition)+0x3d) [0x7f973aad9fff]]
  : [/u02/OGG12/bin/extract(REDOORAIX_format_onecol(file_def*, xout_com_header_t*, unsigned char, xout_rowcol_info_t*, unsigned short, unsigned int, char*, int*, char*, short*, char (&) [2048])+0x5f0) [0x7fb400]]
  : [/u02/OGG12/bin/extract(REDOORAIX_format_rowinfo(log_context_t*, xout_com_header_t*, file_def*, objectpool*, xout_rowcol_info_t*, xout_rowcol_info_t*, unsigned int, char*, int*, char*, short*, char (&) [2048])+0x1155) [0x809215]]
  : [/u02/OGG12/bin/extract(REDOORAIX_format_lcr(objectpool*, file_def*, unsigned int, char*, char*, int*, char*, short*, log_context_t*, char (&) [2048])+0x331) [0x81a941]]
  : [/u02/OGG12/bin/extract(REDO_format_record(char, file_def*, char*, unsigned int, char*, short*, char*, int*)+0x105) [0x750ce5]]
  : [/u02/OGG12/bin/extract(process_extract_loop()+0xf46) [0x5c23e6]]
  : [/u02/OGG12/bin/extract(extract_main(int, char**)+0x418) [0x5c0098]]
  : [/u02/OGG12/bin/extract(ggs::gglib::MultiThreading::MainThread::ExecMain()+0x4f) [0x6ab4df]]
  : [/u02/OGG12/bin/extract(ggs::gglib::MultiThreading::Thread::RunThread(ggs::gglib::MultiThreading::Thread::ThreadArgs*)+0x104) [0x6ab9e4]]
  : [/u02/OGG12/bin/extract(ggs::gglib::MultiThreading::MainThread::Run(int, char**)+0x8b) [0x6abdab]]
  : [/u02/OGG12/bin/extract(main+0x3f) [0x5bfa2f]]
  : [/lib64/libc.so.6(__libc_start_main+0xfd) [0x3f05c1ed1d]]
  : [/u02/OGG12/bin/extract() [0x534319]]

2015-08-14 23:03:15 ERROR OGG-01828 Trail FORMAT RELEASE 12.1 or higher is required for operation extended VARCHAR2/NVARCHAR2/RAW column.

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