静态监听

[oracle@DCDRJFC3X-R610 admin]$ more listener.ora
# listener.ora Network Configuration File: /ulic/app/oracle/product/11.2/network/admin/listener.ora
# Generated by Oracle configuration tools.


CSKMSPRD =
  (DESCRIPTION_LIST =
    (DESCRIPTION =
      (ADDRESS = (PROTOCOL = TCP)(HOST = DCDRJFC3X-R610.ulic.com.cn)(PORT = 1525))
      (ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1525))
    )
  )


SID_LIST_CSKMSPRD =  
  (SID_LIST =  
    (SID_DESC =  
      (SID_NAME = PLSExtProc)  
      (ORACLE_HOME = /ulic/app/oracle/product/11.2)  
      (PROGRAM = extproc)  
    )  
  
    (SID_DESC =  
      (GLOBAL_DBNAME = cskmsprd)   -------- GLOBAL_DBNAME向外提供服务名
      (ORACLE_HOME = /ulic/app/oracle/product/11.2)  
      (SID_NAME = cskmsprd)            --------  SID_NAME提供注册的实例名
    )  
  
  )


ADR_BASE_CSKMSPRD = /ulic/app/oracle

静态注册时，listener.ora中的GLOBAL_DBNAME向外提供服务名，listener.ora中的SID_NAME提供注册的实例名。

来自 “ ITPUB博客 ” ，链接：http://blog.itpub.net/21374452/viewspace-2140675/，如需转载，请注明出处，否则将追究法律责任。

转载于:http://blog.itpub.net/21374452/viewspace-2140675/