- 论坛徽章:
- 0
|
安装时记着选的时专用服务器,为了确定使用dbca查看了一下,的确选择的是dispatcher。
- 1 select server
- 2 from v$session
- 3* where audsid=userenv('sessionid')
- SQL>; /
- SERVER
- ---------
- DEDICATED
复制代码
这样说明是专用服务器。
但查看下面信息,其中也有dispatcher,是否有dispatcher就能说明服务器是共享服务器模式?
- SQL>; show parameter dispatcher
- NAME TYPE VALUE
- ------------------------------------ ----------- ------------------------------
- dispatchers string (PROTOCOL=TCP) (SERVICE=hpunix
- XDB)
- max_dispatchers integer 5
- mts_dispatchers string (PROTOCOL=TCP) (SERVICE=hpunix
- XDB)
- mts_max_dispatchers integer 5
- SQL>; select * from v$dispatcher;
- NAME
- ----
- NETWORK
- --------------------------------------------------------------------------------
- PADDR STATUS ACC MESSAGES BYTES BREAKS
- ---------------- ---------------- --- ---------- ---------- ----------
- OWNED CREATED IDLE BUSY LISTENER CONF_INDX
- ---------- ---------- ---------- ---------- ---------- ----------
- D000
- (ADDRESS=(PROTOCOL=tcp)(HOST=hpserver)(PORT=63750))
- C000000016243D28 WAIT YES 123 33584 0
- 0 11 103228407 47 0 0
- $ lsnrctl status
- LSNRCTL for HPUX: Version 9.2.0.2.0 - Production on 25-OCT-2005 16:20:19
- Copyright (c) 1991, 2002, Oracle Corporation. All rights reserved.
- Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=IPC)(KEY=EXTPROC)))
- STATUS of the LISTENER
- ------------------------
- Alias LISTENER
- Version TNSLSNR for HPUX: Version 9.2.0.2.0 - Production
- Start Date 13-OCT-2005 17:56:46
- Uptime 11 days 22 hr. 23 min. 32 sec
- Trace Level off
- Security OFF
- SNMP OFF
- Listener Parameter File /opt/oracle/OraHome1/network/admin/listener.ora
- Listener Log File /opt/oracle/OraHome1/network/log/listener.log
- Listening Endpoints Summary...
- (DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(KEY=EXTPROC)))
- (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=hpserver)(PORT=1521)))
- (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=hpserver)(PORT=8080))(Presentation=HTTP)(Session=RAW))
- (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=hpserver)(PORT=2100))(Presentation=FTP)(Session=RAW))
- Services Summary...
- Service "PLSExtProc" has 1 instance(s).
- Instance "PLSExtProc", status UNKNOWN, has 1 handler(s) for this service...
- Service "hpunix" has 2 instance(s).
- Instance "hpunix", status UNKNOWN, has 1 handler(s) for this service...
- Instance "hpunix", status READY, has 1 handler(s) for this service...
- Service "hpunixXDB" has 1 instance(s).
- Instance "hpunix", status READY, has 1 handler(s) for this service...
- The command completed successfully
- $ lsnrctl services
- LSNRCTL for HPUX: Version 9.2.0.2.0 - Production on 25-OCT-2005 16:49:11
- Copyright (c) 1991, 2002, Oracle Corporation. All rights reserved.
- Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=IPC)(KEY=EXTPROC)))
- Services Summary...
- Service "PLSExtProc" has 1 instance(s).
- Instance "PLSExtProc", status UNKNOWN, has 1 handler(s) for this service...
- Handler(s):
- "DEDICATED" established:0 refused:0
- LOCAL SERVER
- Service "hpunix" has 2 instance(s).
- Instance "hpunix", status UNKNOWN, has 1 handler(s) for this service...
- Handler(s):
- "DEDICATED" established:2 refused:0
- LOCAL SERVER
- Instance "hpunix", status READY, has 1 handler(s) for this service...
- Handler(s):
- "DEDICATED" established:524 refused:0 state:ready
- LOCAL SERVER
- Service "hpunixXDB" has 1 instance(s).
- Instance "hpunix", status READY, has 1 handler(s) for this service...
- Handler(s):
- "D000" established:8 refused:0 current:2 max:2026 state:ready
- DISPATCHER <machine: hpserver, pid: 17338>;
- (ADDRESS=(PROTOCOL=tcp)(HOST=hpserver)(PORT=63750))
- The command completed successfully
复制代码 |
|