oracle TNS-01150: 指定侦听器名称的地址不正确
声明：本页面是StackOverFlow热门问题的中英对照翻译，遵循CC BY-SA 4.0协议，如果您需要使用它，必须同样遵循CC BY-SA许可，注明原文地址和作者信息，同时你必须将它归于原作者（不是我）：StackOverFlow
原文地址: http://stackoverflow.com/questions/8120814/
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
TNS-01150: The address of the specified listener name is incorrect
提问by En-Motion
Trying to install an Oracle DB.
尝试安装 Oracle DB。
When I run:
当我运行时：
lsnrctl start ${ORACLE_SID}
I get the following error:
我收到以下错误：
Listening on: (DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(KEY=orcl)))
TNS-01150: The address of the specified listener name is incorrect
TNS-01153: Failed to process string: (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=localhost.localdomain)(PORT=)))
Listener failed to start. See the error message(s) above...
My listener.ora file is as follows:
我的listener.ora文件如下：
#
# orcl Listener
#
orcl =
(DESCRIPTION_LIST =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = IPC) (KEY = orcl))
(ADDRESS = (PROTOCOL = TCP) (HOST = localhost.localdomain) (PORT = ))
)
)
)
SID_LIST_orcl =
(SID_LIST =
(SID_DESC =
(GLOBAL_DBNAME = orcl)
(SID_NAME = orcl)
(ORACLE_HOME = /home/oracle/product/11.1.0/db_1)
)
)
LOG_DIRECTORY_orcl=/home/oracle/admin/orcl/log
LOG_FILE_orcl=orcl.log
LOGGING_orcl=ON
TRACE_DIRECTORY_orcl=/home/oracle/admin/orcl/log
TRACE_FILE_orcl=orcl.trc
TRACE_LEVEL_orcl=OFF
Does anyone know where I should be checking for possible causes to fail?
有谁知道我应该在哪里检查失败的可能原因？
回答by APC
Assuming it isn't a typo in your post, you have not assigned a port number for the listener:
假设它不是您帖子中的错字，您还没有为侦听器分配端口号：
(PORT = )
Try port 1521: it's traditional :)
尝试端口 1521：这是传统的 :)
(PORT = 1521)
