EXTRACT ABENDED PMP01

问题

GGSCI (udbs01) 10> info all

Program     Status      Group       Lag at Chkpt  Time Since Chkpt

MANAGER     RUNNING                                           
EXTRACT     RUNNING     EXT01       00:00:00      00:00:09    
EXTRACT     ABENDED     PMP01       00:00:00      00:11:39

GGSCI (udbs01) 9> info extract pmp01

EXTRACT    PMP01     Last Started 2020-11-19 13:21   Status ABENDED
Checkpoint Lag       00:00:00 (updated 00:11:27 ago)
Log Read Checkpoint  File /u01/gg/11.2/dirdat/ex000000
                     First Record  RBA 0

view report pmp01

2020-11-19 13:17:16  ERROR   OGG-01224  TCP/IP error 113 (No route to host).  
2020-11-19 13:17:16  ERROR   OGG-01668  PROCESS ABENDING.

原因

root@udbs01 ~]# 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@udbs01 ~]# service iptables save
iptables: Saving firewall rules to /etc/sysconfig/iptables:[  OK  ]
[root@udbs01 ~]# service iptables stop
iptables: Flushing firewall rules:                         [  OK  ]
iptables: Setting chains to policy ACCEPT: filter          [  OK  ]
iptables: Unloading modules:                               [  OK  ]
[root@udbs01 ~]# chkconfig iptables off
[root@udbs01 ~]# service iptables status
iptables: Firewall is not running.

GGSCI (udbs01) 1> start extract pmp01

Sending START request to MANAGER ...
EXTRACT PMP01 starting

验证

GGSCI (udbs01) 2> info all

Program     Status      Group       Lag at Chkpt  Time Since Chkpt

MANAGER     RUNNING                                           
EXTRACT     RUNNING     EXT01       00:00:00      00:00:01    
EXTRACT     RUNNING     PMP01       00:00:00      00:28:44