ogg 登录mysql报字符集_GOLDENGATE ORACLE TO MYSQL 字符集出错

_________________________________________________ogg mysql端配置______________________________________

GGSCI (datacenter) 1> view param repinit1

SETENV (NLS_LANG=AMERICAN_AMERICA.US7ASCII)

SPECIALRUN

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;

执行replicat命令：

[ogg@datacenter ggs]$ ./replicat paramfile dirprm/repinit1.prm reportfile dirrpt/repinit1.rpt

_______________________________________________日志信息__________________________________________________________________

2014-07-01 07:13:06  INFO    OGG-02095  Successfully set environment variable NLS_LANG=AMERICAN_AMERICA.US7ASCII.

***********************************************************************

Oracle GoldenGate Delivery for MySQL

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 16:30:39

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

Starting at 2014-07-01 07:13:06

***********************************************************************

Operating System Version:

Linux

Version #1 SMP Fri Nov 22 03:15:09 UTC 2013, Release 2.6.32-431.el6.x86_64

Node: datacenter

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: 1436

Description:

***********************************************************************

**            Running with the following parameters                  **

***********************************************************************

2014-07-01 07:13:06  INFO    OGG-03059  Operating system character set identified as UTF-8.

2014-07-01 07:13:06  INFO    OGG-02695  ANSI SQL parameter syntax is used for parameter parsing.

SETENV (NLS_LANG=AMERICAN_AMERICA.US7ASCII)

SPECIALRUN

Dboptions host 127.0.0.1 ,Connectionport 3306

sourcedb 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 07:13:06  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

Opened trail file ./dirdat/ec at 2014-07-01 07:13:06

2014-07-01 07:13:06  INFO    OGG-01014  Positioning with begin time: 1970-1-1 ?

?午12:00:00, starting record time: 2014-7-1 上午7:12:53 at extrba 964.

2014-07-01 07:13:06  INFO    OGG-03506  The source database character set, as determined from the trail file, is us7ascii.

***********************************************************************

**                     Run Time Messages                             **

***********************************************************************

Opened trail file ./dirdat/ec at 2014-07-01 07:13:06

MAP resolved (entry scott.emp):

MAP "SCOTT"."EMP" ,TARGET "sh"."EMP";

Using following columns in default map by name:

EMPNO, ENAME, JOB, MGR, HIREDATE, SAL, COMM, DEPTNO

Using the following key columns for target table sh.EMP: EMPNO, ENAME, JOB, MGR, HIREDATE, SAL, COMM, DEPTNO.

2014-07-01 07:13:06  INFO    OGG-03010  Performing implicit conversion of column data from character set us7ascii to windows-936.

MAP resolved (entry scott.dept):

MAP "SCOTT"."DEPT" ,TARGET "sh"."DEPT";

Using following columns in default map by name:

DEPTNO, DNAME, LOC, TEST1, TEST2

Using the following key columns for target table sh.DEPT: DEPTNO, DNAME, LOC, TEST1, TEST2.

Source Context :

SourceModule            : [ggapp.csconv]

SourceID                : [/scratch/aime1/adestore/views/aime1_adc4150472/oggcore/OpenSys/src/gglib/ggapp/csconv.cpp]

SourceFunction          : [conversion_error_handler]

SourceLine              : [634]

ThreadBacktrace         : [15] elements

: [/home/ogg/ggs/libgglog.so(CMessageContext::AddThreadContext()+0x26) [0x7f87e9a04e36]]

: [/home/ogg/ggs/libgglog.so(CMessageFactory::CreateMessage(CSourceContext*, unsigned int, ...)+0x28f) [0x7f87e99fcf8f]]

: [/home/ogg/ggs/libgglog.so(_MSG_ERR_COLUMN_CHARSET_CONVERSION_CSTOCS(CSourceContext*, char const*, char const*, char const*, char const*, CMessageFactory::MessageDisposition)+0x64) [0x7f87e99a48d4]]

: [./replicat(CSCONV_convert(short, col_def const*, ULibCharSet, short, col_def*, ULibCharSet, char*, char*, col_def*, bool)+0x1c0) [0x5f6dc0]]

: [./replicat(map_columns_int(char*, char*, int, int*, map_col_def*, unsigned char*, file_def*, file_def*, __std_rec_hdr*, short, short*, short*, short, short, extr_ptr_def*, bool, bool)+0xe5d) [0x600c5d]]

: [./replicat(map_columns(char*, char*, int, int*, map_col_def*, unsigned char*, file_def*, file_def*, __std_rec_hdr*, short, short*, short*, short, short, short*, int, extr_ptr_def*)+0x128) [0x601578]]

: [./replicat(replicate_io(file_def*, __std_rec_hdr*, char*, extr_ptr_def*, int*, int)+0x462) [0x5763b2]]

: [./replicat(process_extract_loop()+0x5576) [0x5724d6]]

: [./replicat(replicat_main(int, char**)+0x360) [0x5b8320]]

: [./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) [0x7f87e512cd1d]]

: [./replicat() [0x4ae369]]

2014-07-01 07:13:06  ERROR   OGG-03517  Conversion from character set us7ascii of source column DNAME to character set windows-936 of target column DNAME failed because the source column contains a character that is not available in the target character set.