oracle lsnrctl监听器多实例配置
vim /u01/app/oracle/product/11.2.0/dbhome_1/network/admin/listener.ora
SID_LIST_LISTENER =
(SID_LIST =
(SID_DESC =
(GLOBAL_DBNAME = ORCL)
(ORACLE_HOME = /u01/app/oracle/product/11.2.0/dbhome_1)
(SID_NAME = ORCL)
)
(SID_DESC =
(GLOBAL_DBNAME = dev2)
(ORACLE_HOME = /u01/app/oracle/product/11.2.0/dbhome_1)
(SID_NAME = dev2)
)
(SID_DESC =
(GLOBAL_DBNAME = dev3)
(ORACLE_HOME = /u01/app/oracle/product/11.2.0/dbhome_1)
(SID_NAME = dev3)
)
(SID_DESC =
(GLOBAL_DBNAME = dev4)
(ORACLE_HOME = /u01/app/oracle/product/11.2.0/dbhome_1)
(SID_NAME = dev4)
)
(SID_DESC =
(GLOBAL_DBNAME = dev5)
(ORACLE_HOME = /u01/app/oracle/product/11.2.0/dbhome_1)
(SID_NAME = dev5)
)
(SID_DESC =
(GLOBAL_DBNAME = dev6)
(ORACLE_HOME = /u01/app/oracle/product/11.2.0/dbhome_1)
(SID_NAME = dev6)
)
(SID_DESC =
(GLOBAL_DBNAME = dev7)
(ORACLE_HOME = /u01/app/oracle/product/11.2.0/dbhome_1)
(SID_NAME = dev7)
)
(SID_DESC =
(GLOBAL_DBNAME = dev8)
(ORACLE_HOME = /u01/app/oracle/product/11.2.0/dbhome_1)
(SID_NAME = dev8)
)
)
LISTENER =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.1.100)(PORT = 1521))
)
ADR_BASE_LISTENER = /u01/app/oracle
相关文章
- Oracle Database 12c Release 2安装详解
- Oracle 数据库灾难性环境下恢复实例
- 【转】Oracle 自定义函数语法与实例
- oracle数据库创建实例
- oracle 01578
- oracle多实例的启动与关闭
- oracle listagg函数、lag函数、lead函数 实例
- oracle无法启动asm实例记录
- 基于OGG Datahub插件将Oracle数据同步上云
- oracle表复杂查询--创建数据库实例
- oracle 安装学习
- Oracle实例与Oracle数据库
- Oracle 12.2新特性掌上手册 - 第五卷 RAC and Grid
- Oracle学习.Windows 命令行 启动ORACLE服务与实例
- 实例演示oracle数据块状态视图v$bh的用法二 热点块问题(转)
- Oracle数据库 | SQL语句执行计划、语句跟踪与优化实例
- [Oracle 工程师手记]如何设置RAC环境自动启动 PDB
- oracle存储过程实例
- Oracle 数据库实例和数据库