本文标题:防火强引起的TNS-12560错误【本站如从外站转载,会注明出处】
本文链接:http://www.validba.net/2009/02/%e9%98%b2%e7%81%ab%e5%bc%ba%e5%bc%95%e8%b5%b7%e7%9a%84tns-12560%e9%94%99%e8%af%af/
今天对一个系统进行测试,可client怎么也连不上server。tnsping 出现TNS-12560错误
[oracle@ique admin]$ tnsping dest_221
TNS Ping Utility for Linux: Version 10.1.0.5.0 – Production on 16-JUL-2008 16:36:43
Copyright (c) 1997, 2003, Oracle. All rights reserved.
Used parameter files:
/home/oracle/product/10.2/network/admin/sqlnet.ora
/home/oracle/product/10.2/network/admin/sqlnet.ora
Used TNSNAMES adapter to resolve the alias
Attempting to contact (DESCRIPTION = (ADDRESS_LIST = (ADDRESS = (PROTOCOL = TCP)(HOST = *.*.221.113) (PORT = 1521))) (CONNECT_DATA = (SID = *) (SERVER = DEDICATED)))
TNS-12560: TNS:protocol adapter error
Attempting to contact (DESCRIPTION = (ADDRESS_LIST = (ADDRESS = (PROTOCOL = TCP)(HOST = *.*.221.113) (PORT = 1521))) (CONNECT_DATA = (SID = *) (SERVER = DEDICATED)))
TNS-12560: TNS:protocol adapter error
说实话弄了很长时间,就是没有想到是防火墙问题,到最后, 又弄了几个client tnsping 还是不行.这回才想到了防火墙,telnet上去一看,防火墙果然没有配置1521,通过编辑/etc/sysconfig/iptables ,在倒数第二行下面增加一行：
-A RH-Firewall-1-INPUT -m state –state NEW -m tcp -p tcp –dport 1521 -j ACCEPT
restart iptables 后 tnsping正常了.
CopyRight Validba'S Home 版权所有.本站为个人学习之用,评论时请遵守本国法律
