Oracle 复杂监听配置

最新推荐文章于 2024-04-13 10:20:48 发布

小学生汤米

最新推荐文章于 2024-04-13 10:20:48 发布

阅读量453

点赞数

CC 4.0 BY-SA版权

分类专栏： ORACLE

本文链接：https://blog.youkuaiyun.com/gaobudong1234/article/details/79278342

ORACLE 专栏收录该内容

48 篇文章

订阅专栏

本文详细介绍了Oracle数据库的监听配置，包括如何配置一个监听服务监听多个IP地址，如何配置一个监听监听不同端口，以及如何配置多个监听服务于不同的实例，涵盖TCP和IPC协议，有助于提升Oracle数据库的管理和使用效率。

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

1.一个监听配置多个IP地址

1）默认单个监听的监听LISTENER配置
LISTENER =
(DESCRIPTION_LIST =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = tst104)(PORT = 1521))
(ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1521))
)
)

2）增加一个IP地址，监听多个IP，监听配置改为：

LISTENER =
(DESCRIPTION_LIST =
(DESCRIPTION =
(ADDRESS_LIST=(ADDRESS = (PROTOCOL = TCP)(HOST = 168.60.40.104)(PORT = 1521)))
(ADDRESS_LIST=(ADDRESS = (PROTOCOL = TCP)(HOST = 127.0.0.1)(PORT = 1521)))
(ADDRESS_LIST=
(ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1521))
)
)
)

2.配置一个监听，监听不同端口

LISTENER =
(DESCRIPTION_LIST =
(DESCRIPTION =
(ADDRESS_LIST=(ADDRESS = (PROTOCOL = TCP)(HOST = 168.60.40.104)(PORT = 1521)))
(ADDRESS_LIST=(ADDRESS = (PROTOCOL = TCP)(HOST = 127.0.0.1)(PORT = 1522)))
(ADDRESS_LIST=
(ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1521))
)
)
)

3.配置多个监听，监听不通端口

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

LISTENER2 =
(DESCRIPTION_LIST =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = 127.0.0.1)(PORT = 1522))
(ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1522))
)
)

4.配置多个监听，多个实例，一个实例对应一个监听

SID_LIST_LISTENER =
(SID_LIST =
(SID_DESC =
(SID_NAME = PLSExtProc)
(ORACLE_HOME = /u01/app/oracle/product/10.2.0/db)
(PROGRAM = extproc)
)
(SID_DESC =
(GLOBAL_DBNAME = jingyong)
(ORACLE_HOME =/u01/app/oracle/product/10.2.0/db)
(SID_NAME = jingyong)
)
)

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

SID_LIST_LISTENER_2 =
(SID_LIST =
(SID_DESC =
(SID_NAME = PLSExtProc)
(ORACLE_HOME = /u01/app/oracle/product/10.2.0/db)
(PROGRAM = extproc)
)
(SID_DESC =
(GLOBAL_DBNAME = jingyong)
(ORACLE_HOME =/u01/app/oracle/product/10.2.0/db)
(SID_NAME = jingyong)
)
)

LISTENER_2 =
(DESCRIPTION_LIST =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = jingyong)(PORT = 1522))
)
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = jingyong)(PORT = 1523))
)
)