oracle 侦听器 lsnrctl start TNS-00515：连接失败，因为目标主机或对象不存在 64 位 Windows 错误：1004：未知错误
声明：本页面是StackOverFlow热门问题的中英对照翻译，遵循CC BY-SA 4.0协议，如果您需要使用它，必须同样遵循CC BY-SA许可，注明原文地址和作者信息，同时你必须将它归于原作者（不是我）：StackOverFlow
原文地址: http://stackoverflow.com/questions/34496097/
Warning: these are provided under cc-by-sa 4.0 license. You are free to use/share it, But you must attribute it to the original authors (not me):
StackOverFlow
Listener lsnrctl start TNS-00515: Connect failed because target host or object does not exist 64-bit Windows Error: 1004: Unknown error
提问by Kondjitsu
I cannot get my listener to start, I have spent hours searching forums and couldn't find any solution. My goal is to start APEX, but first I have to get listener up&running, when I try, I'm getting:
我无法让我的听众开始，我花了几个小时搜索论坛，但找不到任何解决方案。我的目标是启动 APEX，但首先我必须让监听器启动并运行，当我尝试时，我得到：
C:\Users\matulewi>lsnrctl start
C:\Users\matulewi>lsnrctl start
LSNRCTL for 64-bit Windows: Version 11.2.0.2.0 - Production on 28-GRU-2015 15:20:45
用于 64 位 Windows 的 LSNRCTL：版本 11.2.0.2.0 - 生产于 28-GRU-2015 15:20:45
Copyright (c) 1991, 2014, Oracle. All rights reserved.
版权所有 (c) 1991, 2014，甲骨文。版权所有。
Starting tnslsnr: please wait...
正在启动 tnslsnr：请稍候...
TNSLSNR for 64-bit Windows: Version 11.2.0.2.0 - Production System parameter file is C:\oraclexe\app\oracle\product\11.2.0\server\network\admin\listener.ora Log messages written to C:\oraclexe\app\oracle\diag\tnslsnr\MATULEWI1\listener\alert\log.xml Listening on: (DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(PIPENAME=\.\pipe\EXTPROC1ipc))) Error listening on: (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=MATULEWI1.emea.xxxxx.net)(PORT=1521))) 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 64-bit Windows Error: 1004: Unknown error
适用于 64 位 Windows 的 TNSLSNR：版本 11.2.0.2.0 - 生产系统参数文件为 C:\oraclex\app\oracle\product\11.2.0\server\network\admin\listener.ora 日志消息写入 C:\ oraclexe\app\oracle\diag\tnslsnr\MATULEWI1\listener\alert\log.xml 监听：(DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(PIPENAME=\.\pipe\EXTPROC1ipc))) 监听错误：( description=(ADDRESS=(PROTOCOL=TCP)(HOST=MATULEWI1.emea.xxxxx.net)(PORT=1521))) TNS-12545：连接失败，因为目标主机或对象不存在 TNS-12560：TNS：协议适配器错误 TNS-00515：连接失败，因为目标主机或对象不存在 64 位 Windows 错误：1004：未知错误
My tnsnames.ora:
我的 tnsnames.ora：
XE = (DESCRIPTION = (ADDRESS = (PROTOCOL = TCP)(HOST = MATULEWI1.emea.xxxxx.net)(PORT = 1521)) (CONNECT_DATA = (SERVER = DEDICATED) (SERVICE_NAME = XE) ) )
XE = (DESCRIPTION = (ADDRESS = (PROTOCOL = TCP)(HOST = MATULEWI1.emea.xxxxx.net)(PORT = 1521)) (CONNECT_DATA = (SERVER = DEDICATED) (SERVICE_NAME = XE)) )
EXTPROC_CONNECTION_DATA = (DESCRIPTION = (ADDRESS_LIST = (ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1)) ) (CONNECT_DATA = (SID = PLSExtProc) (PRESENTATION = RO) ) )
EXTPROC_CONNECTION_DATA = (DESCRIPTION = (ADDRESS_LIST = (ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1)) ) (CONNECT_DATA = (SID = PLSExtProc) (PRESENTATION = RO) ) )
ORACLR_CONNECTION_DATA = (DESCRIPTION = (ADDRESS_LIST = (ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1)) ) (CONNECT_DATA = (SID = CLRExtProc) (PRESENTATION = RO) ) )
ORACLR_CONNECTION_DATA = (DESCRIPTION = (ADDRESS_LIST = (ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1)) ) (CONNECT_DATA = (SID = CLRExtProc) (PRESENTATION = RO) ) )
listener.ora:
听众.ora：
SID_LIST_LISTENER = (SID_LIST = (SID_DESC = (SID_NAME = PLSExtProc) (ORACLE_HOME = C:\oraclexe\app\oracle\product\11.2.0\server) (PROGRAM = extproc) ) (SID_DESC = (SID_NAME = CLRExtProc) (ORACLE_HOME = C:\oraclexe\app\oracle\product\11.2.0\server) (PROGRAM = extproc) ) )
SID_LIST_LISTENER = (SID_LIST = (SID_DESC = (SID_NAME = PLSExtProc) (ORACLE_HOME = C:\oraclexe\app\oracle\product\11.2.0\server) (PROGRAM = extproc) ) (SID_DESC = (SID_NAME = CLRExtProc) (SID_NAME = CLRExtProc) C:\oraclex\app\oracle\product\11.2.0\server) (PROGRAM = extproc) ) )
LISTENER = (DESCRIPTION_LIST = (DESCRIPTION = (ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1)) (ADDRESS = (PROTOCOL = TCP)(HOST = MATULEWI1.emea.xxxxx.net)(PORT = 1521)) ) )
LISTENER = (DESCRIPTION_LIST = (DESCRIPTION = (ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1)) (ADDRESS = (PROTOCOL = TCP)(HOST = MATULEWI1.emea.xxxxx.net)(PORT = 1521))) )
DEFAULT_SERVICE_LISTENER = (XE)
DEFAULT_SERVICE_LISTENER = (XE)
Could somebody please help out?
有人可以帮忙吗？
k.
克。
回答by Nebster
I got this error because I renamed my computer.
我收到此错误是因为我重命名了我的计算机。
Fixed it when I corrected the listener.ora file.
当我更正 listener.ora 文件时修复了它。
(ADDRESS = (PROTOCOL = TCP)(HOST = YourComputerName)(PORT = 1521))
