【Oracle】GoldenGate 12.2 OGG-06591 OGG-01031

前端之家收集整理的这篇文章主要介绍了【Oracle】GoldenGate 12.2 OGG-06591 OGG-01031前端之家小编觉得挺不错的,现在分享给大家,也给大家做个参考。

碰到的一个OGG 12.2.0.1的一个问题,按照之前的ogg的配置方法配置goldengate同步,但是碰到了以下问题

pump进程启动后abend,报错如下:

2016-07-12 11:02:38 INFO OGG-00993 Oracle GoldenGate Capture for Oracle,pmp_tc.prm: EXTRACT pmp_tc started.

2016-07-12 11:02:40 INFO OGG-00987 Oracle GoldenGate Command Interpreter for Oracle: GGSCI command (oracle): info all.

2016-07-12 11:02:42 INFO OGG-00987 Oracle GoldenGate Command Interpreter for Oracle: GGSCI command (oracle): info all.

2016-07-12 11:02:43 INFO OGG-00987 Oracle GoldenGate Command Interpreter for Oracle: GGSCI command (oracle): info all.

2016-07-12 11:02:43 INFO OGG-01226 Oracle GoldenGate Capture for Oracle,pmp_tc.prm: Socket buffer size set to 27985 (flush size 27985).

2016-07-12 11:02:43 WARNING OGG-06591 Oracle GoldenGate Capture for Oracle,pmp_tc.prm: Reading the output trail file /opt/app/goldengate/dirdat/ld000000 encounters an error from position 0,rescan from the file header to recover.

2016-07-12 11:02:43 ERROR OGG-01031 Oracle GoldenGate Capture for Oracle,pmp_tc.prm: 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 Output file /opt/app/goldengate/dirdat/rd000000 is not in any allowed output directories.).

2016-07-12 11:02:43 ERROR OGG-01668 Oracle GoldenGate Capture for Oracle,pmp_tc.prm: PROCESS ABENDING.

之后发现这个也是12.2的新特性导致的,在使用dirdat以外的目录时,需要在GLOBALS文件增加一个参数才可以,12.2新增的参数ALLOWOUTPUTDIR

但是有个疑问,我这里使用的是dirdat目录,为何也不行呢?有点疑惑,之前12.2的环境配置都没发现这个问题,找了半天也没找到原因,只能暂时归结为bug,希望以后可以解惑吧~

GOLBALS文件增加以下参数后

ALLOWOUTPUTDIR/opt/app/goldengate/dirdat/

重启目标端mgr,重启源端pump进程后,同步恢复正常。

猜你在找的Oracle相关文章