由于修改机器名导致Oracle TNS Listener不能启动
原来安装oracle的时候机器名是 HOST=user49561
修改以后,在控制面板的服务中启动OracleTNSLisener服务立刻就停止
改用命令行工具:
lsnrctl
start
发现提示:
TNSLSNR for 32-bit Windows: Version 9.2.0.1.0 - Production
System parameter file is D:\oracle\ora92\network\admin\listener.ora
Log messages written to D:\oracle\ora92\network\log\listener.log
Listening on: (DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(PIPENAME=\\.\pipe\EXTPROC0ipc
)))
Error listening on: (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=user49561)(PORT=15
21)))
TNS-12545: Connect failed because target host or object does not exist
TNS-12560: TNS:protocol adapter error
TNS-00515: Connect failed because target host or object does not exist
32-bit Windows Error: 1001: Unknown error
Listener failed to start. See the error message(s) above...
原来如此