goldengate源端报错：OGG-01223

2020-05-11

源端数据库插入几条数据，然后在目标端没有查询到同步的数据。检查了一下源端的几个进程，发现pump进程有如下报错：
WARNING OGG-01223 TCP/IP error 110 (Connection timed out), endpoint: 192.168.118.147:7809.
根据这个提示是无法连接到目标端的7809端口，但是目标端的7809的确是在运行着的啊

附上源端的配置
MGR进程配置
GGSCI (sourcegg) 60> view params mgr

port 7809
autostart er *
autorestart er ,waitminutes 3,retries 15
purgeoldextracts ./dirdat/,usecheckpoints,minkeepdays 7

extract抽取进程配置
GGSCI (sourcegg) 61> view params ext01

extract ext01
userid goldengate,password goldengate
exttrail ./dirdat/ext01/ex
tranlogoptions excludeuser goldengate
tranlogoptions convertucs2clobs
warnlongtrans 12h,checkinterval 30m
discardfile ./dirrpt/ext01/ext01.dsc,append megabytes 200
TABLE test.;
–TABLE itpux01.;
–TABLE itpux02.;
–TABLE itpux03.;

pump投递进程配置
GGSCI (sourcegg) 62> view params pump01

extract pump01
userid goldengate,password goldengate
PASSTHRU
RMTHOST 192.168.118.147,MGRPORT 7809
rmttrail ./dirdat/rep01/re
discardfile ./dirrpt/rep01/rep01.dsc,append megabytes 200
TABLE test.;
–TABLE itpux01.;
–TABLE itpux02.;
–TABLE itpux03.;

下面是目标端的配置：
MGR进程配置
GGSCI (destgg) 55> view params mgr

port 7809
autostart er *
autorestart er ,waitminutes 3,retries 15
purgeoldextracts ./dirdat/,usecheckpoints,minkeepdays 7

复制进程配置
GGSCI (destgg) 56> view params rep01

replicat rep01
userid goldengate,password goldengate
handlecollisions
assumetargetdefs
discardfile ./dirrpt/rep01/rep01.dsc,append megabytes 200
map test.,target test.;
–map itpux01.,target itpux01.;
–map itpux02.,target itpux02.;
–map itpux02.,target itpux03.;
GGSCI (destgg) 57> info mgr

Manager is running (IP port destgg.7809).

奇怪的是，虽然目标端的mgr运行着7809端口，
[oracle@destgg ~]$ netstat -ntlp
tcp6 0 0 :::7809 ::😗 LISTEN 12774/./mgr

但是从源端无法telnet
[root@sourcegg ~]# telnet 192.168.118.147 7809
Trying 192.168.118.147…
^C
同样，从目标端也无法telnet源端的7809端口
[root@destgg ~]# telnet 192.168.118.146 7809
Trying 192.168.118.146…
^C

两台服务器之间没有防火墙，并且互相telnet对方的其他端口都是通的。重启目标端和源端的进程之后还是存在这个问题

这种情况是什么原因呢？

6条回答

默认

最新

吴世兴

正常grep出来的是tcp，不是tcp6,是不是启用ipv6了，源和目标分别telnet自己的7809能通吗？imfo mgr看看

有用 0

吴明

我刚才禁用了IPV6,系统（Centos7.2）重启后看了下端口还是TCP6，不知道是不是我的方法不对，我禁用IPV6的方法如下：
1，vi /etc/sysctl.conf
net.ipv6.conf.all.disable_ipv6 =1
net.ipv6.conf.default.disable_ipv6 =1
2，vi /etc/sysconfig/network增加 NETWORKING_IPV6=no
3,vi /etc/sysconfig/network-scripts/ifcfg-eth0
修改IPV6INIT=no
重启系统后，ifconfig -a看不到inet6的IPV6地址了

源端和目标端均能telnet自己的7809
源端：
GGSCI (sourcegg) 3> info mgr

Manager is running (IP port sourcegg.7809).

GGSCI (sourcegg) 4> exit
[oracle@sourcegg ggs]$ telnet 127.0.0.1 7809
Trying 127.0.0.1…
Connected to 127.0.0.1.
Escape character is ‘^]’.
Connection closed by foreign host.
目标端
GGSCI (destgg) 2> info mgr

Manager is running (IP port destgg.7809).

GGSCI (destgg) 3> exit
[oracle@destgg ggs]$ telnet 127.0.0.1 7809
Trying 127.0.0.1…
Connected to 127.0.0.1.
Escape character is ‘^]’.
Connection closed by foreign host.

但是仍然无法telnet对方的7809端口，源端的pump01进程报错信息还是：
2020-05-11 20:36:02 WARNING OGG-01223 TCP/IP error 110 (Connection timed out), endpoint: 192.168.118.147:7809.

