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

posted @ 2021-01-29 11:20  鸾舞春秋  阅读(218)  评论(0编辑  收藏  举报