监听程序当前无法识别连接描述符中请求的服务

最新推荐文章于 2024-12-05 11:10:33 发布

SailyZer

最新推荐文章于 2024-12-05 11:10:33 发布

阅读量524

点赞数

CC 4.0 BY-SA版权

文章标签： list oracle tcp manager service server

本文链接：https://blog.youkuaiyun.com/saili930/article/details/5902216

本文介绍如何配置Oracle数据库的listener.ora和tnsnames.ora文件以实现不同服务实例的监听与连接。通过修改SID_LIST_LISTENER和服务描述符，可以为多个数据库实例设置监听地址。

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

listener.ora

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

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

tnsnames.ora

ORCL =
(DESCRIPTION =
    (ADDRESS = (PROTOCOL = TCP)(HOST = 127.0.0.1)(PORT = 1521))
    (CONNECT_DATA =
      (SERVER = DEDICATED)
      (SERVICE_NAME = orcl)
    )
)

EXTPROC_CONNECTION_DATA =
(DESCRIPTION =
    (ADDRESS_LIST =
      (ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1))
    )
    (CONNECT_DATA =
      (SID = PLSExtProc)
      (PRESENTATION = RO)
    )
)

修改listener.ora

listener.ora

SID_LIST_LISTENER =
   (SID_LIST =
(SID_DESC =
   (GLOBAL_DBNAME = demo)
   (ORACLE_HOME = D:/oracle/product/10.2.0/db_1)
   (SID_NAME = demo)
)
(SID_DESC =
   (GLOBAL_DBNAME = ORCL)
   (ORACLE_HOME = D:/oracle/product/10.2.0/db_1)
   (SID_NAME = ORCL)
)
   )

LISTENER =
   (DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = Colin)(PORT = 1521))
   )