OGG-01031和OGG-01232 與目標主機串連中斷造成進程中斷
抽取進程所報錯誤:
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