oracle 静态监听

 

静态监听的配置文件如下：

SID_LIST_LISTENER = 
  (SID_LIST = 
   (SID_DESC = 
    (GLOBAL_DBNAME = ORCL) 
    (ORACLE_HOME = /oracle/database/11.2/db_1)   
    (SID_NAME = orcl) 
    ) 
   (SID_DESC =
    (GLOBAL_DBNAME = zszjkst)        
    (ORACLE_HOME = /oracle/database/11.2/db_1/)        
    (SID_NAME = zszjk)          
    )
  )

GLOBAL_DBNAME ：对应服务名，可以自定义

SID_NAME：对应实例名（区分大小写）

上面的静态监听配置启动后，监听信息如下：

Listening Endpoints Summary...
  (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=10.50.14.65)(PORT=1521)))
Services Summary...
Service "ORCL" has 1 instance(s).
  Instance "orcl", status UNKNOWN, has 1 handler(s) for this service...
Service "zszjkst" has 1 instance(s).
  Instance "zszjk", status UNKNOWN, has 1 handler(s) for this service...
The command completed successfully