{"id":858,"date":"2013-05-14T09:41:38","date_gmt":"2013-05-14T01:41:38","guid":{"rendered":"http:\/\/www.yallonking.com\/?p=858"},"modified":"2013-05-14T09:42:46","modified_gmt":"2013-05-14T01:42:46","slug":"%e7%81%be%e5%a4%87%e7%ab%af%e9%98%b2%e7%81%ab%e5%a2%99%e5%bc%95%e8%b5%b7%e7%9a%84pump%e8%bf%9b%e7%a8%8b%e6%97%a0%e6%b3%95%e5%90%af%e5%8a%a8-ogg-01224-tcpip-error-113-no-route-to-host","status":"publish","type":"post","link":"http:\/\/www.yallonking.com\/?p=858","title":{"rendered":"\u707e\u5907\u7aef\u9632\u706b\u5899\u5f15\u8d77\u7684pump\u8fdb\u7a0b\u65e0\u6cd5\u542f\u52a8 OGG-01224 TCP\/IP error 113 (No route to host)"},"content":{"rendered":"<p>\u542f\u52a8\u76f8\u5173\u8fdb\u7a0b\u62a5\u9519\u5982\u4e0b\uff1a<\/p>\n<pre class=\"wp-code-highlight prettyprint\">\r\nGGSCI (11grac2) 23&gt; start PU_TEST\r\n\r\nSending START request to MANAGER ...\r\nEXTRACT PU_TEST starting\r\n\r\n\r\nGGSCI (11grac2) 24&gt; info all\r\n\r\nProgram     Status      Group       Lag           Time Since Chkpt\r\n\r\nMANAGER     RUNNING                                           \r\nEXTRACT     RUNNING     EXT_TEST    00:00:00      00:00:02    \r\nEXTRACT     ABENDED     PU_TEST     00:00:00      41:18:04 \r\n<\/pre>\n<p>\u67e5\u770b\u65e5\u5fd7\u5982\u4e0b\uff1a<\/p>\n<pre class=\"wp-code-highlight prettyprint\">\r\n2013-05-14 08:31:39  ERROR   OGG-01224  Oracle GoldenGate Capture for Oracle, pu_test.prm:  TCP\/IP error 113 (No route to host).\r\n2013-05-14 08:31:39  ERROR   OGG-01668  Oracle GoldenGate Capture for Oracle, pu_test.prm:  PROCESS ABENDING.\r\n<\/pre>\n<p>\u67e5\u770b\u76f8\u5173\u53c2\u6570\u914d\u7f6e<\/p>\n<pre class=\"wp-code-highlight prettyprint\">\r\nGGSCI (11grac2) 37&gt; view params PU_TEST\r\n\r\nextract pu_test\r\ndynamicresolution\r\npassthru\r\nrmthost 192.168.137.174,mgrport 7840,compress\r\nrmttrail \/u01\/app\/ogg\/11.1\/dirdat\/pt\r\ntable test.*;\r\n\r\nGGSCI (11grac2) 32&gt; view params mgr\r\n\r\nport 7840\r\nautostart er *  \r\nautorestart er * \r\n\r\n<\/pre>\n<p>\u64cd\u4f5c\u7cfb\u7edf\u8fdb\u884c\u6d4b\u8bd5\uff1a<\/p>\n<pre class=\"wp-code-highlight prettyprint\">\r\n[root@11grac1 ~]# telnet 192.168.137.174 7840\r\nTrying 192.168.137.174...\r\ntelnet: connect to address 192.168.137.174: No route to host\r\n<\/pre>\n<p>\u67e5\u770b\u76ee\u6807\u7aef\u9632\u706b\u5899\u914d\u7f6e\uff1a<\/p>\n<pre class=\"wp-code-highlight prettyprint\">\r\n[root@x64_ogg ~]# service iptables status\r\nTable: filter\r\nChain INPUT (policy ACCEPT)\r\nnum  target     prot opt source               destination         \r\n1    ACCEPT     all  --  0.0.0.0\/0            0.0.0.0\/0           state RELATED,ESTABLISHED \r\n2    ACCEPT     icmp --  0.0.0.0\/0            0.0.0.0\/0           \r\n3    ACCEPT     all  --  0.0.0.0\/0            0.0.0.0\/0           \r\n4    ACCEPT     tcp  --  0.0.0.0\/0            0.0.0.0\/0           state NEW tcp dpt:22 \r\n5    REJECT     all  --  0.0.0.0\/0            0.0.0.0\/0           reject-with icmp-host-prohibited \r\n\r\nChain FORWARD (policy ACCEPT)\r\nnum  target     prot opt source               destination         \r\n1    REJECT     all  --  0.0.0.0\/0            0.0.0.0\/0           reject-with icmp-host-prohibited \r\n\r\nChain OUTPUT (policy ACCEPT)\r\nnum  target     prot opt source               destination  \r\n\r\n<\/pre>\n<p>\u5173\u95ed\u9632\u706b\u5899<\/p>\n<pre class=\"wp-code-highlight prettyprint\">\r\n[root@x64_ogg ~]# service iptables stop\r\niptables: Flushing firewall rules: [  OK  ]\r\niptables: Setting chains to policy ACCEPT: filter [  OK  ]\r\niptables: Unloading modules: [  OK  ]\r\n[root@x64_ogg ~]# chkconfig iptables off\r\n\r\n<\/pre>\n<p>\u518d\u6b21\u542f\u52a8pump\u8fdb\u7a0b\uff1a<\/p>\n<pre class=\"wp-code-highlight prettyprint\">\r\nGGSCI (11grac2) 34&gt; start PU_TEST\r\n\r\nSending START request to MANAGER ...\r\nEXTRACT PU_TEST starting\r\n<\/pre>\n<p>\u67e5\u770b\u65e5\u5fd7\uff1a<\/p>\n<pre class=\"wp-code-highlight prettyprint\">\r\n[oracle@11grac1 11.1]$ tail  ggserr.log \r\n2013-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 ).\r\n2013-05-14 09:17:48  INFO    OGG-00975  Oracle GoldenGate Manager for Oracle, mgr.prm:  EXTRACT PU_TEST starting.\r\n2013-05-14 09:17:50  INFO    OGG-00992  Oracle GoldenGate Capture for Oracle, pu_test.prm:  EXTRACT PU_TEST starting.\r\n2013-05-14 09:17:50  INFO    OGG-00993  Oracle GoldenGate Capture for Oracle, pu_test.prm:  EXTRACT PU_TEST started.\r\n2013-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).\r\n2013-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.\r\n2013-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.\r\n2013-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.\r\n2013-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.\r\n2013-05-14 09:17:56  INFO    OGG-01057  Oracle GoldenGate Capture for Oracle, pu_test.prm:  Recovery completed for all targets.\r\n<\/pre>\n<p>\u67e5\u770b\u8fdb\u7a0b\u72b6\u6001\uff1a<\/p>\n<pre class=\"wp-code-highlight prettyprint\">\r\nGGSCI (11grac2) 36&gt; info all\r\n\r\nProgram     Status      Group       Lag           Time Since Chkpt\r\n\r\nMANAGER     RUNNING                                           \r\nEXTRACT     RUNNING     EXT_TEST    00:00:00      00:00:06    \r\nEXTRACT     RUNNING     PU_TEST     00:00:00      00:00:09\r\n<\/pre>\n<p>\u81f3\u6b64\uff0c\u5168\u90e8ok\uff01<\/p>\n","protected":false},"excerpt":{"rendered":"<p>\u542f\u52a8\u76f8\u5173\u8fdb\u7a0b\u62a5\u9519\u5982\u4e0b\uff1a GGSCI (11grac2) 23&gt; start PU_TEST Sendin [&hellip;]<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":[],"categories":[35,36],"tags":[194],"_links":{"self":[{"href":"http:\/\/www.yallonking.com\/index.php?rest_route=\/wp\/v2\/posts\/858"}],"collection":[{"href":"http:\/\/www.yallonking.com\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"http:\/\/www.yallonking.com\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"http:\/\/www.yallonking.com\/index.php?rest_route=\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"http:\/\/www.yallonking.com\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=858"}],"version-history":[{"count":2,"href":"http:\/\/www.yallonking.com\/index.php?rest_route=\/wp\/v2\/posts\/858\/revisions"}],"predecessor-version":[{"id":860,"href":"http:\/\/www.yallonking.com\/index.php?rest_route=\/wp\/v2\/posts\/858\/revisions\/860"}],"wp:attachment":[{"href":"http:\/\/www.yallonking.com\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=858"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"http:\/\/www.yallonking.com\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=858"},{"taxonomy":"post_tag","embeddable":true,"href":"http:\/\/www.yallonking.com\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=858"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}