用PL/SQL时,出现ORA-12541:TNS:没有监听程序
C:\Documents and Settings\Administrator>lsnrctl start
启动tnslsnr: 请稍候...
TNSLSNR for 32-bit Windows: Version 10.1.0.2.0 - Production
系统参数文件为D:\oracle\product\10.1.0\db_1\network\admin\listener.ora
写入D:\oracle\product\10.1.0\db_1\network\log\listener.log的日志信息
监听该对象时出错: (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=127.0.0.1)(PORT=1521
)))
TNS-12545: 因目标主机或对象不存在, 连接失败
TNS-12560: TNS: 协议适配器错误
TNS-00515: 因目标主机或对象不存在, 连接失败
32-bit Windows Error: 49: Unknown error
监听程序未能启动。请参阅上面的错误消息...
NETWORK\ADMIN下的Listener的内容是:
LISTENER =
(DESCRIPTION_LIST =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST =127.0.0.1)(PORT = 1521))
)
)
)
tnsnames的内容是:
ORCL =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = 127.0.0.1)(PORT = 1521))
)
(CONNECT_DATA =
(SERVICE_NAME = ORCL)
)
)