在用PL/SQL Developer连接数据库时出现&ORA-12541:TNS:无监听程序&错误。
1、检查listener.log日志发现下面错误：TNSLSNR for 32-bit Windows: Version 10.2.0.1.0 - Production on 20-9月 -:26
Copyright (c) , Oracle. All rights reserved.
系统参数文件为D:/oracle/product/10.2.0/db_1/network/admin/listener.ora写入D:/oracle/product/10.2.0/db_1/network/log/listener.log的日志信息写入D:/oracle/product/10.2.0/db_1/network/trace/listener.trc的跟踪信息跟踪级别当前为0
以 pid=1704 开始监听: (DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(PIPENAME=//./pipe/EXTPROC1ipc)))监听该对象时出错: (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=0.5.0.5)(PORT=1521)))TNS-12545: 因目标主机或对象不存在, 连接失败TNS-12560: TNS: 协议适配器错误TNS-00515: 因目标主机或对象不存在, 连接失败32-bit Windows Error: 49: Unknown error不再监听: (DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(PIPENAME=//./pipe/EXTPROC1ipc)))
2、查看Oracle的listener是否启动C:/Documents and Settings/mengzhaoliang&lsnrctl status
LSNRCTL for 32-bit Windows: Version 10.2.0.1.0 - Production on 20-9月 -0:44
Copyright (c) , Oracle. All rights reserved.
正在连接到 (DESCRIPTION=(ADDRESS=(PROTOCOL=IPC)(KEY=EXTPROC1)))TNS-12541: TNS: 无监听程序TNS-12560: TNS: 协议适配器错误TNS-00511: 无监听程序32-bit Windows Error: 2: No such file or directory正在连接到 (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=0.5.0.5)(PORT=1521)))TNS-12535: TNS: 操作超时TNS-12560: TNS: 协议适配器错误TNS-00505: 操作超时32-bit Windows Error: 60: Unknown error
原来没有启动listener，用&lsnrctl start&命令也不能启动。C:/Documents and Settings/mengzhaoliang&lsnrctl start
LSNRCTL for 32-bit Windows: Version 10.2.0.1.0 - Production on 20-9月 -2:16
Copyright (c) , Oracle. All rights reserved.
启动tnslsnr: 请稍候...
TNSLSNR for 32-bit Windows: Version 10.2.0.1.0 - Production系统参数文件为D:/oracle/product/10.2.0/db_1/network/admin/listener.ora写入D:/oracle/product/10.2.0/db_1/network/log/listener.log的日志信息监听: (DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(PIPENAME=//./pipe/EXTPROC1ipc)))监听该对象时出错: (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=0.5.0.5)(PORT=1521)))TNS-12545: 因目标主机或对象不存在, 连接失败TNS-12560: TNS: 协议适配器错误TNS-00515: 因目标主机或对象不存在, 连接失败32-bit Windows Error: 49: Unknown error
监听程序未能启动。请参阅上面的错误消息...
3、查看listener.ora的内容：# listener.ora Network Configuration File: D:/oracle/product/10.2.0/db_1/network/admin/listener.ora# Generated by Oracle configuration tools.
SID_LIST_LISTENER =(SID_LIST =(SID_DESC =(SID_NAME = PLSExtProc)(ORACLE_HOME = D:/oracle/product/10.2.0/db_1)(PROGRAM = extproc)))LISTENER =(DESCRIPTION_LIST =(DESCRIPTION =(ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1))(ADDRESS = (PROTOCOL = TCP)(HOST = 0.5.0.5)(PORT = 1521))))
原来本机的ip发生改变后，就出现了上述问题，改变数据库的监听ip地址:把(ADDRESS = (PROTOCOL = TCP)(HOST = 0.5.0.5)(PORT = 1521))改成(ADDRESS = (PROTOCOL = TCP)(HOST = 127.0.0.1)(PORT = 1521))
127.0.0.1：也就是目前数据库正在用的ip地址。
4、再次启动oracle的listenerC:/Documents and Settings/mengzhaoliang&lsnrctl start
LSNRCTL for 32-bit Windows: Version 10.2.0.1.0 - Production on 20-9月 -4:40
Copyright (c) , Oracle. All rights reserved.
启动tnslsnr: 请稍候...
TNSLSNR for 32-bit Windows: Version 10.2.0.1.0 - Production系统参数文件为D:/oracle/product/10.2.0/db_1/network/admin/listener.ora写入D:/oracle/product/10.2.0/db_1/network/log/listener.log的日志信息监听: (DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(PIPENAME=//./pipe/EXTPROC1ipc)))监听: (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=127.0.0.1)(PORT=1521)))
正在连接到 (DESCRIPTION=(ADDRESS=(PROTOCOL=IPC)(KEY=EXTPROC1)))LISTENER 的 STATUS------------------------别名&&&&&&&&&&&&&&&&&&&&& LISTENER版本&&&&&&&&&&&&&&&&&&&&& TNSLSNR for 32-bit Windows: Version 10.2.0.1.0 - Production启动日期&&&&&&&&&&&&&&&&& 20-9月 -:41正常运行时间&&&&&&&&&&&&& 0 天 0 小时 0 分 1 秒跟踪级别&&&&&&&&&&&&&&&&& off安全性&&&&&&&&&&&&&&&&&&& ON: Local OS AuthenticationSNMP&&&&&&&&&&&&&&&&&&&&& OFF监听程序参数文件&&&&&&&&& D:/oracle/product/10.2.0/db_1/network/admin/listener.ora监听程序日志文件&&&&&&&&& D:/oracle/product/10.2.0/db_1/network/log/listener.log
监听端点概要...(DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(PIPENAME=//./pipe/EXTPROC1ipc)))(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=127.0.0.1)(PORT=1521)))服务摘要..服务 "PLSExtProc" 包含 1 个例程。例程 "PLSExtProc", 状态 UNKNOWN, 包含此服务的 1 个处理程序...命令执行成功
启动已经成功，
5.再tnsnames.ora上添加上ORCL_127.0.0.1 =(DESCRIPTION =(ADDRESS = (PROTOCOL = TCP)(HOST = 127.0.0.1)(PORT = 1521))(CONNECT_DATA =(SERVER = DEDICATED)(SERVICE_NAME = orcl)))
6、再次用PL/SQL Developer再次连接数据库出现下面错误：TNS-12514: TNS: 监听程序当前无法识别连接描述符中请求的服务
再次检查listener.log日志20-9月 -:54 * (CONNECT_DATA=(SERVER=DEDICATED)(SERVICE_NAME=orcl)(CID=
(PROGRAM=D:/plsql/plsqldev.exe)(HOST=RUIFEI-EF0ADC98)(USER=mengzhaoliang))) * (ADDRESS=
(PROTOCOL=tcp)(HOST=127.0.0.1)(PORT=1267)) * establish * orcl * 12514TNS-12514: TNS: 监听程序当前无法识别连接描述符中请求的服务
查看listener：C:/Documents and Settings/mengzhaoliang&lsnrctl services
LSNRCTL for 32-bit Windows: Version 10.2.0.1.0 - Production on 20-9月 -1:09
Copyright (c) , Oracle. All rights reserved.
正在连接到 (DESCRIPTION=(ADDRESS=(PROTOCOL=IPC)(KEY=EXTPROC1)))服务摘要..服务 "PLSExtProc" 包含 1 个例程。例程 "PLSExtProc", 状态 UNKNOWN, 包含此服务的 1 个处理程序...处理程序:"DEDICATED" 已建立:0 已被拒绝:0LOCAL SERVER命令执行成功
7、用sqlplus也出现同样错误：C:/Documents and Settings/mengzhaoliang&sqlplusscott/mzl@ORCL_127.0.0.1
SQL*Plus: Release 10.2.0.1.0 - Production on 星期六 9月 20 11:15:09 2008
Copyright (c) , Oracle. All rights reserved.
ERROR:ORA-12514: TNS: 监听程序当前无法识别连接描述符中请求的服务
8、查看listenser状态：C:/Documents and Settings/mengzhaoliang&lsnrctl status
LSNRCTL for 32-bit Windows: Version 10.2.0.1.0 - Production on 20-9月 -6:42
Copyright (c) , Oracle. All rights reserved.
正在连接到 (DESCRIPTION=(ADDRESS=(PROTOCOL=IPC)(KEY=EXTPROC1)))LISTENER 的 STATUS------------------------别名&&&&&&&&&&&&&&&&&&&&& LISTENER版本&&&&&&&&&&&&&&&&&&&&& TNSLSNR for 32-bit Windows: Version 10.2.0.1.0 - Production启动日期&&&&&&&&&&&&&&&&& 20-9月 -:33正常运行时间&&&&&&&&&&&&& 0 天 0 小时 2 分 8 秒跟踪级别&&&&&&&&&&&&&&&&& off安全性&&&&&&&&&&&&&&&&&&& ON: Local OS AuthenticationSNMP&&&&&&&&&&&&&&&&&&&&& OFF监听程序参数文件&&&&&&&&& D:/oracle/product/10.2.0/db_1/network/admin/listener.ora监听程序日志文件&&&&&&&&& D:/oracle/product/10.2.0/db_1/network/log/listener.log
监听端点概要...(DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(PIPENAME=//./pipe/EXTPROC1ipc)))(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=127.0.0.1)(PORT=1521)))服务摘要..服务 "PLSExtProc" 包含 1 个例程。例程 "PLSExtProc", 状态 UNKNOWN, 包含此服务的 1 个处理程序...命令执行成功
C:/Documents and Settings/mengzhaoliang&tnsping orcl
TNS Ping Utility for 32-bit Windows: Version 10.2.0.1.0 - Production on 20-9月 -:43
Copyright (c) , Oracle. All rights reserved.
已使用的参数文件:D:/oracle/product/10.2.0/db_1/network/admin/sqlnet.ora
TNS-03505: 无法解析名称
9、查看sqlnet.ora内容：# sqlnet.ora Network Configuration File: D:/oracle/product/10.2.0/db_1/network/admin/sqlnet.ora# Generated by Oracle configuration tools.
# This file is actually generated by netca. But if customers choose to# install "Software Only", this file wont exist and without the native# authentication, they will not be able to connect to the database on NT.
SQLNET.AUTHENTICATION_SERVICES= (NTS)
NAMES.DIRECTORY_PATH= (TNSNAMES, EZCONNECT)
10.把listener.ora的内容：# listener.ora Network Configuration File: D:/oracle/product/10.2.0/db_1/network/admin/listener.ora# Generated by Oracle configuration tools.
SID_LIST_LISTENER =(SID_LIST =(SID_DESC =&&&&& (SID_NAME = PLSExtProc)(ORACLE_HOME = D:/oracle/product/10.2.0/db_1)&&&&& (PROGRAM = extproc)))
LISTENER =(DESCRIPTION_LIST =(DESCRIPTION =(ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1))(ADDRESS = (PROTOCOL = TCP)(HOST = 127.0.0.1)(PORT = 1521))))
改成下面的内容：
# listener.ora Network Configuration File: D:/oracle/product/10.2.0/db_1/network/admin/listener.ora# Generated by Oracle configuration tools.
SID_LIST_LISTENER =(SID_LIST =(SID_DESC =&&&&& (SID_NAME = orcl)(ORACLE_HOME = D:/oracle/product/10.2.0/db_1)#&&&&& (PROGRAM = extproc)))
LISTENER =(DESCRIPTION_LIST =(DESCRIPTION =(ADDRESS = (PROTOCOL = IPC)(KEY = orcl))(ADDRESS = (PROTOCOL = TCP)(HOST = 127.0.0.1)(PORT = 1521))))
11、然后关闭、再启动listener在cmd中执行&lsnrctl stop& 和&lsnrctl stop&命令，再次登陆正常！C:/Documents and Settings/mengzhaoliang&sqlplus&
SQL*Plus: Release 10.2.0.1.0 - Production on 星期六 9月 20 11:55:47 2008
Copyright (c) , Oracle. All rights reserved.
连接到:Oracle Database 10g Enterprise Edition Release 10.2.0.1.0 - ProductionWith the Partitioning, OLAP and Data Mining options
再次用PL/SQL Peveloper登陆就没有问题了。
我通过以上步骤我的问题还没解决，然后重启了一下OracleOraDb10g_home1TNSListener服务就行了
阅读(...) 评论()ORA-12541:&TNS:&无监听程序
我最近遇到这种情况是使用10g的客户端连接11g R2的数据的时候出现的
客户端所在机器IP:192.168.6.97(Oracle 10g客户端) 主机A
服务器端所在机器IP:192.168.6.99(Oracle 11g R2) 主机B
首先检查主机B的TNSListener服务是否已启动,如果已启动,然后按照下面的顺序判断问题原因
1.尝试检查网络原因,从主机A ping 主机B
ping 192.168.6.99,如下图,两台机器间网络是通的
2.使用tnsping命令检查oracle客户端与服务器端的tns连接是否通
tnsping 192.168.6.99:1521/demo
结果如下图:
结果显示是主机A到主机B的oracle tns还是不通的
3.在主机B上通过lsnrctl
status命令,检查主机B的Oracle监听是否工作正常
下图是连接正常的截图,如果途中红圈标注出显示命令执行成功,则说明主机B的TNS服务正常
显示主机B的监听正常
如上判断了问题的情况,主机B的监听服务器已启动--&主机A到主机B的网络通讯正常--&主机A到主机B的Oralce
tns通讯不正常--&主机B的监听工作正常
接下来就是如何解决了:
根据遇到监听问题的经验,解决本案例中出现的情况,有一个妙招,呵呵
重新创建主机B的TNSlistener(删除再创建)
我是这么解决的!
已投稿到：
以上网友发言只代表其个人观点，不代表新浪网的观点或立场。其他回答(1)
根据tnsnames.ora修改
&&&您需要以后才能回答，未注册用户请先。& & 如果出现oracle提示ERROR - ORA-12541: TNS:无监听程序，那么就依照下列步骤做，这是因为你的分配的地址不对。& & 查看\oracle\product\10.2.0\db_1\network\admin\tnsnames.ora文件，用记事本打开，显示oracle值：& & ORACLE =&……
声明：该文章系网友上传分享，此内容仅代表网友个人经验或观点，不代表本网站立场和观点；若未进行原创声明，则表明该文章系转载自互联网；若该文章内容涉嫌侵权，请及时向
论文写作技巧
上一篇：下一篇：
相关经验教程