碰到的一個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進程後,同步恢複正常。