oracle数据库ORA-12541TNS无监听程序-错误解决方法

在用PL/SQLDeveloper连接数据库时出现“ORA-12541:TNS:无监听程序”错误。1、检查listener.log日志发现下面错误：TNSLSNRfor32-bitWindows:Version10.2.0.1.0-Productionon20-9月-200810:25:26Copyright(c)1991,2005,Oracle.Allrightsreserved.系统参数文件为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-bitWindowsError:49:Unknownerror不再监听:(DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(PIPENAME=\\.\pipe\EXTPROC1ipc)))2、查看Oracle的listener是否启动C:\DocumentsandSettings\mengzhaolianglsnrctlstatusLSNRCTLfor32-bitWindows:Version10.2.0.1.0-Productionon20-9月-200810:50:44Copyright(c)1991,2005,Oracle.Allrightsreserved.正在连接到(DESCRIPTION=(ADDRESS=(PROTOCOL=IPC)(KEY=EXTPROC1)))TNS-12541:TNS:无监听程序TNS-12560:TNS:协议适配器错误TNS-00511:无监听程序32-bitWindowsError:2:Nosuchfileordirectory正在连接到(DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=0.5.0.5)(PORT=1521)))TNS-12535:TNS:操作超时TNS-12560:TNS:协议适配器错误TNS-00505:操作超时32-bitWindowsError:60:Unknownerror原来没有启动listener，用“lsnrctlstart”命令也不能启动。C:\DocumentsandSettings\mengzhaolianglsnrctlstartLSNRCTLfor32-bitWindows:Version10.2.0.1.0-Productionon20-9月-200810:52:16Copyright(c)1991,2005,Oracle.Allrightsreserved.启动tnslsnr:请稍候...TNSLSNRfor32-bitWindows:Version10.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-bitWindowsError:49:Unknownerror监听程序未能启动。请参阅上面的错误消息...3、查看listener.ora的内容：#listener.oraNetworkConfigurationFile:D:\oracle\product\10.2.0\db_1\network\admin\listener.ora#GeneratedbyOracleconfigurationtools.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:\DocumentsandSettings\mengzhaolianglsnrctlstartLSNRCTLfor32-bitWindows:Version10.2.0.1.0-Productionon20-9月-200810:54:40Copyright(c)1991,2005,Oracle.Allrightsreserved.启动tnslsnr:请稍候...TNSLSNRfor32-bitWindows:Version10.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版本TNSLSNRfor32-bitWindows:Version10.2.0.1.0-Production启动日期20-9月-200810:54:41正常运行时间0天0小时0分1秒跟踪级别off安全性ON:LocalOSAuthenticationSNMPOFF监听程序参数文件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/SQLDeveloper再次连接数据库出现下面错误：TNS-12514:TNS:监听程序当前无法识别连接描述符中请求的服务再次检查listener.log日志20-9月-200811:01: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:\DocumentsandSettings\mengzhaolianglsnrctlservicesLSNRCTLfor32-bitWindows:Version10.2.0.1.0-Productionon20-9月-200811:11:09Copyright(c)1991,2005,Oracle.Allrightsreserved.正在连接到(DESCRIPTION=(ADDRESS=(PROTOCOL=IPC)(KEY=EXTPROC1)))服务摘要..服务PLSExtProc包含1个例程。例程PLSExtProc,状态UNKNOWN,包含此服务的1个处理程序...处理程序:DEDICATED已建立:0已被拒绝:0LOCALSERVER命令执行成功7、用sqlplus也出现同样错误：C:\DocumentsandSettings\mengzhaoliangsqlplusscott/mzl@ORCL_127.0.0.1SQL*Plus:Release10.2.0.1.0-Productionon星期六9月2011:15:092008Copyright(c)1982,2005,Oracle.Allrightsreserved.ERROR:ORA-12514:TNS:监听程序当前无法识别连接描述符中请求的服务8、查看listenser状态：C:\DocumentsandSettings\mengzhaolianglsnrctlstatusLSNRCTLfor32-bitWindows:Version10.2.0.1.0-Productionon20-9月-200811:26:42Copyright(c)1991,2005,Oracle.Allrightsreserved.正在连接到(DESCRIPTION=(ADDRESS=(PROTOCOL=IPC)(KEY=EXTPROC1)))LISTENER的STATUS------------------------别名LISTENER版本TNSLSNRfor32-bitWindows:Version10.2.0.1.0-Production启动日期20-9月-2