OGG-01031和OGG-01232 與目標主機連線中斷造成程式中斷

darren__chan發表於2015-03-25

抽取程式所報錯誤:
2015-03-25 06:03:05  ERROR   OGG-01031  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 erro
r. (Reply received is Could not flush "./dirdat/bg000018" (error 28, No space left on device)).


2015-03-25 06:03:05  ERROR   OGG-01668  PROCESS ABENDING.


投遞程式所報錯誤:

2015-03-25 07:44:13  ERROR   OGG-01232  Receive TCP params error: TCP/IP error 73 (Connection reset by peer), endpoint: 150.12.58.132:7815.

解決方法:多次不斷重啟後自動重啟了,檢視了ggsevt,如下:

2015-03-25 08:00:17  ERROR   OGG-01232  Oracle GoldenGate Capture for Oracle, pzg_cx2.prm:  Receive TCP params error: TCP/IP error 73 (Connection reset by peer), endpoint: 150.12.58.132:7815.
2015-03-25 08:00:17  ERROR   OGG-01668  Oracle GoldenGate Capture for Oracle, pzg_cx2.prm:  PROCESS ABENDING.
2015-03-25 08:04:11  INFO    OGG-00975  Oracle GoldenGate Manager for Oracle, mgr.prm:  EXTRACT PZG_CX2 starting.
2015-03-25 08:04:11  INFO    OGG-00965  Oracle GoldenGate Manager for Oracle, mgr.prm:  EXTRACT PZG_CX2 restarted automatically.
2015-03-25 08:04:11  INFO    OGG-00992  Oracle GoldenGate Capture for Oracle, pzg_cx2.prm:  EXTRACT PZG_CX2 starting.
2015-03-25 08:04:11  INFO    OGG-03035  Oracle GoldenGate Capture for Oracle, pzg_cx2.prm:  Operating system character set identified as ISO-8859

網上解決方法:
把源端投遞程式前滾一個檔案,產生一個新的檔案點

info PUPYL01

alter extract PUPYL01, etrollover







來自 “ ITPUB部落格 ” ,連結:http://blog.itpub.net/29863023/viewspace-1472626/,如需轉載,請註明出處,否則將追究法律責任。

相關文章