导航：首页 > 数据库 >

Oracle GoldenGate

发表于：2024-11-19 作者：千家信息网编辑

千家信息网最后更新 2024年11月19日，环境源端系统 HPUNIX 11.31集群架构 HP高可用集群数据库 Oracle 10.2.0.3目标端系统 RHEL 5.8 x64集群架构 ORACLE RAC数据库 11.2.0.1.0描述H

千家信息网最后更新 2024年11月19日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
问题解决。

很赞哦！