当前位置:Gxlcms > mysql > 遭遇TNS-01150:Theaddressofthespecifiedlistenernameisi

遭遇TNS-01150:Theaddressofthespecifiedlistenernameisi

时间:2021-07-01 10:21:17 帮助过:33人阅读

Oracle数据库监听起不来,按以上错误提示应该是listener.ora文件配置错误。

遭遇TNS-01150: The address of the specified listener name is incorrect

[日期:2012-12-07] 来源:Linux社区 作者:cl_oud999 [字体:]

Oracle数据库监听起不来,按以上错误提示应该是listener.ora文件配置错误。
这个文件很烦人,排版不一样就能导致出错.....
最后搞定了,正确模板如下:


SID_LIST_LISTENER =
(SID_LIST =
(SID_DESC =
(SID_NAME = PLSExtProc)
(ORACLE_HOME = /oracle/product/10.2.0/db_1)
(PROGRAM = extproc)
)
(SID_DESC =
(GLOBAL_DBNAME = orcl)
(ORACLE_HOME = /oracle/product/10.2.0/db_1)
(SID_NAME = orcl)
)
)
LISTENER =
(DESCRIPTION_LIST =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1))
(ADDRESS = (PROTOCOL = TCP)(HOST = localhost)(PORT = 1521))
)
)

linux

  • 0
  • HBase集群RegionServer节点扩容性能验证

    不同用户下使用tnsping+客户端服务名,,结果不同

    人气教程排行