源端数据库插入几条数据，然后在目标端没有查询到同步的数据。检查了一下源端的几个进程，发现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对方的其他端口都是通的。重启目标端和源端的进程之后还是存在这个问题
这种情况是什么原因呢？
我刚才禁用了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
实在是找不到原因了
评论 有用 01–源端和目标端都需要新增DYNAMICPORTLIST参数指定端口访问，并且重启MGR进程
2–确认两端的操作系统本地的Firewall和iptables确认都禁止了么？
评论 有用 01，我在目标端新增了DYNAMICPORTLIST参数指定端口访问，并且重启MGR进程，源端没新增。然后源端还是无法连接上目标端的7809端口，我用tcpdump命令看了下，源端只去连接目标端的7809，没有连接其他端口，不过，我等会再把源端增加DYNAMICPORT试下
2，两边的防火墙、selinux都关闭了。且互相telnet对方的其他端口，比如ssh ftp oracle监听都是通的
评论 有用 0
