Oracle GoldenGate

環(huán)境

源端

系統(tǒng) HPUNIX 11.31

集群架構(gòu) HP高可用集群

數(shù)據(jù)庫 Oracle 10.2.0.3

目標(biāo)端

系統(tǒng) RHEL 5.8 x64

集群架構(gòu) ORACLE RAC

數(shù)據(jù)庫 11.2.0.1.0

描述

HP集群異常自動切換，導(dǎo)致GG進(jìn)程異常。

源端報錯

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)).

目標(biāo)端報錯

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目標(biāo)端鎖定文進(jìn)的系統(tǒng)進(jìn)程。

處理過程

源端

啟動gg進(jìn)程，投遞進(jìn)程異常止

查看投遞進(jìn)程日志 view report 投遞進(jìn)程

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

目標(biāo)端

查看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

問題解決。