文档介绍：解决Oracle无监听错误在用PL/SQLDeveloper连接数据库时出现“ORA-12541:TNS:无监听程序”错误。1、:TNSLSNRfor32-bitWindows:-Productionon20-9月-200810:25:26资料个人收集整理,勿做商业用途Copyright(c)1991,2005,,勿做商业用途系统参数文件为D:\oracle\product\\work\admin\,勿做商业用途写入D:\oracle\product\\work\log\,勿做商业用途写入D:\oracle\product\\work\trace\,勿做商业用途跟踪级别当前为0以pid=1704开始监听:(DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(PIPENAME=\\.\pipe\EXTPROC1ipc)))资料个人收集整理,勿做商业用途监听该对象时出错:(DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=)(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>lsnrctlstatus资料个人收集整理,勿做商业用途LSNRCTLfor32-bitWindows:-Productionon20-9月-200810:5资料个人收集整理,勿做商业用途0:44Copyright(c)1991,2005,,勿做商业用途正在连接到(DESCRIPTION=(ADDRESS=(PROTOCOL=IPC)(KEY=EXTPROC1)))资料个人收集整理,勿做商业用途TNS-12541:TNS:无监听程序TNS-12560:TNS:协议适配器错误TNS-00511:无监听程序32-bitWindowsError:2:Nosuchfileordirectory正在连接到(DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=)(PORT=1521)))资料个人收集整理,勿做商业用途TNS-12535:TNS:操作超时TNS-12560:TNS:协议适配器错误TNS-00505:操作超时32-bitWindowsError:60:Unknownerror原来没有启动listener,用“lsnrctlstart”命令也不能启动。C:\DocumentsandSettings\mengzhaoliang>lsnrctlstart资料个人收集整理,勿做商业用途LSNRCTLfor32-bitWindows:-Productionon20-9月-200810:5资料个人收集整理,勿做商业用途2:16Copyright(c)1991,2005,,勿做商业用途启动tnslsnr:请稍候...TNSLSNRfor32-bitWindows:-Production资料个人收集整理,勿做商业用途系统参数文件为D:\oracle\product\\work\admin\,勿做商业用途写入D:\oracle\product\\work\log\,勿做商业用途监听:(DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(PIPENAME=\\.\pipe\EXTPROC1ipc)))资料个人收集整理,勿做商业用途监听该对象时出错:(DESCRIPTION=(ADDRESS