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\\mengzhaoliang>lsnrctlstatusLSNRCTLfor32-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\\mengzhaoliang>lsnrctlstartLSNRCTLfor32-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\\mengzhaoliang>lsnrctlstartLSNRCTLfor32-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))establishorcl12514TNS-12514:TNS:监听程序当前无法识别连接描述符中请求的服务查看listener：C:\\DocumentsandSettings\\mengzhaoliang>lsnrctlservicesLSNRCTLfor32-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\\mengzhaoliang>sqlplusscott/mzl@ORCL_127.0.0.1SQLPlus:Release10.2.0.1.0-Productionon星期六9月2011:15:092008Copyright(c)1982,2005,Oracle.Allrightsreserved.ERROR:ORA-12514:TNS:监听程序当前无法识别连接描述符中请求的服务8、查看listenser状态：C:\\DocumentsandSettings\\mengzhaoliang>lsnrctlstatusLSNRCTLfor32-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月-200811:24:33正常运行时间0天0小时2分8秒跟踪级别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个处理程序...命令执行成功C:\\DocumentsandSettings\\mengzhaoliang>tnspingorclTNSPingUtilityfor32-bitWindows:Version10.2.0.1.0-Productionon20-9月-200811:27:43Copyright(c)1997,2005,Oracle.Allrightsreserved.已使用的参数文件:D:\\oracle\\product\\10.2.0\\db_1\\network\\admin\\sqlnet.oraTNS-03505:无法解析名称9、查看sqlnet.ora内容：#sqlnet.oraNetworkConfigurationFile:D:\\oracle\\product\\10.2.0\\db_1\\network\\admin\\sqlnet.ora#GeneratedbyOracleconfigurationtools.#Thisfileisactuallygeneratedbynetca.Butifcustomerschooseto#install"SoftwareOnly",thisfilewontexistandwithoutthenative#authentication,theywillnotbeabletoconnecttothedatabaseonNT.SQLNET.AUTHENTICATION_SERVICES=(NTS)NAMES.DIRECTORY_PATH=(TNSNAMES,EZCONNECT)10.把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=127.0.0.1)(PORT=1521))))改成下面的内容：#listener.oraNetworkConfigurationFile:D:\\oracle\\product\\10.2.0\\db_1\\network\\admin\\listener.ora#GeneratedbyOracleconfigurationtools.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中执行“lsnrctlstop”和“lsnrctlstop”命令，再次登陆正常！C:\\DocumentsandSettings\\mengzhaoliang>sqlplusscott/mzl@orclSQLPlus:Release10.2.0.1.0-Productionon星期六9月2011:55:472008Copyright(c)1982,2005,Oracle.Allrightsreserved.连接到:OracleDatabase10gEnterpriseEditionRelease10.2.0.1.0-ProductionWiththePartitioning,OLAPandDataMiningoptionsSQL>再次用PL/SQLPeveloper登陆就没有问题了。完毕!我通过以上步骤我的问题还没解决，然后重启了一下OracleOraDb10g_home1TNSListener服务就行了',)