OGG-01224 TCP/IP error 111 (Connection refused); retries exceeded.

来源：互联网发布：软件消除会议室回声编辑：程序博客网时间：2024/06/06 10:01

在源端启动goldengate pump进程，状态起初是running,后来却变成了ABENDED

GGSCI (source_pc) 3> info allProgram     Status      Group       Lag at Chkpt  Time Since ChkptMANAGER     RUNNING                                           EXTRACT     RUNNING     EORA_T1     00:00:00      00:00:07   EXTRACT     ABENDED     PORA_T1     00:00:00      00:12:40

查看错误报告：

GGSCI (source_pc) 4> view report pora_t1

看到这个错误：

2014-10-30 03:02:25 ERROR OGG-01224 TCP/IP error 111 (Connection refused); retries exceeded.

2014-10-30 03:02:25 ERROR OGG-01668 PROCESS ABENDING.

--查看pump参数

GGSCI (source_pc) 5> view params pora_t1extract pora_t1  setenv (NLS_LANG=AMERICAN_AMERICA.AL32UTF8)  passthru  rmthost 192.168.8.226,mgrport 7809  rmttrail ./dirdat/pa  table scott.t;

--查看源端和目标端mgr参数

GGSCI (source_pc) 6> view params mgrPORT 7089GGSCI (target_pc) 10> view params mgrPORT 7089

发现它们的端口号不一致.

改成一样的，如都改为7809，然后重启mgr,pump，extract,replicat等相关进程即可

0 0