ogg mysql 初始化_goldengate Oracle到mysql 复制，初始化时的配置
源库 oralce
配置了2个参数
GGSCI (johnnytest.99bill.com) 6> view params mgr
port 7809
GGSCI (johnnytest.99bill.com) 8> view params ormy
EXTRACT ormy
USERID gg, PASSWORD gg
RMTHOST 192.168.6.97, MGRPORT 7809
RMTTASK replicat, GROUP rep99
TABLE seashell.testgg;
GGSCI (johnnytest.99bill.com) 2> dblogin userid gg,password gg
Successfully logged into database.
GGSCI (johnnytest.99bill.com) 3> add trandata seashell.testgg
Logging of supplemental redo data enabled for table SEASHELL.TESTGG.
目标库 mysql
GGSCI (gridsrv.99bill.com) 9> view params rep99
REPLICAT rep99
SOURCEDB seashell USERID root,PASSWORD root
assumetargetdefs
reperror default, discard
discardfile /u02/ggmysql/ggabc/repsz.dsc,append,megabytes 100
MAP seashell.testgg, TARGET "seashell.testgg";
GGSCI (gridsrv.99bill.com) 10> view params mgr
port 7809
mysql 端也看不出问题，mysql 的登陆了也没有问题。
GGSCI (gridsrv.99bill.com) 11> dblogin SOURCEDB seashell USERID root,PASSWORD root
Successfully logged into database.
但是在源库
GGSCI (johnnytest.99bill.com) 4> start ormy
Sending START request to MANAGER ...
EXTRACT ORMY starting
源库的日志也没有问题，提示有9999条数据已经发送
在mysql端，确看不到数据
错误日志没有任何有价值的信息
oracle 的report
GGSCI (johnnytest.99bill.com) 5> view report ormy
2010-11-25 09:02:28 INFO OGG-01017 Wildcard resolution set to IMMEDIATE because SOURCEISTABLE is used.
***********************************************************************
Oracle GoldenGate Capture for Oracle
Version 11.1.1.0.0 Build 078
Linux, x64, 64bit (optimized), Oracle 10 on Jul 28 2010 15:39:00
Copyright (C) 1995, 2010, Oracle and/or its affiliates. All rights reserved.
Starting at 2010-11-25 09:02:28
***********************************************************************
Operating System Version:
Linux
Version #1 SMP Wed Nov 7 13:56:44 EST 2007, Release 2.6.9-67.ELsmp
Node: johnnytest.99bill.com
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: 3782
Description:
***********************************************************************
** Running with the following parameters **
***********************************************************************
EXTRACT ormy
USERID gg, PASSWORD **
RMTHOST 192.168.6.97, MGRPORT 7809
RMTTASK replicat, GROUP rep99
TABLE seashell.testgg;
Using the following key columns for source table SEASHELL.TESTGG: ID.
CACHEMGR virtual memory values (may have been adjusted)
CACHEBUFFERSIZE: 64K
CACHESIZE: 8G
CACHEBUFFERSIZE (soft max): 4M
CACHEPAGEOUTSIZE (normal): 4M
PROCESS VM AVAIL FROM OS (min): 16G
CACHESIZEMAX (strict force to disk): 13.99G
...skipping one line
Oracle Database 10g Enterprise Edition Release 10.2.0.4.0 - 64bi
PL/SQL Release 10.2.0.4.0 - Production
CORE 10.2.0.4.0 Production
TNS for Linux: Version 10.2.0.4.0 - Production
NLSRTL Version 10.2.0.4.0 - Production
Database Language and Character Set:
NLS_LANG = "AMERICAN_AMERICA.AL32UTF8"
NLS_LANGUAGE = "AMERICAN"
NLS_TERRITORY = "AMERICA"
NLS_CHARACTERSET = "AL32UTF8"
Processing table SEASHELL.TESTGG
***********************************************************************
* ** Run Time Statistics ** *
***********************************************************************
Report at 2010-11-25 09:02:34 (activity since 2010-11-25 09:02:29)
Output to rep99:
From Table SEASHELL.TESTGG:
# inserts: 9999
# updates: 0
# deletes: 0
# discards: 0
=======================================================================================================
======================================================================================================
======================================================================================================
======================================================================================================
mysql的report
GGSCI (gridsrv.99bill.com) 8> view report rep99
***********************************************************************
Oracle GoldenGate Delivery for MySQL
Version 11.1.1.0.3 Build 001
Linux, x64, 64bit (optimized), MySQL Enterprise on Sep 29 2010 12:18:50
Copyright (C) 1995, 2010, Oracle and/or its affiliates. All rights reserved.
Starting at 2010-11-25 09:02:28
***********************************************************************
Operating System Version:
Linux
Version #1 SMP Tue Aug 18 15:51:48 EDT 2009, Release 2.6.18-164.el5
Node: gridsrv.99bill.com
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: 32645
Description:
***********************************************************************
** Running with the following parameters **
***********************************************************************
REPLICAT rep99
SOURCEDB seashell USERID root,PASSWORD ****
assumetargetdefs
reperror default, discard
discardfile /u02/ggmysql/ggabc/repsz.dsc,append,megabytes 100
MAP seashell.testgg, TARGET "seashell.testgg";
CACHEMGR virtual memory values (may have been adjusted)
CACHEBUFFERSIZE: 64K
CACHESIZE: 512M
CACHEBUFFERSIZE (soft max): 4M
CACHEPAGEOUTSIZE (normal): 4M
PROCESS VM AVAIL FROM OS (min): 1G
CACHESIZEMAX (strict force to disk): 881M
Database Version:
MySQL
Server Version: 5.1.41-community-log
Client Version: 6.0.0
Host Connection: Localhost via UNIX socket
Protocol Version: 10
***********************************************************************
** Run Time Messages **
***********************************************************************
***********************************************************************
* ** Run Time Statistics ** *
***********************************************************************
Report at 2010-11-25 09:02:39 (activity since 2010-11-25 09:02:28)
No records were replicated.
CACHE OBJECT MANAGER statistics
CACHE MANAGER VM USAGE
vm current = 0 vm anon queues = 0
vm anon in use = 0 vm file = 0
...skipping one line
CACHE CONFIGURATION
cache size = 512M cache force paging = 881M
buffer min = 64K buffer highwater = 4M
pageout eligible size = 4M
CACHE Transaction Stats
trans active = 0 max concurrent = 0
non-zero total = 0 trans total = 0
CACHE File Caching
disk current = 0 disk total = 0
disk caching = 0 file cached = 0
file retrieves = 0
CACHE MANAGEMENT
buffer links = 0 anon gets = 0
forced unmaps = 0 cnnbl try = 0
cached out = 0 force out = 0
Allocation Request Distribution
< 128B: 0
128B: 0 0 | 512B: 0 0
2K: 0 0 | 8K: 0 0
32K: 0 0 | 128K: 0 0
512K: 0 0 | 2M: 0 0
8M: 0 0 | 32M: 0 0
128M: 0 0 | 512M: 0 0
2G: 0 0 | 8G: 0
Cached Transaction Size Distribution
0: 0
< 4K: 0
4K: 0 0 | 16K: 0 0
64K: 0 0 | 256K: 0 0
1M: 0 0 | 4M: 0 0
16M: 0 0 | 64M: 0 0
256M: 0 0 | 1G: 0 0
4G: 0 0 | 16G: 0 0
64G: 0 0 | 256G: 0 0
1T: 0 0 | 4T: 0 0
16T: 0 0 | 64T: 0 0
256T: 0 0 |1024T: 0 0
QUEUE Statistics:
num queues = 15 default index = 0
cur len = 0 max len = 0
...skipping one line
q hits = 0 q misses = 0
queue size q hits curlen maxlen cannibalized
0 64K 0 0 0 0
1 128K 0 0 0 0
2 256K 0 0 0 0
3 512K 0 0 0 0
4 1M 0 0 0 0
5 2M 0 0 0 0
6 4M 0 0 0 0
7 8M 0 0 0 0
8 16M 0 0 0 0
9 32M 0 0 0 0
10 64M 0 0 0 0
11 128M 0 0 0 0
12 256M 0 0 0 0
13 512M 0 0 0 0
14 1G 0 0 0 0
================================================================================
CACHE POOL #0
POOL INFO group: rep99 id: p32645_BLOB
trans active = 0 trans concurrent (max) = 0
trans total = 0 (0 )
flag = 0x00000000
last error = (0=)
Allocation Request Distribution
< 128B: 0
128B: 0 0 | 512B: 0 0
2K: 0 0 | 8K: 0 0
32K: 0 0 | 128K: 0 0
512K: 0 0 | 2M: 0 0
8M: 0 0 | 32M: 0 0
128M: 0 0 | 512M: 0 0
2G: 0 0 | 8G: 0
QUEUE Statistics:
num queues = 15 default index = 0
cur len = 0 max len = 0
q vm current = 0 vm max = 0
q hits = 0 q misses = 0
queue size q hits curlen maxlen cannibalized
0 64K 0 0 0 0
1 128K 0 0 0 0
2 256K 0 0 0 0
...skipping one line
4 1M 0 0 0 0
5 2M 0 0 0 0
6 4M 0 0 0 0
7 8M 0 0 0 0
8 16M 0 0 0 0
9 32M 0 0 0 0
10 64M 0 0 0 0
11 128M 0 0 0 0
12 256M 0 0 0 0
13 512M 0 0 0 0
14 1G 0 0 0 0
================================================================================
CACHE POOL #0
POOL INFO group: rep99 id: p32645_BLOB
trans active = 0 trans concurrent (max) = 0
trans total = 0 (0 )
flag = 0x00000000
last error = (0=)
Allocation Request Distribution
< 128B: 0
128B: 0 0 | 512B: 0 0
2K: 0 0 | 8K: 0 0
32K: 0 0 | 128K: 0 0
512K: 0 0 | 2M: 0 0
8M: 0 0 | 32M: 0 0
128M: 0 0 | 512M: 0 0
2G: 0 0 | 8G: 0
遇到这样的问题，如何解决呢？
[本帖最后由 lijiebin 于 2010-11-25 09:21 编辑]