问题描述:开启ogg投递进程时报错OGG-01224,如下所示:
1、异常重现
GGSCI (leo-oracle-19c) 3> info all

Program     Status      Group       Lag at Chkpt  Time Since Chkpt

MANAGER     RUNNING                                           
EXTRACT     RUNNING     EXTORCL     00:00:00      00:00:02    
EXTRACT     ABENDED     PUMYSQL     00:00:00      04:54:03    


GGSCI (leo-oracle-19c) 4> start pumysql

Sending START request to Manager ...
Extract group PUMYSQL starting.


GGSCI (leo-oracle-19c) 5> info all

Program     Status      Group       Lag at Chkpt  Time Since Chkpt

MANAGER     RUNNING                                           
EXTRACT     RUNNING     EXTORCL     00:00:00      00:00:08    
EXTRACT     ABENDED     PUMYSQL     00:00:00      04:54:09 

2024-07-16 21:52:54  ERROR   OGG-01224  TCP/IP error 113 (No route to host), endpoint: 192.168.133.35:7810.

2024-07-16 21:52:54  ERROR   OGG-01668  PROCESS ABENDING.

2、异常原因
目标端防火墙开启导致,目标端防火墙状态如下:
[root@leo-mysql-ogg ~]# systemctl status firewalld
● firewalld.service - firewalld - dynamic firewall daemon
   Loaded: loaded (/usr/lib/systemd/system/firewalld.service; enabled; vendor preset: enabled)
   Active: active (running) since Tue 2024-07-16 20:10:09 CST; 1h 44min ago
     Docs: man:firewalld(1)
 Main PID: 885 (firewalld)
    Tasks: 2
   CGroup: /system.slice/firewalld.service
           └─885 /usr/bin/python2 -Es /usr/sbin/firewalld --nofork --nopid

Jul 16 20:10:06 leo-mysql-ogg systemd[1]: Starting firewalld - dynamic firewall daemon...
Jul 16 20:10:09 leo-mysql-ogg systemd[1]: Started firewalld - dynamic firewall daemon.
Jul 16 20:10:10 leo-mysql-ogg firewalld[885]: WARNING: AllowZoneDrifting is enabled. This is considered an insecure configuration option. It will be remo...g it now.
Hint: Some lines were ellipsized, use -l to show in full.

3、解决方案
--关闭目标端防火墙
[root@leo-mysql-ogg ~]# systemctl stop firewalld
[root@leo-mysql-ogg ~]# systemctl disable firewalld
Removed symlink /etc/systemd/system/multi-user.target.wants/firewalld.service.
Removed symlink /etc/systemd/system/dbus-org.fedoraproject.FirewallD1.service.
[root@leo-mysql-ogg ~]# 
[root@leo-mysql-ogg ~]# systemctl status firewalld
● firewalld.service - firewalld - dynamic firewall daemon
   Loaded: loaded (/usr/lib/systemd/system/firewalld.service; disabled; vendor preset: enabled)
   Active: inactive (dead)
     Docs: man:firewalld(1)

Jul 16 20:10:06 leo-mysql-ogg systemd[1]: Starting firewalld - dynamic firewall daemon...
Jul 16 20:10:09 leo-mysql-ogg systemd[1]: Started firewalld - dynamic firewall daemon.
Jul 16 20:10:10 leo-mysql-ogg firewalld[885]: WARNING: AllowZoneDrifting is enabled. This is considered an insecure configuration option. It will be remo...g it now.
Jul 16 21:55:12 leo-mysql-ogg systemd[1]: Stopping firewalld - dynamic firewall daemon...
Jul 16 21:55:16 leo-mysql-ogg systemd[1]: Stopped firewalld - dynamic firewall daemon.
Hint: Some lines were ellipsized, use -l to show in full.

--重启源端投递进程
GGSCI (leo-oracle-19c) 10> start pumysql

Sending START request to Manager ...
Extract group PUMYSQL starting.


GGSCI (leo-oracle-19c) 11> info all

Program     Status      Group       Lag at Chkpt  Time Since Chkpt

MANAGER     RUNNING                                           
EXTRACT     RUNNING     EXTORCL     00:00:00      00:00:06    
EXTRACT     RUNNING     PUMYSQL     00:00:00      04:56:59    

GGSCI (leo-oracle-19c) 12> info all

Program     Status      Group       Lag at Chkpt  Time Since Chkpt

MANAGER     RUNNING                                           
EXTRACT     RUNNING     EXTORCL     00:00:00      00:00:01    
EXTRACT     RUNNING     PUMYSQL     00:00:00      00:00:01    


GGSCI (leo-oracle-19c) 13> info all

Program     Status      Group       Lag at Chkpt  Time Since Chkpt

MANAGER     RUNNING                                           
EXTRACT     RUNNING     EXTORCL     00:00:00      00:00:08    
EXTRACT     RUNNING     PUMYSQL     00:00:00      00:00:09    


说明:如下所示,源端投递进程成功开启.
  • 1.
  • 2.
  • 3.
  • 4.
  • 5.
  • 6.
  • 7.
  • 8.
  • 9.
  • 10.
  • 11.
  • 12.
  • 13.
  • 14.
  • 15.
  • 16.
  • 17.
  • 18.
  • 19.
  • 20.
  • 21.
  • 22.
  • 23.
  • 24.
  • 25.
  • 26.
  • 27.
  • 28.
  • 29.
  • 30.
  • 31.
  • 32.
  • 33.
  • 34.
  • 35.
  • 36.
  • 37.
  • 38.
  • 39.
  • 40.
  • 41.
  • 42.
  • 43.
  • 44.
  • 45.
  • 46.
  • 47.
  • 48.
  • 49.
  • 50.
  • 51.
  • 52.
  • 53.
  • 54.
  • 55.
  • 56.
  • 57.
  • 58.
  • 59.
  • 60.
  • 61.
  • 62.
  • 63.
  • 64.
  • 65.
  • 66.
  • 67.
  • 68.
  • 69.
  • 70.
  • 71.
  • 72.
  • 73.
  • 74.
  • 75.
  • 76.
  • 77.
  • 78.
  • 79.
  • 80.
  • 81.
  • 82.
  • 83.
  • 84.
  • 85.
  • 86.
  • 87.
  • 88.
  • 89.
  • 90.
  • 91.
  • 92.
  • 93.
  • 94.
  • 95.
  • 96.
  • 97.
  • 98.
  • 99.
  • 100.