A-A+
灾备端防火墙引起的pump进程无法启动 OGG-01224 TCP/IP error 113 (No route to host)
启动相关进程报错如下:
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!