Orcale 远程连接数据库错误

最新推荐文章于 2021-06-22 10:28:17 发布

原创最新推荐文章于 2021-06-22 10:28:17 发布 · 140 阅读

0 ·

CC 4.0 BY-SA版权

文章标签：

#网络 #数据库

本文详细解析了Oracle数据库连接中SID_LIST_LISTENER配置问题，包括SID_NAME、ORACLE_HOME和PROGRAM参数的含义及作用，通过实例展示了如何正确配置SID_LIST_LISTENER以解决TNS:listenerdoesnotcurrentlyknowofSIDgiveninconnectdescriptor错误。

TNS:listener does not currently know of SID given in connect descriptor

修改：SID_LIST_LISTENER =
(SID_LIST =
(SID_DESC =
(SID_NAME = PLSExtProc)
(ORACLE_HOME = /app/oracle/oracle/product/10.2.0/db_1)
(PROGRAM = extproc)
)
[u](SID_DESC =
(GLOBAL_DBNAME = ORCL)
(ORACLE_HOME = /app/oracle/oracle/product/10.2.0/db_1)
(SID_NAME = ORCL)
)[/u] )

LISTENER =
(DESCRIPTION_LIST =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1))
(ADDRESS = (PROTOCOL = TCP)(HOST = suse10.site)(PORT = 1521))
)
)