GoldenGateOGG-01163 问题处理
一、背景
近来计量中心项目管理测试环境 GoldenGate 同步配置针对部分表的同步持续不断地报 OGG-01163 错误,导致涉及部分表同步的所有 Replicat 进程 Abended ,使GoldenGate停止工作。出现该问题的 Table 的结构完全一致,出现问题后,无法正常启动 Replicat 进 程。
二、问题分析
Source 和 Target 数据库版本:11.2.0.3.0
SQL> select * from v$version;
BANNER
--------------------------------------------------------------------------------
Oracle Database 11g Enterprise EditionRelease11.2.0.1.0 - 64bit Production
PL/SQL Release 11.2.0.3.0 - Production
CORE 11.2.0.3.0 Production
TNS for IBM/AIX RISC System/6000: Version11.2.0.3.0 -Production
NLSRTL Version 11.2.0.3.0 - Production
Source 和 Target 的GoldenGate 版本:
$ ggsci -v
Oracle GoldenGate Command Interpreter forOracle
Version 11.2.1.0.13_0213878881OGGCORE_11.2.1.0.4_PLATFORMS_120323.1345
AIX 5L, ppc, 64bit (optimized), Oracle 11gon Mar 232012 17:01:26
Copyright (C) 1995, 2012, Oracle and/or itsaffiliates.All rights reserved.
实际环境的GoldenGate报错信息如下:
HX_DJ.DJ_DJHZDYLBSZ 表
Using the following key columns for targettableHX_DJ.DJ_DJHZDYLBSZ: LB_DM.
Source Context :
SourceModule :[ggstd.conv.endian]
SourceID :[/scratch/aime1/adestore/views/aime1_staxk11/oggcore/OpenSys/src/gglib/ggstd/lecnv.c]
SourceFunction :[convCompSQL(char *, file_def *,rowlen_t)]
SourceLine : [591]
2012-10-25 10:05:08 ERROR OGG-01163 Bad column length (13) specified for columnLRR_DM in tableHX_DJ.DJ_DJHZDYLBSZ, maximum allowable length is 11.
HX_RD.RD_YBNSRFDQGL_RDB 表
Using the following key columns for targettableHX_RD.RD_YBNSRFDQGL_RDB: RDPZUUID.
Source Context :
SourceModule :[ggstd.conv.endian]
SourceID :[/scratch/aime1/adestore/views/aime1_staxj16/oggcore/OpenSys/src/gglib/ggstd/lecnv.c]
SourceFunction :[convCompSQL(char *, file_def *,rowlen_t)]
SourceLine : [591]
2012-10-26 09:17:06 ERROR OGG-01163 Bad column length (7) specified for columnSJGSDQ in tableHX_RD.RD_YBNSRFDQGL_RDB, maximum
allowable length is 5.
HX_RD.RD_NSSBFSRDJBGB 表
Using the following key columns for targettableHX_RD.RD_NSSBFSRDJBGB: RDPZUUID.
Source Context :
SourceModule :[ggstd.conv.endian]
SourceID :[/scratch/aime1/adestore/views/aime1_staxk11/oggcore/OpenSys/src/gglib/ggstd/lecnv.c]
SourceFunction :[convCompSQL(char *, file_def *,rowlen_t)]
SourceLine : [591]
2012-10-26 09:39:35 ERROR OGG-01163 Bad column length (7) specified for columnSJGSDQ in tableHX_RD.RD_NSSBFSRDJBGB, maximumal
lowable length is 5.
HX_ZSJ.T_XT_HCBXX 表
Using the following key columns for targettableHX_ZSJ.T_XT_HCBXX: TABLE_NAME.
Source Context :
SourceModule :[ggstd.conv.endian]
SourceID :[/scratch/aime1/adestore/views/aime1_staxk11/oggcore/OpenSys/src/gglib/ggstd/lecnv.c]
SourceFunction :[convCompSQL(char *, file_def *,rowlen_t)]
SourceLine : [591]
2012-10-16 23:49:10 ERROR OGG-01163 Bad column length (3) specified for columnQUERY_FROM_DB in tableHX_ZSJ.T_XT_HCBXX, maximum allowable length is 1.
全功能环境配置如下:
Source 和 Target 的OS 版本:AIX 6100
# oslevel
6.1.0.0
# oslevel -r
6100-07
Source 和 Target 数据库版本:11.2.0.1.0
SQL> select * from v$version;
BANNER
--------------------------------------------------------------------------------
Oracle Database 11g Enterprise EditionRelease11.2.0.1.0 - 64bit Productio