ORA-12541:TNS:no listener

最新推荐文章于 2025-06-05 08:13:36 发布

秦江波

最新推荐文章于 2025-06-05 08:13:36 发布

阅读量1.4k

点赞数

CC 4.0 BY-SA版权

分类专栏： Oracle DB

本文链接：https://blog.csdn.net/u011763190/article/details/23119473

Oracle DB 专栏收录该内容

12 篇文章

订阅专栏

本文介绍如何修改Oracle数据库listener.ora文件中的SID名称及监听地址等关键配置，并提供了具体的步骤和示例代码。通过这些操作可以实现数据库的正常连接。

摘要生成于 C知道，由 DeepSeek-R1 满血版支持，前往体验 >

更改listener.ora里面的内容

把listener.ora的内容：

# listener.ora Network Configuration File: D:\oracle\product\10.2.0\db_1\network\admin\listener.ora
# Generated by Oracle configuration tools.

SID_LIST_LISTENER =
(SID_LIST =
(SID_DESC =
(SID_NAME = PLSExtProc)
(ORACLE_HOME = D:\oracle\product\10.2.0\db_1)
(PROGRAM = extproc)
)
)

LISTENER =
(DESCRIPTION_LIST =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1))
(ADDRESS = (PROTOCOL = TCP)(HOST = 127.0.0.1)(PORT = 1521))
)
)

改成下面的内容：

# listener.ora Network Configuration File: D:\oracle\product\10.2.0\db_1\network\admin\listener.ora
# Generated by Oracle configuration tools.

SID_LIST_LISTENER =
(SID_LIST =
(SID_DESC =
(SID_NAME = orcl)
(ORACLE_HOME = D:\oracle\product\10.2.0\db_1)
# (PROGRAM = extproc)
)
)

LISTENER =
(DESCRIPTION_LIST =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = IPC)(KEY = orcl))
(ADDRESS = (PROTOCOL = TCP)(HOST = 127.0.0.1)(PORT = 1521))
)
)
然后关闭、再启动listener
在cmd中执行“lsnrctl stop” 和“lsnrctl start”命令，再次登陆正常！