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)
    )
  )

转载于:https://www.cnblogs.com/reaperhero/articles/10417333.html