Oracle GoldenGate

環境

源端

系統 HPUNIX 11.31

集群架構 HP高可用集群

數據庫 Oracle 10.2.0.3

目標端

系統 RHEL 5.8 x64

集群架構 ORACLE RAC

數據庫 11.2.0.1.0

描述

HP集群異常自動切換，導致GG進程異常。

源端報錯

2014-07-14 16:38:52  ERROR   OGG01031  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 "/u01/ogg/dirdat/rt001995" (error 11, Resource temporarily unavailable)).

目標端報錯

2014-07-14 16:32:57  WARNING OGG-01223  Oracle GoldenGate Collector for Oracle:  Unable to lock file "/u01/ogg/dirdat/rt001995" (error 11, Resource temporarily unavailable).  Lock currently held by process id (PID) 21438.
2014-07-14 16:32:57  WARNING OGG-01223  Oracle GoldenGate Collector for Oracle:  Unable to open file "/u01/ogg/dirdat/rt001995" (error 11, Resource temporarily unavailable).

解決

kill目標端鎖定文進的系統進程。

處理過程

源端

啟動gg進程，投遞進程異常止

查看投遞進程日志 view report 投遞進程

2014-07-14 16:38:52  ERROR   OGG01031  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 "/u01/ogg/dirdat/rt001995" (error 11, Resource temporarily unavailable)).

查看ggserr.log

目標端

查看ggserr.log

2014-07-14 16:32:57  WARNING OGG-01223  Oracle GoldenGate Collector for Oracle:  Unable to lock file "/u01/ogg/dirdat/rt001995" (error 11, Resource temporarily unavailable).  Lock currently held by process id (PID) 21438.
2014-07-14 16:32:57  WARNING OGG-01223  Oracle GoldenGate Collector for Oracle:  Unable to open file "/u01/ogg/dirdat/rt001995" (error 11, Resource temporarily unavailable).

ps –ef | grep 21438

kill –9 21438

問題解決。