goldengate錯誤處理ERROR OGG-01031

由於一次網路閃斷，造成ogg的dpe進程ABENDING，查看dpe進程report

2013-09-2422:19:51ERROROGG-01031Thereisaprobleminnetworkcommunication,aremotefileproblem,encryptionkeysfortargetandsourcedonotmatch(ifusing
ENCRYPT)oranunknownerror.(ReplyreceivedisUnabletoopenfile"/ogg/dcque/rt000060"(error13,Permissiondenied)).

2013-09-2422:19:52ERROROGG-01668PROCESSABENDING.

無法開啟目標端檔案/ogg/dcque/rt000060

查看目標端ggserr.log日誌內容

2013-09-2422:26:23WARNINGOGG-01223OracleGoldenGateCollectorforOracle:Unabletolockfile"/ogg/dcque/rt000060"(error13,Permissiondenied).Lockcurrentlyheldbyprocessid(PID)8552478.
2013-09-2422:26:23WARNINGOGG-01223OracleGoldenGateCollectorforOracle:Unabletoopenfile"/ogg/dcque/rt000060"(error13,Permissiondenied).

發現PID8552478lock住了/ogg/dcque/rt000060檔案

ps-ef|grep8552478

ogg855247811018840Sep23-1:26./server-w300-p7840-7914-m7838-k-l/ogg/software/ggserr.log

kill-98552478

啟動源端dpe進程後，恢複正常

本文出自 “DBA的隨筆記錄” 部落格，請務必保留此出處http://ck1985.blog.51cto.com/4539614/1301249