oracle网络的TNS-12560: TNS:protocol adapter error

今天在看关于oracle网络问题的知识，做实验时遇到了以下问题，最终找到了问题所在。

服务器端：oracle11.2.0.3.0

                  Red Hat Enterprise Linux Server release 5.8 (Tikanga)

               监听状态

[ oracle@oracle11  admin]$ lsnrctl status 

LSNRCTL for Linux: Version 11.2.0.3.0 - Production on 22-JAN-2015 20:26:47

Copyright (c) 1991, 2011, Oracle. All rights reserved.

Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=oracle11)(PORT=1521)))

STATUS of the LISTENER

------------------------

Alias LISTENER

Version TNSLSNR for Linux: Version 11.2.0.3.0 - Production

Start Date 22-JAN-2015 20:05:28

Uptime 0 days 0 hr. 21 min. 20 sec

Trace Level off

Security ON: Local OS Authentication

SNMP OFF

Listener Parameter File /u01/app/oracle/product/11.2.0/db_1/network/admin/listener.ora

Listener Log File /u01/app/oracle/diag/tnslsnr/oracle11/listener/alert/log.xml

Listening Endpoints Summary...

(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=oracle11)(PORT=1521)))

(DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(KEY=EXTPROC1521)))

Services Summary...

Service "orcl.oracle11" has 1 instance(s).

Instance "orcl", status READY, has 1 handler(s) for this service...

Service "orclXDB.oracle11" has 1 instance(s).

Instance "orcl", status READY, has 1 handler(s) for this service...

客户端：oralce10.2.4.0

               Red Hat Enterprise Linux Server release 5.8 (Tikanga)

             tnsname配置

TEST =

  (DESCRIPTION =

    (ADDRESS_LIST =

      (ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.37.136)(PORT = 1521))

    )

    (CONNECT_DATA =

      (SERVER = DEDICATED)

      (SERVICE_NAME = orcl.oracle11)

The command completed successfully

tnsping是的问题

[ oracle@oracle10  admin]$ tnsping test  

TNS Ping Utility for Linux: Version 10.2.0.4.0 - Production on 08-DEC-2014 15:24:04  

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

Used parameter files:  


Used TNSNAMES adapter to resolve the alias  
Attempting to contact (DESCRIPTION = (ADDRESS_LIST = (ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.37.136)(PORT = 1521))) (CONNECT_DATA = (SERVER = DEDICATED) (SERVICE_NAME = orcl.oracle11)))  
TNS-12560: TNS:protocol adapter error

分析：配置文件及监听配置都没问题，数据库也正常

在网上查出类似问题，发现是服务器端端口问题

[ root@oracle11  /]# vi etc/sysconfig/iptables  
# Firewall configuration written by system-config-securitylevel  
# Manual customization of this file is not recommended.  
*filter  
:INPUT ACCEPT [0:0]  
:FORWARD ACCEPT [0:0]  
:OUTPUT ACCEPT [0:0]  
:RH-Firewall-1-INPUT - [0:0]  
-A INPUT -j RH-Firewall-1-INPUT  
-A FORWARD -j RH-Firewall-1-INPUT  
-A RH-Firewall-1-INPUT -i lo -j ACCEPT  
-A RH-Firewall-1-INPUT -p icmp --icmp-type any -j ACCEPT  
-A RH-Firewall-1-INPUT -p 50 -j ACCEPT  
-A RH-Firewall-1-INPUT -p 51 -j ACCEPT  
-A RH-Firewall-1-INPUT -p udp --dport 5353 -d 224.0.0.251 -j ACCEPT  
-A RH-Firewall-1-INPUT -p udp -m udp --dport 631 -j ACCEPT  
-A RH-Firewall-1-INPUT -p tcp -m tcp --dport 631 -j ACCEPT  
-A RH-Firewall-1-INPUT -m state --state ESTABLISHED,RELATED -j ACCEPT  
-A RH-Firewall-1-INPUT -m state --state NEW -m tcp -p tcp --dport 21 -j ACCEPT  
-A RH-Firewall-1-INPUT -m state --state NEW -m tcp -p tcp --dport 2049 -j ACCEPT  
-A RH-Firewall-1-INPUT -m state --state NEW -m tcp -p tcp --dport 22 -j ACCEPT  
-A RH-Firewall-1-INPUT -m state --state NEW -m udp -p udp --dport 137 -j ACCEPT  
-A RH-Firewall-1-INPUT -m state --state NEW -m udp -p udp --dport 138 -j ACCEPT  
-A RH-Firewall-1-INPUT -m state --state NEW -m tcp -p tcp --dport 139 -j ACCEPT  
-A RH-Firewall-1-INPUT -m state --state NEW -m tcp -p tcp --dport 445 -j ACCEPT  
-A RH-Firewall-1-INPUT -m state --state NEW -m tcp -p tcp --dport 23 -j ACCEPT  
-A RH-Firewall-1-INPUT -m state --state NEW -m tcp -p tcp --dport 80 -j ACCEPT  
-A RH-Firewall-1-INPUT -j REJECT --reject-with icmp-host-prohibited          
-A RH-Firewall-1-INPUT -m state --state NEW -m tcp -p tcp --dport 1520:1523 -j ACCE   现加的 
COMMIT  
~  
~  
~ 、
"etc/sysconfig/iptables" 29L, 1593C written

更改后 重启防火墙可以ping通。
service iptables restart

[oracle@oracle10 admin]$ tnsping  test

TNS Ping Utility for Linux: Version 10.2.0.4.0 - Production on 08-DEC-2014 15:47:53

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

Used parameter files:

Used TNSNAMES adapter to resolve the alias
Attempting to contact (DESCRIPTION = (ADDRESS_LIST = (ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.37.136)(PORT = 1521))) (CONNECT_DATA = (SERVER = DEDICATED) (SERVICE_NAME = orcl.oracle11)))
OK (0 msec)

来自 “ ITPUB博客 ” ，链接：http://blog.itpub.net/30134870/viewspace-1433454/，如需转载，请注明出处，否则将追究法律责任。

转载于:http://blog.itpub.net/30134870/viewspace-1433454/