iptables导致无法远程连接oracle
listener日志里面报告
WARNING: Subscription for node down event still pending
09-AUG-2011 10:47:07 * (CONNECT_DATA=(CID=(PROGRAM=)(HOST=localhost.localdomain)(USER=oracle))(COMMAND=status)(ARGUMENTS=64)(SERVICE=LISTENER)(VERSION=186647040)) * status * 0
Tue Aug 09 10:48:07 2011
09-AUG-2011 10:48:07 * service_register * wmstest * 0
Tue Aug 09 10:48:19 2011
09-AUG-2011 10:48:19 * service_update * wmstest * 0
Tue Aug 09 10:49:59 2011
刚开始还以为是bug，metalink上搜到解决方案，将SUBSCRIBE_FOR_NODE_DOWN_EVENT_LISTENER=OFF添加进listener.ora文件
重启listener，果然没有警告信息了，但是依旧连接不上，另外alert.log和listener.log里也无任何信息。
怀疑是OS设置问题，登录server查看，开启了iptabls，将其关闭
[root@localhost trace]# chkconfig --list iptables
iptables 0:off 1:off 2:on 3:on 4:on 5:on 6:off
[root@localhost trace]# chkconfig iptables off
[root@localhost trace]# /etc/init.d/iptables stop
Flushing firewall rules: [ OK ]
Setting chains to policy ACCEPT: filter [ OK ]
Unloading iptables modules: [ OK ]
此时可以顺利连通oracle了
来自 “ ITPUB博客 ” ，链接：https://blog.itpub.net/15480802/viewspace-704767/ ，如需转载，请注明出处，否则将追究法律责任。
