ORACLE 监听配置的三种情况

目录

1、首先解释一下而这的区别SID和SERVICE_NAME

2、监听配置的三种情况：  

（1）一个监听在一个IP一个端口上监听多个实例 

（2）一个监听在一个IP不同端口上监听多个实例

（3）多个监听监听多个实例 

---

 

1、首先解释一下而这的区别SID和SERVICE_NAME

（1）SID:一个数据库可以有多个实例，SID是用来标识这个数据库内部每个实例的名字

（2）SERVICE_NAME：是这个数据库对外宣称的名字

2、监听配置的三种情况：  

（1）一个监听在一个IP一个端口上监听多个实例 

listener.ora文件：

SID_LIST_ORCL =
  (SID_LIST =
    (SID_DESC =
      (GLOBAL_DBNAME = ORCL)
      (SID_NAME = ORCL)
    )
    (SID_DESC =
      (GLOBAL_DBNAME = ZZY)
      (SID_NAME = ZZY)
    )
  )
ORCL =
  (DESCRIPTION_LIST =
    (DESCRIPTION =
      (ADDRESS = (PROTOCOL = TCP)(HOST = 10.10.66.8)(PORT = 1521))
    )
    (DESCRIPTION =
      (ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC))
    )
  

tnsnames.ora文件： 

ZZY =
  (DESCRIPTION =
    (ADDRESS = (PROTOCOL = TCP)(HOST = 10.10.66.8)(PORT = 1521))
    (CONNECT_DATA =
      (SERVER = DEDICATED)
      (SERVICE_NAME = ZZY)
    )
  )
ORCL =
  (DESCRIPTION =
    (ADDRESS = (PROTOCOL = TCP)(HOST = 10.10.66.8)(PORT = 1521))
    (CONNECT_DATA =
      (SERVER = DEDICATED)
      (SERVICE_NAME = orcl)
    )
  )

（2）一个监听在一个IP不同端口上监听多个实例

listener.ora文件： 

SID_LIST_ORCL =
  (SID_LIST =
    (SID_DESC =
      (GLOBAL_DBNAME = ORCL)
      (SID_NAME = ORCL)
    )
    (SID_DESC =
      (GLOBAL_DBNAME = ZZY)
      (SID_NAME = ZZY)
    )
  )
ORCL =
  (DESCRIPTION_LIST =
    (DESCRIPTION =
      (ADDRESS = (PROTOCOL = TCP)(HOST = 10.10.66.8)(PORT = 1521))
    )
    (DESCRIPTION =
      (ADDRESS = (PROTOCOL = TCP)(HOST = 10.10.66.8)(PORT = 1522))
    )
    (DESCRIPTION =
      (ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC))
    )
  )

tnsnames.ora文件： 

ZZY =
  (DESCRIPTION =
    (ADDRESS = (PROTOCOL = TCP)(HOST = 10.10.66.8)(PORT = 1522))
    (CONNECT_DATA =
      (SERVER = DEDICATED)
      (SERVICE_NAME = ZZY)
    )
  )
ORCL =
  (DESCRIPTION =
    (ADDRESS = (PROTOCOL = TCP)(HOST = 10.10.66.8)(PORT = 1521))
    (CONNECT_DATA =
      (SERVER = DEDICATED)
      (SERVICE_NAME = orcl)
    )
  )

（3）多个监听监听多个实例 

listener.ora文件：

SID_LIST_ORCL =
  (SID_LIST =
    (SID_DESC =
      (GLOBAL_DBNAME = ORCL)
      (SID_NAME = ORCL)
    )
    (SID_DESC =
      (GLOBAL_DBNAME = ZZY)
      (SID_NAME = ZZY)
    )
  )
SID_LIST_LSS =
  (SID_LIST =
    (SID_DESC =
      (GLOBAL_DBNAME = LSS)
      (SID_NAME = LSS)
    )
）
ORCL =
  (DESCRIPTION_LIST =
    (DESCRIPTION =
      (ADDRESS = (PROTOCOL = TCP)(HOST = 10.10.66.8)(PORT = 1521))
    )
    (DESCRIPTION =
      (ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC))
    )
  )
LSS=
   (DESCRIPTION =
      (ADDRESS = (PROTOCOL = TCP)(HOST = 10.10.66.8)(PORT = 1522))
    )

tnsnames.ora文件： 

ZZY =
  (DESCRIPTION =
    (ADDRESS = (PROTOCOL = TCP)(HOST = 10.10.66.8)(PORT = 1520))
    (CONNECT_DATA =
      (SERVER = DEDICATED)
      (SERVICE_NAME = ZZY)
    )
  )
ORCL =
  (DESCRIPTION =
    (ADDRESS = (PROTOCOL = TCP)(HOST = 10.10.66.8)(PORT = 1521))
    (CONNECT_DATA =
      (SERVER = DEDICATED)
      (SERVICE_NAME = orcl)
    )
  )
LSS =
  (DESCRIPTION =
    (ADDRESS = (PROTOCOL = TCP)(HOST = 10.10.66.8)(PORT = 1522))
    (CONNECT_DATA =
      (SERVER = DEDICATED)
      (SERVICE_NAME = LSS)
    )
  )