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了