oracle多实例监听配置
三种情况:
1、一个监听在一个IP一个端口上监听多个实例
2、一个监听在一个IP不同端口上监听多个实例
3、多个监听监听多个实例
查询
show parameter service_names;
select instance_name from v$instance;
lsnrctl交互界面中可以查看listener.ora配置信息
alter system register;
GLOBAL_DBNAME和SID_NAME的区别
情况2
服务端
LISTENER =
(DESCRIPTION_LIST =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = 数据库IP)(PORT = 1522))
)
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = 数据库IP)(PORT = 1521))
)
(DESCRIPTION =
(ADDRESS = (PROTOCOL = IPC)( KEY = EXTPROC))
)
)
SID_LIST_LISTENER =
(SID_LIST =
(SID_DESC =
(GLOBAL_DBNAME =实例名1)
(SID_NAME =实例名1)
)
(SID_DESC =
(GLOBAL_DBNAME = 实例名2)
(SID_NAME = 实例名2)
)
)
客户端
csibm03 =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = 数据库IP)(PORT = 1522))
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = 实例名1)
)
)
CSIBM3KF =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = 数据库IP)(PORT = 1521))
)
(CONNECT_DATA =
(SERVICE_NAME = 实例名2)
)
)