pl/sql developer通过IPV6连接oracle

背景：

在centos6上安装oracle 11gR2，配置IPV6 ,想在客户端使用pl/sql developer通过IPV6连接oracle服务器。在爬坑的过程中发现在centos7上通过IPV6连接就没有问题，centos6就不行。所以在centos6上考虑问题，突然想到centos6还有一个ip6tables防火墙的，对的，问题就出现在ip6tables上，只要添加1521端口就行了：

[root@ml ~]# vim /etc/sysconfig/ip6tables

# Firewall configuration written by system-config-firewall
# Manual customization of this file is not recommended.
*filter
:INPUT ACCEPT [0:0]
:FORWARD ACCEPT [0:0]
:OUTPUT ACCEPT [0:0]
-A INPUT -m state --state ESTABLISHED,RELATED -j ACCEPT
-A INPUT -p ipv6-icmp -j ACCEPT
-A INPUT -i lo -j ACCEPT
-A INPUT -m state --state NEW -m tcp -p tcp --dport 1521 -j ACCEPT
-A INPUT -m state --state NEW -m udp -p udp --dport 546 -d fe80::/64 -j ACCEPT
-A INPUT -m state --state NEW -m tcp -p tcp --dport 22 -j ACCEPT
-A INPUT -j REJECT --reject-with icmp6-adm-prohibited
-A FORWARD -j REJECT --reject-with icmp6-adm-prohibited
COMMIT

[root@ml ~]# service ip6tables restart   
ip6tables: Setting chains to policy ACCEPT: filter         [  OK  ]
ip6tables: Flushing firewall rules:                        [  OK  ]
ip6tables: Unloading modules:                              [  OK  ]
ip6tables: Applying firewall rules:                        [  OK  ]
[root@ml ~]#

客户端配置：tnsnames.ora配置(同一台ipv4与ipv6地址，配置IPV4是想用来做判断)

24.128 =
  (DESCRIPTION =
    (ADDRESS_LIST =
      (ADDRESS = (PROTOCOL = TCP)(HOST = 172.16.24.128)(PORT = 1521))
    )
    (CONNECT_DATA =
      (SERVICE_NAME = dbsrv2)
    )
  )

ipv6_24.128 =
  (DESCRIPTION =
    (ADDRESS_LIST =
      (ADDRESS = (PROTOCOL = TCP)(HOST = [FEC0:0:0:0001::3])(PORT = 1521))
    )
    (CONNECT_DATA =
      (SERVICE_NAME = dbsrv2)
    )
  )

测试：

Microsoft Windows [版本 10.0.10240]
(c) 2015 Microsoft Corporation. All rights reserved.

C:\Users\ML>tnsping ipv6_24.128

TNS Ping Utility for 64-bit Windows: Version 11.2.0.1.0 - Production on 17-8月 -2018 08:56:01

Copyright (c) 1997, 2010, Oracle.  All rights reserved.

已使用的参数文件:
C:\Users\ML\Downloads\instantclient-basic-windows.x64-12.2.0.1.0\instantclient_12_2\NETWORK\ADMIN\sqlnet.ora


已使用 TNSNAMES 适配器来解析别名
尝试连接 (DESCRIPTION = (ADDRESS_LIST = (ADDRESS = (PROTOCOL = TCP)(HOST = [FEC0:0:0:0001::3])(PORT = 1521))) (CONNECT_DATA = (SERVICE_NAME = dbsrv2)))
OK (20 毫秒)

C:\Users\ML>