ogg 遇到的问题

问题一：
2012-09-03 16:17:14  GGS ERROR       112  There is a problem in network communication, a remote file problem, encryption keys for target and
source do not match (if using ENCRYPT) or an unknown error. (Reply received is Unable to open file "D:\ggs\dirdat\aa000017" (error 997, I/O
)).

2012-09-03 16:17:14  GGS ERROR       190  PROCESS ABENDING.

 

 

自己就好了

 

 

 

 

 

 

 

问题二：
2012-09-11 14:04:23  WARNING OGG-01004  Aborted grouped transaction on 'BOSDATA.PUB_WORKFLOWNOTE', Database error 100 (retrieving bind info for query).

2012-09-11 14:04:23  WARNING OGG-01003  Repositioning to rba 6740592 in seqno 2478.

2012-09-11 14:04:23  WARNING OGG-01154  SQL error 1403 mapping BOSDATA.PUB_WORKFLOWNOTE to BOSDATA.PUB_WORKFLOWNOTE.

2012-09-11 14:04:23  WARNING OGG-01003  Repositioning to rba 6742221 in seqno 2478.

 

http://www.askmaclean.com/archives/%E4%BA%86%E8%A7%A3goldengate-replicat%E7%9A%84handlecollisions%E5%8F%82%E6%95%B0.html

 

 

 

问题三：

[oracle@rac1 ggs]$ ./ggsci
./ggsci: error while loading shared libraries: libnnz11.so: cannot open shared object file: No such file or directory

需要在 .bash_pofile中加入

export LD_LIBRARY_PATH=$ORACLE_HOME/lib:/lib:/usr/lib

问题四：

2013-06-16 22:11:49  ERROR   OGG-00268  Parameter unterminated.
2013-06-16 22:11:49  ERROR   OGG-01668  PROCESS ABENDING.

解决方法：查看参数文件 view params  exta   ，是否源端的少加分号，或者目标端，少了空格

extract exta
userid goldengate,password goldengate
rmthost 192.168.1.5,mgrport 7809
rmttrail ./dirdat/aa
table scott.t1;---此处注意分号

或者目标端

replicat repa
assumetargetdefs
userid goldengate,password goldengate
map scott.t1, （此处要有一个空格）target scott.t1;---此处要有分号