zl程序教程

您现在的位置是:首页 >  数据库

当前栏目

oracle lsnrctl监听器多实例配置

Oracle实例配置 监听器
2023-09-27 14:29:19 时间

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