2020-05-11 20:38:19 WARNING OGG-01223 TCP/IP error 110 (Connection timed out), endpoint: 192.168.118.147:7809.

2020-05-11 20:40:37 WARNING OGG-01223 TCP/IP error 110 (Connection timed out), endpoint: 192.168.118.147:7809.

有用 0

吴明

现在总算把IPV6禁用了
源端：
[root@sourcegg ~]# netstat -ntlp
tcp 0 0 0.0.0.0:7840 0.0.0.0:* LISTEN 2793/extract
tcp 0 0 0.0.0.0:7841 0.0.0.0:* LISTEN 2792/extract
tcp 0 0 0.0.0.0:7809 0.0.0.0:* LISTEN 2784/./mgr

目标端：
[root@destgg ~]# netstat -ntlp
tcp 0 0 0.0.0.0:7840 0.0.0.0:* LISTEN 2596/replicat
tcp 0 0 0.0.0.0:7809 0.0.0.0:* LISTEN 2585/./mgr

但是从系统层面，仍然无法telnet对端的7809，真是奇了怪了
源端pump进程报错：
2020-05-11 22:00:57 WARNING OGG-01223 TCP/IP error 110 (Connection timed out), endpoint: 192.168.118.147:7809.

2020-05-11 22:03:14 WARNING OGG-01223 TCP/IP error 110 (Connection timed out), endpoint: 192.168.118.147:7809.

GGSCI (sourcegg) 6> info mgr

Manager is running (IP port sourcegg.7809).

目标端mgr配置（新增了DYNAMICPORTLIST 7809-7830）：
GGSCI (destgg) 6> info mgr

Manager is running (IP port destgg.7809).

GGSCI (destgg) 7> view params mgr

port 7809
DYNAMICPORTLIST 7809-7830
autostart er *
autorestart er ,waitminutes 3,retries 15
purgeoldextracts ./dirdat/,usecheckpoints,minkeepdays 7

从源端tcpdump了一下，只有去访问目标端7809的数据包，但是目标端并没有回包
[root@sourcegg ~]# tcpdump -v host 192.168.118.146 and 192.168.118.147
tcpdump: listening on eth0, link-type EN10MB (Ethernet), capture size 262144 bytes
22:05:41.615379 IP (tos 0x0, ttl 64, id 7325, offset 0, flags [DF], proto TCP (6), length 60)
sourcegg.14790 > destgg.7809: Flags [S], cksum 0x1c35 (correct), seq 1448460431, win 29200, options [mss 1460,sackOK,TS val 384018 ecr 0,nop,wscale 7], length 0
22:05:42.617273 IP (tos 0x0, ttl 64, id 7326, offset 0, flags [DF], proto TCP (6), length 60)
sourcegg.14790 > destgg.7809: Flags [S], cksum 0x184b (correct), seq 1448460431, win 29200, options [mss 1460,sackOK,TS val 385020 ecr 0,nop,wscale 7], length 0
22:05:44.621276 IP (tos 0x0, ttl 64, id 7327, offset 0, flags [DF], proto TCP (6), length 60)
sourcegg.14790 > destgg.7809: Flags [S], cksum 0x1077 (correct), seq 1448460431, win 29200, options [mss 1460,sackOK,TS val 387024 ecr 0,nop,wscale 7], length 0
22:05:46.621266 ARP, Ethernet (len 6), IPv4 (len 4), Request who-has destgg tell sourcegg, length 28
22:05:46.621378 ARP, Ethernet (len 6), IPv4 (len 4), Reply destgg is-at fa:16:3e:f0:88:71 (oui Unknown), length 28
22:05:48.629269 IP (tos 0x0, ttl 64, id 7328, offset 0, flags [DF], proto TCP (6), length 60)
sourcegg.14790 > destgg.7809: Flags [S], cksum 0x00cf (correct), seq 1448460431, win 29200, options [mss 1460,sackOK,TS val 391032 ecr 0,nop,wscale 7], length 0
22:05:56.637261 IP (tos 0x0, ttl 64, id 7329, offset 0, flags [DF], proto TCP (6), length 60)
sourcegg.14790 > destgg.7809: Flags [S], cksum 0xe186 (correct), seq 1448460431, win 29200, options [mss 1460,sackOK,TS val 399040 ecr 0,nop,wscale 7], length 0
22:06:12.669275 IP (tos 0x0, ttl 64, id 7330, offset 0, flags [DF], proto TCP (6), length 60)
sourcegg.14790 > destgg.7809: Flags [S], cksum 0xa2e6 (correct), seq 1448460431, win 29200, options [mss 1460,sackOK,TS val 415072 ecr 0,nop,wscale 7], length 0

实在是找不到原因了

有用 0