oracle11g配置plsql

最新推荐文章于 2024-04-03 00:09:46 发布

原创最新推荐文章于 2024-04-03 00:09:46 发布 · 222 阅读

0 ·

CC 4.0 BY-SA版权

文章标签：

#数据库 #网络

oracle 专栏收录该内容

11 篇文章

订阅专栏

本文深入探讨了Oracle数据库中SID_LIST_LISTENER和LISTENER配置的作用与实现步骤，包括SID_NAME、ORACLE_HOME、PROGRAM、ENVS等关键参数的解析，以及如何在本地主机上配置监听器以支持外部进程连接。

SID_LIST_LISTENER =
(SID_LIST =
    (SID_DESC =
      (SID_NAME = CLRExtProc)
      (ORACLE_HOME = E:\product\11.2.0\dbhome_1)
      (PROGRAM = extproc)
      (ENVS = "EXTPROC_DLLS=ONLY:E:\product\11.2.0\dbhome_1\bin\oraclr11.dll")
    )
    (SID_DESC =
    (GLOBAL_DBNAME = MYORACLE11G)
     (ORACLE_HOME = E:\product\11.2.0\dbhome_1)
     (SID_NAME = MYORACLE11G)
   )
)

LISTENER =
(DESCRIPTION_LIST =
    (DESCRIPTION =
      (ADDRESS = (PROTOCOL = TCP)(HOST = localhost)(PORT = 1521))
    )
    (DESCRIPTION =
      (ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1521))
    )
)