tnsping报TNS-12541: TNS:no listener

来源：互联网发布：sas软件好学吗编辑：程序博客网时间：2024/04/30 00:42

案例：
在windows的oracle实例orcl中可以正常添加linux中oracle的dblink
在linux中编辑tnsnames.ora后无法tnsping通windows中的实例orcl

[oracle@rac1 admin]$ tnsping orclTNS Ping Utility for Linux: Version 11.2.0.4.0 - Production on 04-FEB-2015 21:25:01Copyright (c) 1997, 2013, Oracle.  All rights reserved.Used parameter files:Used TNSNAMES adapter to resolve the aliasAttempting to contact (DESCRIPTION = (ADDRESS = (PROTOCOL = TCP)(HOST = orcl)(PORT = 1521)) (CONNECT_DATA = (SERVER = DEDICATED) (SERVICE_NAME = orcl.digitalchina.com)))TNS-12541: TNS:no listener

报错内容显示在windwos服务端中没有监听程序
此时检查windows端的监听程序显示正常

C:\Users\zhaixya>lsnrctl statusLSNRCTL for 64-bit Windows: Version 11.2.0.1.0 - Production on 01-3月 -2015 13:06:57Copyright (c) 1991, 2010, Oracle.  All rights reserved.正在连接到 (DESCRIPTION=(ADDRESS=(PROTOCOL=IPC)(KEY=EXTPROC1521)))LISTENER 的 STATUS------------------------别名                      LISTENER版本                      TNSLSNR for 64-bit Windows: Version 11.2.0.1.0 - Production启动日期                  01-3月 -2015 11:37:19正常运行时间              0 天 1 小时 29 分 42 秒跟踪级别                  off安全性                    ON: Local OS AuthenticationSNMP                      OFF监听程序参数文件          D:\app\zhaixya\product\11.2.0\dbhome_1\network\admin\listener.ora监听程序日志文件          d:\app\zhaixya\diag\tnslsnr\ZHAIXYA-3\listener\alert\log.xml监听端点概要...  (DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(PIPENAME=\\.\pipe\EXTPROC1521ipc)))  (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=127.0.0.1)(PORT=1521)))服务摘要..服务 "CLRExtProc" 包含 1 个实例。  实例 "CLRExtProc", 状态 UNKNOWN, 包含此服务的 1 个处理程序...服务 "orcl.digitalchina.com" 包含 1 个实例。  实例 "orcl", 状态 READY, 包含此服务的 1 个处理程序...服务 "orclXDB.digitalchina.com" 包含 1 个实例。  实例 "orcl", 状态 READY, 包含此服务的 1 个处理程序...命令执行成功

起初怀疑是在客户端中tnsnames.ora中存在错误，将ip地址更换为主机名且添加入hosts文件无效。
然后怀疑是在sqlnet.ora文件中

SQLNET.AUTHENTICATION_SERVICES= (NONE)

更换nts，none都无效。

解决方法

在客户端监听启动过程中使用的文件D:\app\zhaixya\product\11.2.0\dbhome_1\network\admin\listener.ora
不存在和linux中客户端tnsnames中记录的ip地址。
在listener.ora中加入一行

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

问题解决

[oracle@rac1 admin]$ tnsping orclTNS Ping Utility for Linux: Version 11.2.0.4.0 - Production on 04-FEB-2015 21:25:01Copyright (c) 1997, 2013, Oracle.  All rights reserved.Used parameter files:Used TNSNAMES adapter to resolve the aliasAttempting to contact (DESCRIPTION = (ADDRESS = (PROTOCOL = TCP)(HOST = orcl)(PORT = 1521)) (CONNECT_DATA = (SERVER = DEDICATED) (SERVICE_NAME = orcl.digitalchina.com)))TNS-12541: TNS:no listener[oracle@rac1 admin]$ tnsping orclTNS Ping Utility for Linux: Version 11.2.0.4.0 - Production on 04-FEB-2015 21:27:28Copyright (c) 1997, 2013, Oracle.  All rights reserved.Used parameter files:Used TNSNAMES adapter to resolve the aliasAttempting to contact (DESCRIPTION = (ADDRESS = (PROTOCOL = TCP)(HOST = orcl)(PORT = 1521)) (CONNECT_DATA = (SERVER = DEDICATED) (SERVICE_NAME = orcl.digitalchina.com)))OK (20 msec)

0 0