Oracle监听服务lsnrctl参数及查询状态详解(三)
pos”, status UNKNOWN, has 1 handler(s) for this service…
Handler(s):
“DEDICATED” established:0 refused:0
LOCAL SERVER
Instance “repos”, status READY, has 1 handler(s) for this service…
Handler(s):
“DEDICATED” established:0 refused:0 state:ready
LOCAL SERVER
Service “repos_XPT” has 1 instance(s).
Instance “repos”, status READY, has 1 handler(s) for this service…
Handler(s):
“DEDICATED” established:0 refused:0 state:ready
LOCAL SERVER
The command completed successfully
service详解
Service “POD” has 1 instance(s).
Instance “POD”, status READY, has 1 handler(s) for this service…
Handler(s):
“DEDICATED” established:0 refused:0 state:ready
LOCAL SERVER
#名为POD的服务，对应数据库实例为POD，状态READY说明其处于动态注册
DEDICATED” established:0 refused:0 state:ready说明是专有连接，连接数为0拒绝数为0，状态：动态
Service “POD1″ has 1 instance(s).
Instance “POD”, status UNKNOWN, has 1 handler(s) for this service…
Handler(s):
“DEDICATED” established:0 refused:0
LOCAL SERVER
#名为POD1的服务，对应数据库实例为POD，状态UNKNOWN说明其处于静态注册
DEDICATED” established:2 refused:0说明是专有连接，连接数为2拒绝数为0
Service “PODS” has 1 instance(s).
Instance “POD”, status READY, has 2 handler(s) for this service…
Handler(s):
“D001″ established:0 refused:0 current:0 max:1022 state:ready
DISPATCHER
(ADDRESS=(PROTOCOL=tcp)(HOST=ocm1.oracle.domain)(PORT=37290))
“D000″ established:0 refused:0 current:0 max:1022 state:ready
DISPATCHER
(ADDRESS=(PROTOCOL=tcp)(HOST=ocm1.oracle.domain)(PORT=37288))
#名为PODS的服务，对应数据库实例名为POD的数据库，READY状态说明其为动态注册
“D001″ established:0 refused:0 current:0 max:1022 state:ready
”D000″ established:0 refused:0 current:0 max:1022 state:ready
这里说明其为share模式，目前，两个dispatcher目前都连接为0，拒绝为0，最大数为1022，状态是动态注册
——————————————————————————————————————————————————————
对应sql查询
SQL> show parameter dispatchers
NAME TYPE VALUE
———————————— ———– ——————————
dispatchers string
max_dispatchers integer
SQL> alter system set dispatchers=’(protocol=tcp) (dispatchers=2)’;System altered.SQL> show parameter dispatchersNAME TYPE VALUE
———————————— ———– ——————————
dispatchers string (protocol=tcp) (dispatchers=2)
max_dispatchers integerSQL> select name,network,paddr,status from v$dispatcher;NAME NETWORK PADDR STATUS
—- ——————————————————————————– ——– —————-
D000 (ADDRESS=(PROTOCOL=tcp)(HOST=seagull)(PORT=37288)) 2A220390 WAIT
D001 (ADDRESS=(PROTOCOL=tcp)(HOST=seagull)(PORT=37290)) 2A220948 WAIT
——————————————————————————————————————————————————————
Service “repos” has 2 instance(s).
Instance “repos”, status UNKNOWN, has 1 handler(s) for this service…
Handler(s):
“DEDICATED” established:0 refused:0
LOCAL SERVER
Instance “repos”, status READY, has 1 handler(s) for this service…
Handler(s):
“DEDICATED” established:0 refused:0 state:ready
LOCAL SERVER
#repos服务对应的实例有2个，但此处都为实例repos，一个为静态UNKNOWN,一个为动态READY，目前连接数都为0，拒绝也为0
The command completed successfully