ORA-12514: TNS: 监听进程不能解析在连接描述符中给出的 SERVICE_NAME 错误的解决

最新推荐文章于 2022-01-10 09:53:59 发布

yixiaoping

最新推荐文章于 2022-01-10 09:53:59 发布

阅读量8.3k

点赞数

分类专栏： Oracle 文章标签： Oracle异常

本文链接：https://blog.csdn.net/yixiaoping/article/details/9903379

版权

Oracle 专栏收录该内容

5 篇文章 0 订阅

订阅专栏

PL/SQL DEVELOPER 连接数据库ORCL时总报ORA-12514: TNS: 监听程序当前无法识别连接描述符中请求的服务!

解决方案：

到oracle 的安装目录下面如D:\oracle\product\10.2.0\db_1\NETWORK\ADMIN中找到listner.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))
)
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = PC201307291745)(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 = PLSExtProc)
(ORACLE_HOME = D:\oracle\product\10.2.0\db_1)
(PROGRAM = extproc)
)

(SID_DESC =
(GLOBAL_DBNAME = orcl)
(ORACLE_HOME = D:\oracle\product\10.2.0\db_1)
(SID_NAME = orcl)
)
)

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

-------------------------------------------------------------------------------------------------

在原始的文件中加入黑体字的部分，即将你创建的数据库的SID描述告知给监听器。保存文件。注意重新尝试登陆之前要按顺序重新启动一下SQLplus服务和TNSListner服务。