11.1.0.6遇到TNS-12560错误(bug)
Kevin Zou
2011-9-6
在一个WINDOWS 2008+ ORACLE 11.1.0.6上有发现一个奇怪的问题:
在上面做tnsping一个其他server可以正常访问的tns都报: TNS-12560: TNS:protocol adapter error的错误。
D:\oracle\product\11.1.0\network\admin\sqlnet.ora
Used TNSNAMES adapter to resolve the alias
Attempting to contact (DESCRIPTION = (ADDRESS = (PROTOCOL = TCP)(HOST = SJWINPPMDB01.hitachigst.global)(PORT = 1527))
(CONNECT_DATA = (SERVER = DEDICATED) (SERVICE_NAME = rmanp)))
TNS-12560: TNS:protocol adapter error
修改PORT后,尝试启动LISTENER时也有报错:
LSNRCTL for 64-bit Windows: Version 11.1.0.6.0 - Production on 05-SEP-2011 0