ogg oracle到mysql_用ogg实现oracle同步到mysql的问题

在oracle向mysql初始化过程中出现报错，如下：

GGSCI (source.db) 9> start eini

Sending START request to MANAGER ...

EXTRACT EINI starting

GGSCI (source.db) 10> view report eini

2013-11-30 17:54:37  INFO    OGG-01017  Wildcard resolution set to IMMEDIATE because SOURCEISTABLE i

s used.

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

Oracle GoldenGate Capture for Oracle

Version 11.2.1.0.1 OGGCORE_11.2.1.0.1_PLATFORMS_120423.0230_FBO

Linux, x64, 64bit (optimized), Oracle 10g on Apr 23 2012 07:44:10

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

Starting at 2013-11-30 17:54:37

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

Operating System Version:

Linux

Version #1 SMP Tue Aug 18 15:51:48 EDT 2009, Release 2.6.18-164.el5

Node: source.db

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

Description:

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

**            Running with the following parameters                  **

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

2013-11-30 17:54:37  INFO    OGG-03035  Operating system character set identified as US-ASCII. Local

e: en_US, LC_ALL:.

extract eini

userid ggm,password ******

2013-11-30 17:54:37  INFO    OGG-03500  WARNING: NLS_LANG environment variable does not match databa

se character set, or not set. Using database character set value of WE8ISO8859P1.

rmthost target,mgrport 7900

rmttask replicat,group rini

table scott.*;

Wildcard TABLE resolved (entry scott.*):

table "SCOTT"."BONUS";

2013-11-30 17:54:37  WARNING OGG-00869  No unique key is defined for table 'BONUS'. All viable colum

ns will be used to represent the key, but may not guarantee uniqueness.  KEYCOLS may be used to defi

ne the key.

Using the following key columns for source table SCOTT.BONUS: ENAME, JOB, SAL, COMM.

Wildcard TABLE resolved (entry scott.*):

table "SCOTT"."DEPT";

Using the following key columns for source table SCOTT.DEPT: DEPTNO.

Wildcard TABLE resolved (entry scott.*):

table "SCOTT"."EMP";

Using the following key columns for source table SCOTT.EMP: EMPNO.

Wildcard TABLE resolved (entry scott.*):

table "SCOTT"."SALGRADE";

2013-11-30 17:54:37  WARNING OGG-00869  No unique key is defined for table 'SALGRADE'. All viable co

lumns will be used to represent the key, but may not guarantee uniqueness.  KEYCOLS may be used to d

efine the key.

Using the following key columns for source table SCOTT.SALGRADE: GRADE, LOSAL, HISAL.

2013-11-30 17:54:37  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:

/oracleogg/dirtmp.

CACHEMGR virtual memory values (may have been adjusted)

CACHESIZE:                               64G

CACHEPAGEOUTSIZE (normal):                8M

PROCESS VM AVAIL FROM OS (min):         128G

CACHESIZEMAX (strict force to disk):     96G

Database Version:

Oracle Database 10g Enterprise Edition Release 10.2.0.1.0 - 64bi

PL/SQL Release 10.2.0.1.0 - Production

CORE        10.2.0.1.0        Production

TNS for Linux: Version 10.2.0.1.0 - Production

NLSRTL Version 10.2.0.1.0 - Production

Database Language and Character Set:

NLS_LANG         = ".WE8ISO8859P1"

NLS_LANGUAGE     = "AMERICAN"

NLS_TERRITORY    = "AMERICA"

NLS_CHARACTERSET = "WE8ISO8859P1"

Processing table SCOTT.BONUS

Processing table SCOTT.DEPT

2013-11-30 17:54:43  WARNING OGG-01194  EXTRACT task RINI abended : Failed to validate table name  (

dept) in Database (sttt). SQL error (0).

Source Context :

SourceModule            : [er.idlx]

SourceID                : [/scratch/aime1/adestore/views/aime1_adc4150256/oggcore/OpenSys/src/app/

er/idlx.c]

SourceFunction          : [IDLX_complete_tcp_msg]

SourceLine              : [383]

ThreadBacktrace         : [11] elements

: [/oracleogg/libgglog.so(CMessageContext::AddThreadContext()+0x1e) [0x2af

cab5067de]]

: [/oracleogg/libgglog.so(CMessageFactory::CreateMessage(CSourceContext*,

unsigned int, ...)+0x2cc) [0x2afcab502c7c]]

: [/oracleogg/libgglog.so(_MSG_ERR_IDLX_EXTRACT_ABENDING(CSourceContext*,

CMessageFactory::MessageDisposition)+0x2c) [0x2afcab4e831c]]

: [/oracleogg/extract(IDLX_complete_tcp_msg+0x2a4) [0x51d56a]]

: [/oracleogg/extract(complete_tcp_msg(extract_def*)+0x5f) [0x511787]]

: [/oracleogg/extract(flush_tcp(extract_def*, int)+0x6d) [0x512261]]

: [/oracleogg/extract(flush_buffers(int)+0x66) [0x50bf86]]

: [/oracleogg/extract(process_source_files()+0x652) [0x569ac0]]

: [/oracleogg/extract(main+0x644) [0x56b4d4]]

: [/lib64/libc.so.6(__libc_start_main+0xf4) [0x306841d994]]

: [/oracleogg/extract(__gxx_personality_v0+0x382) [0x4e754a]]

2013-11-30 17:54:43  ERROR   OGG-01203  EXTRACT abending.

2013-11-30 17:54:43  ERROR   OGG-01668  PROCESS ABENDING.

配置文件如下：

抽取进程

extract eini

userid ggm,password oracle

rmthost target,mgrport 7900

rmttask replicat,group rini

table scott.*;

恢复进程

replicat rini

sourcedb sttt@target userid sttt,password oracle

sourcedefs ./dirdef/oratomy.def

discardfile ./dirrpt/rini.dsc,append,megabytes 100

map SCOTT.DEPT, target sttt.dept;

map SCOTT.EMP, target sttt.emp;

map SCOTT.BONUS, target sttt.bonus;

map SCOTT.SALGRADE, target sttt.salgrade;

请问是什么问题？