Oracle Goldengate出现报错OGG-01223 TCP/IP error 79 (Connection refused)
Oracle Goldengate出现报错OGG-01223 TCP/IP error 79 (Connection refused)
oracle goldengate 启动pump PM110628 进程不成功,显示ABENDED
EXTRACT ABENDED PM110628 00:00:00 00:07:07
查看PM110628 的报告
view report PM110628
里面的报错信息如下:
2011-06-28 13:25:26 WARNING OGG-01223 TCP/IP error 79 (Connection refused).
2011-06-28 13:25:36 WARNING OGG-01223 TCP/IP error 79 (Connection refused).
2011-06-28 13:25:46 WARNING OGG-01223 TCP/IP error 79 (Connection refused).
2011-06-28 13:25:56 WARNING OGG-01223 TCP/IP error 79 (Connection refused).
2011-06-28 13:26:06 WARNING OGG-01223 TCP/IP error 79 (Connection refused).
2011-06-28 13:26:16 WARNING OGG-01223 TCP/IP error 79 (Connection refused).
2011-06-28 13:26:26 WARNING OGG-01223 TCP/IP error 79 (Connection refused).
2011-06-28 13:26:36 WARNING OGG-01223 TCP/IP error 79 (Connection refused).
2011-06-28 13:26:46 WARNING OGG-01223 TCP/IP error 79 (Connection refused).
2011-06-28 13:26:56 WARNING OGG-01223 TCP/IP error 79 (Connection refused).
2011-06-28 13:27:06 WARNING OGG-01223 TCP/IP error 79 (Connection refused).
Source Context :
SourceModule : [er.extrout]
SourceID : [/home/ecloud/workspace/Build_OpenSys_r11.1.1.0.0_078_[34104]/perforce/src/app/er/extrout.c]
SourceFunction : [tcp_send_data(extract_def *)]
SourceLine : [1243]
2011-06-28 13:27:16 ERROR OGG-01224 TCP/IP error 79 (Connection refused); retries exceeded.
2011-06-28 13:27:16 ERROR OGG-01668 PROCESS ABENDING.
查看view param pm110628
GGSCI (p670b) 18>
GGSCI (p670b) 19> view param PM110628
extract PM110628
passthru
rmthost ip地址, mgrport 7809
rmttrail /goldengate/dirdat/H4
GGSCI (p670b) 76> info mgr
Manager is running (IP port p670b.7820).
mgr端口和PM110628 端口 不一致,把PM110628改成7820
重新启动pump进程,再查看PM110628进程日志没有报错,状态为running