報錯信息是在目標端(mysql)
源端是sqlserver
ogg版本信息:
sqlserver哪個版本好用、Oracle GoldenGate V11.1.1.1.1 for MySQL 5.x on Linux x86
復制進程配置:
GGSCI (php238) 77> edit params rmysql
replicat rmysql
oracle ogg、setenv(NLS_LANG="AMERICAN_AMERICA.ZHS16GBK")
TARGETDB cmc@XX.XX.XX.XX:3306,userid root,password 123
assumetargetdefs
sourcedefs ./dirdef/dog.def
sqlserver新建用戶,reperror default,discard
discardfile ./dirrpt/rmysql.dsc
dynamicresolution
MAP dbo.dog,TARGET cmc.c_dogs colmap(usedefaults,is_sale = "0");
navicat連接oracle數據庫報錯,report 報錯信息:
GGSCI (php238) 81> view report rmysql
***********************************************************************
Oracle GoldenGate Delivery for MySQL
sql和oracle的區別。Version 11.1.1.1.1 OGGCORE_11.1.1.1.1_PLATFORMS_110729.1700
Linux, x86, 32bit (optimized), MySQL Enterprise on Jul 29 2011 23:02:35
Copyright (C) 1995, 2011, Oracle and/or its affiliates. All rights reserved.
Starting at 2015-05-13 12:04:43
sql server服務器名稱?***********************************************************************
Operating System Version:
Linux
Version #1 SMP Fri Jun 22 10:59:55 UTC 2012, Release 2.6.32-279.el6.i686
sql server有什么用?Node: php238
Machine: i686
soft limit? ?hard limit
Address Space Size? ?:? ? unlimited? ? unlimited
jdbc begin transaction failed、Heap Size? ?? ?? ?? ?:? ? unlimited? ? unlimited
File Size? ?? ?? ?? ?:? ? unlimited? ? unlimited
CPU Time? ?? ?? ?? ? :? ? unlimited? ? unlimited
Process id: 10515
sqlserver數據庫,Description:
***********************************************************************
**? ?? ?? ?? ?Running with the following parameters? ?? ?? ?? ?? ?? ?**
***********************************************************************
replicat rmysql
setenv(NLS_LANG="AMERICAN_AMERICA.ZHS16GBK")
Source Context :
SourceModule? ?? ?? ?? ?: [er.main]
SourceID? ?? ?? ?? ?? ? : [/net/ap1012nap-vlan900/vol/ifarm_ports/ifarm_views/aime_oggcore_6757/oggcore/OpenSys/src/app/er/rep.c]
SourceFunction? ?? ?? ? : [get_infile_params]
SourceLine? ?? ?? ?? ???: [10940]
ThreadBacktrace? ?? ?? ?: [7] elements
: [/usr/local/ggs/replicat(CMessageContext::AddThreadContext()+0x26) [0x8359cf6]]
: [/usr/local/ggs/replicat(CMessageFactory::CreateMessage(CSourceContext*, unsigned int, ...)+0x817) [0x8350477]]
: [/usr/local/ggs/replicat(_MSG_ERR_STARTUP_BADARG_ARGUMENT_TOO_LONG(CSourceContext*, CMessageFactory::MessageDisposition)+0x7e) [0x8304f2e]]
: [/usr/local/ggs/replicat() [0x819a314]]
: [/usr/local/ggs/replicat(main+0x245) [0x81b1d55]]
: [/lib/libc.so.6(__libc_start_main+0xe6) [0x69dd36]]
: [/usr/local/ggs/replicat(__gxx_personality_v0+0x169) [0x812d301]]
2015-05-13 12:04:43??ERROR? ?OGG-00395??Argument is too long.
2015-05-13 12:04:43??ERROR? ?OGG-01668??PROCESS ABENDING.
版权声明:本站所有资料均为网友推荐收集整理而来,仅供学习和研究交流使用。
工作时间:8:00-18:00
客服电话
电子邮件
admin@qq.com
扫码二维码
获取最新动态