A-A+

灾备端防火墙引起的pump进程无法启动 OGG-01224 TCP/IP error 113 (No route to host)

2013年05月14日 DG&RAC&OGG, TroubleShooting 暂无评论 阅读 3,172 次

启动相关进程报错如下:

GGSCI (11grac2) 23> start PU_TEST

Sending START request to MANAGER ...
EXTRACT PU_TEST starting


GGSCI (11grac2) 24> info all

Program     Status      Group       Lag           Time Since Chkpt

MANAGER     RUNNING                                           
EXTRACT     RUNNING     EXT_TEST    00:00:00      00:00:02    
EXTRACT     ABENDED     PU_TEST     00:00:00      41:18:04 

查看日志如下:

2013-05-14 08:31:39  ERROR   OGG-01224  Oracle GoldenGate Capture for Oracle, pu_test.prm:  TCP/IP error 113 (No route to host).
2013-05-14 08:31:39  ERROR   OGG-01668  Oracle GoldenGate Capture for Oracle, pu_test.prm:  PROCESS ABENDING.

查看相关参数配置

GGSCI (11grac2) 37> view params PU_TEST

extract pu_test
dynamicresolution
passthru
rmthost 192.168.137.174,mgrport 7840,compress
rmttrail /u01/app/ogg/11.1/dirdat/pt
table test.*;

GGSCI (11grac2) 32> view params mgr

port 7840
autostart er *  
autorestart er * 

操作系统进行测试:

[root@11grac1 ~]# telnet 192.168.137.174 7840
Trying 192.168.137.174...
telnet: connect to address 192.168.137.174: No route to host

查看目标端防火墙配置:

[root@x64_ogg ~]# service iptables status
Table: filter
Chain INPUT (policy ACCEPT)
num  target     prot opt source               destination         
1    ACCEPT     all  --  0.0.0.0/0            0.0.0.0/0           state RELATED,ESTABLISHED 
2    ACCEPT     icmp --  0.0.0.0/0            0.0.0.0/0           
3    ACCEPT     all  --  0.0.0.0/0            0.0.0.0/0           
4    ACCEPT     tcp  --  0.0.0.0/0            0.0.0.0/0           state NEW tcp dpt:22 
5    REJECT     all  --  0.0.0.0/0            0.0.0.0/0           reject-with icmp-host-prohibited 

Chain FORWARD (policy ACCEPT)
num  target     prot opt source               destination         
1    REJECT     all  --  0.0.0.0/0            0.0.0.0/0           reject-with icmp-host-prohibited 

Chain OUTPUT (policy ACCEPT)
num  target     prot opt source               destination  

关闭防火墙

[root@x64_ogg ~]# service iptables stop
iptables: Flushing firewall rules: [  OK  ]
iptables: Setting chains to policy ACCEPT: filter [  OK  ]
iptables: Unloading modules: [  OK  ]
[root@x64_ogg ~]# chkconfig iptables off

再次启动pump进程:

GGSCI (11grac2) 34> start PU_TEST

Sending START request to MANAGER ...
EXTRACT PU_TEST starting

查看日志:

[oracle@11grac1 11.1]$ tail  ggserr.log 
2013-05-14 09:17:48  INFO    OGG-00963  Oracle GoldenGate Manager for Oracle, mgr.prm:  Command received from GGSCI on host 192.168.137.166 (START EXTRACT PU_TEST ).
2013-05-14 09:17:48  INFO    OGG-00975  Oracle GoldenGate Manager for Oracle, mgr.prm:  EXTRACT PU_TEST starting.
2013-05-14 09:17:50  INFO    OGG-00992  Oracle GoldenGate Capture for Oracle, pu_test.prm:  EXTRACT PU_TEST starting.
2013-05-14 09:17:50  INFO    OGG-00993  Oracle GoldenGate Capture for Oracle, pu_test.prm:  EXTRACT PU_TEST started.
2013-05-14 09:17:56  INFO    OGG-01226  Oracle GoldenGate Capture for Oracle, pu_test.prm:  Socket buffer size set to 27985 (flush size 27985).
2013-05-14 09:17:56  INFO    OGG-01055  Oracle GoldenGate Capture for Oracle, pu_test.prm:  Recovery initialization completed for target file /u01/app/ogg/11.1/dirdat/pt000000, at RBA 4485.
2013-05-14 09:17:56  INFO    OGG-01478  Oracle GoldenGate Capture for Oracle, pu_test.prm:  Output file /u01/app/ogg/11.1/dirdat/pt is using format RELEASE 10.4/11.1.
2013-05-14 09:17:56  INFO    OGG-01026  Oracle GoldenGate Capture for Oracle, pu_test.prm:  Rolling over remote file /u01/app/ogg/11.1/dirdat/pt000001.
2013-05-14 09:17:56  INFO    OGG-01053  Oracle GoldenGate Capture for Oracle, pu_test.prm:  Recovery completed for target file /u01/app/ogg/11.1/dirdat/pt000001, at RBA 1032.
2013-05-14 09:17:56  INFO    OGG-01057  Oracle GoldenGate Capture for Oracle, pu_test.prm:  Recovery completed for all targets.

查看进程状态:

GGSCI (11grac2) 36> info all

Program     Status      Group       Lag           Time Since Chkpt

MANAGER     RUNNING                                           
EXTRACT     RUNNING     EXT_TEST    00:00:00      00:00:06    
EXTRACT     RUNNING     PU_TEST     00:00:00      00:00:09

至此,全部ok!

标签:

给我留言

Copyright © YallonKing 保留所有权利.   Theme  Ality

用户登录

分享到: