Golden Gate Troubleshooting(1)

实施GG,遇到两个错误,记录备忘:

1. Cannot load ICU resource bundle ‘ggMessage’, error code 2 – No such file or directory

需要在ggs的HOME目录下执行ggsci才OK,在其他位置执行会报错,找不到文件或是目录
[[email protected] app]$ ggsci

Oracle GoldenGate Command Interpreter for Oracle
Version 11.1.1.1 OGGCORE_11.1.1_PLATFORMS_110421.2040
Linux, x64, 64bit (optimized), Oracle 11g on Apr 21 2011 22:42:14

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

GGSCI (Enmopri) 1> dblogin userid ggs,password oraclegg
Cannot load ICU resource bundle ‘ggMessage’, error code 2 – No such file or directory
Cannot load ICU resource bundle ‘ggMessage’, error code 2 – No such file or directory
Aborted
[[email protected] app]$ cd ggs/
[[email protected] ggs]$ ggsci

Oracle GoldenGate Command Interpreter for Oracle
Version 11.1.1.1 OGGCORE_11.1.1_PLATFORMS_110421.2040
Linux, x64, 64bit (optimized), Oracle 11g on Apr 21 2011 22:42:14

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

GGSCI (Enmopri) 1> dblogin userid ggs,password oraclegg
Successfully logged into database.

2.无法同步表

2011-05-20 09:04:54  INFO    OGG-00987  Oracle GoldenGate Command Interpreter for Oracle:  GGSCI command (oracle): start mgr.
2011-05-20 09:04:54  INFO    OGG-00983  Oracle GoldenGate Manager for Oracle, mgr.prm:  Manager started (port 7809).
2011-05-20 09:05:07  INFO    OGG-00987  Oracle GoldenGate Command Interpreter for Oracle:  GGSCI command (oracle): start rep1.
2011-05-20 09:05:07  INFO    OGG-00963  Oracle GoldenGate Manager for Oracle, mgr.prm:  Command received from GGSCI on host 127.0.0.1 (START REPLICAT REP1 ).
2011-05-20 09:05:07  INFO    OGG-00975  Oracle GoldenGate Manager for Oracle, mgr.prm:  REPLICAT REP1 starting.
2011-05-20 09:05:07  INFO    OGG-00995  Oracle GoldenGate Delivery for Oracle, rep1.prm:  REPLICAT REP1 starting.
2011-05-20 09:05:07  INFO    OGG-00996  Oracle GoldenGate Delivery for Oracle, rep1.prm:  REPLICAT REP1 started.
2011-05-20 09:05:07  ERROR   OGG-00212  Oracle GoldenGate Delivery for Oracle, rep1.prm:  Invalid option for MAP: ggs.*.
2011-05-20 09:05:07  ERROR   OGG-01668  Oracle GoldenGate Delivery for Oracle, rep1.prm:  PROCESS ABENDING.

根据提示,应该是rep1配置错误,查看rep1

replicat rep1
userid ggs,password oraclegg
assumetargetdefs
reperror default,discard
discardfile /u01/app/ggs/discard/repsz.des,append megabytes 100
gettruncates
map ggs.*,target ggs.*;

貌似一切正常,根据网上提示,是一个空格导致的血案!

The error was due to a space missing between the comma (,) and TARGET (keyword) in the Replicat params file.

修改后再次测试,成功

2011-05-20 09:11:18  INFO    OGG-00987  Oracle GoldenGate Command Interpreter for Oracle:  GGSCI command (oracle): stop rep1.
2011-05-20 09:11:22  INFO    OGG-00987  Oracle GoldenGate Command Interpreter for Oracle:  GGSCI command (oracle): start rep1.
2011-05-20 09:11:22  INFO    OGG-00963  Oracle GoldenGate Manager for Oracle, mgr.prm:  Command received from GGSCI on host 127.0.0.1 (START REPLICAT REP1 ).
2011-05-20 09:11:22  INFO    OGG-00975  Oracle GoldenGate Manager for Oracle, mgr.prm:  REPLICAT REP1 starting.
2011-05-20 09:11:22  INFO    OGG-00995  Oracle GoldenGate Delivery for Oracle, rep1.prm:  REPLICAT REP1 starting.
2011-05-20 09:11:22  INFO    OGG-00996  Oracle GoldenGate Delivery for Oracle, rep1.prm:  REPLICAT REP1 started.
2011-05-20 09:11:31  WARNING OGG-00869  Oracle GoldenGate Delivery for Oracle, rep1.prm:  No unique key is defined for table TEST. All viable columns will be used to represent the key, but may not guarantee uniqueness.  KEYCOLS may be used to define the key.

普人特福的博客cnzz&51la for wordpress,cnzz for wordpress,51la for wordpress