“ORA-12514 TNS 监听程序当前无法识别连接描述符中请求服务”错误

最新推荐文章于 2024-05-28 20:30:54 发布

iteye_14963

最新推荐文章于 2024-05-28 20:30:54 发布

阅读量91

点赞数

分类专栏：数据库文章标签： oracle

本文链接：https://blog.csdn.net/iteye_14963/article/details/82535428

版权

数据库专栏收录该内容

3 篇文章 0 订阅

订阅专栏

[b]找到：listener.ora[/b]

[b]D:\oracle\product\10.2.0\db_1\network\ADMIN\listener.ora[/b]

[b]修改如下：[/b]

[b]SID_LIST_LISTENER =
(SID_LIST =
(SID_DESC =
(SID_NAME = PLSExtProc)
(ORACLE_HOME = D:\oracle\product\10.2.0\db_1)
(PROGRAM = extproc)
)
[color=red](SID_DESC =
(GLOBAL_DBNAME = orcl)
(ORACLE_HOME = D:\oracle\product\10.2.0\db_1)
(SID_NAME = orcl)
)[/color] )[/b]

[b]LISTENER =
(DESCRIPTION_LIST =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = B0DNOIE39KXTPH0)(PORT = 1521))
)
)[/b]