我还没太理解,借这个帖子在问一句哈
在下边列出了listener.ora 和 lsnrctl status 的输出.
依照oraclular给出的文档,我不明白的有两点:
1.我觉得配置文件里只配置了静态注册,那动态的注册是怎么出来的?
2.我发现数据库里边配置的service_name和lsnrctl status输出的service_name不一样,why?
# Generated by Oracle configuration tools.
LISTENER =
(DESCRIPTION_LIST =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = pnsgdev1db1)(PORT = 1521))
(ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC0))
)
)
SID_LIST_LISTENER =
(SID_LIST =
(SID_DESC =
(SID_NAME = CUD)
(ORACLE_HOME = /opt/oracle/product/cud/10.2)
)
(SID_DESC =
(SID_NAME = PND)
(ORACLE_HOME = /opt/oracle/product/pnd/10.2)
)
(SID_DESC =
(SID_NAME = TRD)
(ORACLE_HOME = /opt/oracle/product/trd/10.2)
)
)
Services Summary...
Service "CUD" has 2 instance(s).
Instance "CUD", status UNKNOWN, has 1 handler(s) for this service...
Instance "cud", status READY, has 1 handler(s) for this service...
Service "PND" has 2 instance(s).
Instance "PND", status UNKNOWN, has 1 handler(s) for this service...
Instance "pnd", status READY, has 1 handler(s) for this service...
Service "TRD" has 2 instance(s).
Instance "TRD", status UNKNOWN, has 1 handler(s) for this service...
Instance "trd", status READY, has 1 handler(s) for this service...
Service "cudXDB" has 1 instance(s).
Instance "cud", status READY, has 1 handler(s) for this service...
Service "cud_XPT" has 1 instance(s).
Instance "cud", status READY, has 1 handler(s) for this service...
Service "pndXDB" has 1 instance(s).
Instance "pnd", status READY, has 1 handler(s) for this service...
Service "pnd_XPT" has 1 instance(s).
Instance "pnd", status READY, has 1 handler(s) for this service...
Service "trdXDB" has 1 instance(s).
Instance "trd", status READY, has 1 handler(s) for this service...
Service "trd_XPT" has 1 instance(s).
Instance "trd", status READY, has 1 handler(s) for this service...
SQL> show parameter service_name
NAME
TYPEVALUE
------------------------------------ ----------- ------------------------------
service_names
stringcud
SQL> show parameter instance_name
NAME
TYPEVALUE
------------------------------------ ----------- ------------------------------
instance_name
stringcud
|