请教各位大侠,小弟在配置ogg oralce 到mysql时候需要做字符转换 oracle 的us7ascii 到mysql 的utf8ogg版本
source端:
ogg for windows 32 11.2 for oracle 10g,操作系统windows server 2008 x64,数据库oracle 10g us7ascii
target端
Version 12.1.2.0.0 17185003 OGGCORE_12.1.2.0.0_PLATFORMS_130924.1316
Linux, x64, 64bit (optimized), MySQL Enterprise on Sep 24 2013 15:32:47
Operating system character set identified as UTF-8.
数据库字符集也是utf8
*******************************************************************
配置内容如下:
sourcedb ---oracle
#extinit1.prm进程:
Sourceistable
Setenv (NLS_LANG =AMERICAN_AMERICA.US7ASCII)
userid ogg@orcl ,password oracle
RMTHOST 192.168.1.189 MGRPORT 7809
RMTFILE ./dirdat/ec
table scott.emp;
table scott.dept;
#defgen文件
defsfile ./dirdef/scinit.def
userid ogg@orcl,password oracle
table scott.emp;
table scott.dept;
target----mysql
GGSCI (datacenter) 3> view param repinit1
SPECIALRUN
SETENV (NLS_LANG=AMERICAN_AMERICA.US7ASCII)
Dboptions host 127.0.0.1 ,Connectionport 3306
sourcedb sh,userid ogg ,password oracle
extfile ./dirdat/ec
SOURCEDEFS ./dirdef/scinit.def
MAP scott.emp ,TARGET sh.emp;
MAP scott.dept ,TARGET sh.dept;
**********************************************************
先在source端执行
extract paramfile dirprm\extinit1.prm reportfile dirrpt\extinit1.rpt
*****没问题并且ec已经发送到了服务器(ps:source端操作系统字符集us7ascii)
接着在target端执行(ps:target端ogg是)
./replicat paramfile dirprm/repinit1.prm
**********************************************************
报错:日志内容如下:
...省略....
***********************************************************************
** Running with the following parameters **
***********************************************************************
2014-07-01 04:17:34 INFO OGG-03059 Operating system character set identified as UTF-8.
2014-07-01 04:17:34 INFO OGG-02695 ANSI SQL parameter syntax is used for parameter parsing.
SPECIALRUN
SETENV (NLS_LANG=UTF-8)
Dboptions host 127.0.0.1 ,Connectionport 3306
Targetdb sh,userid ogg ,password **********
extfile ./dirdat/ec
SOURCEDEFS ./dirdef/scinit.def
MAP scott.emp ,TARGET sh.emp;
MAP scott.dept ,TARGET sh.dept;
2014-07-01 04:17:34 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:
/home/ogg/ggs/dirtmp.
CACHEMGR virtual memory values (may have been adjusted)
CACHESIZE: 2G
CACHEPAGEOUTSIZE (default): 8M
PROCESS VM AVAIL FROM OS (min): 4G
CACHESIZEMAX (strict force to disk): 3.41G
Database Version:
MySQL
Server Version: 5.6.17-log
Client Version: 5.6.10
Host Connection: Localhost via UNIX socket
Protocol Version: 10
Source Context :
SourceModule : [er.checkpoint]
SourceID : [/scratch/aime1/adestore/views/aime1_adc4150472/oggcore/OpenSys/src/app/er/checkpoint.cpp]
SourceFunction : [get_checkpoint_context]
SourceLine : [47]
ThreadBacktrace : [12] elements
: [/home/ogg/ggs/libgglog.so(CMessageContext::AddThreadContext()+0x26) [0x7fa327c99e36]]
: [/home/ogg/ggs/libgglog.so(CMessageFactory::CreateMessage(CSourceContext*, unsigned int, ...)+0x28f) [0x7fa327c91f8f]]
: [/home/ogg/ggs/libgglog.so(_MSG_ERR_CHECKPOINT_GENERIC(CSourceContext*, char const*, CMessageFactory::MessageDisposition)+0x42) [0x7fa327c5a622]]
: [./replicat(get_checkpoint_context(time_elt_def*, time_elt_def*)+0x7be) [0x534cee]]
: [./replicat(readCheckpoint()+0x89) [0x535149]]
: [./replicat(replicat_main(int, char**)+0x736) [0x5b86f6]]
: [./replicat(ggs::gglib::MultiThreading::MainThread::ExecMain()+0x6f) [0x70285f]]
: [./replicat(ggs::gglib::MultiThreading::Thread::RunThread(ggs::gglib::MultiThreading::Thread::ThreadArgs*)+0x11a) [0x70170a]]
: [./replicat(ggs::gglib::MultiThreading::MainThread::Run(int, char**)+0x128) [0x702c08]]
: [./replicat(main+0x4a) [0x5b701a]]
: [/lib64/libc.so.6(__libc_start_main+0xfd) [0x7fa3233c1d1d]]
: [./replicat() [0x4ae369]]
2014-07-01 04:17:34 ERROR OGG-00446 Missing filename opening checkpoint file.
2014-07-01 04:17:39 ERROR OGG-01668 PROCESS ABENDING.
*****************************************************
小弟查了半天没有弄出来是啥原因,还望各位大侠指点~
--转自