å¦ä½å¯ç¨Oracle Shared Server
å¨æäºåºç¨ä¸å
±äº«æå¡å¨è¿æ¯æç¬ç¹çä¼å¿çï¼ä»å®æ¹æè¿°ä¸å¯ä»¥çå°å¦ä¸ä¼å¿ï¼
åå°å®ä¾è¿ç¨çæ°ç®
å¢å 对å¤æå¡çç¨æ·æ°ç®
åå°æ ç¨æè
空é²æå¡å¨çè¿ç¨æ°ç®
åå°oracleæ°æ®åºå¯¹å
åå ç¨åosçå¼é
å®ç°è´è½½å¹³è¡¡
ç¸å¯¹äºä¸ææå¡å¨æ¨¡å¼ï¼ä¸ä¸ªæ¯è¾éè¦çåºå«æ¯å
±äº«æå¡å¨è¦æ±ä½¿ç¨net servicesæ¥è¿æ¥ï¼å³ä½¿ç¨æ·ç»å¸¸åæå¡å¨è¿ç¨å¨åä¸å°æºå¨ä¸ä¹æ¯å¦æ¤ã
ä½æ¯å¨æäºæ
åµä¸å¿
须使ç¨ä¸ç¨æå¡å¨ï¼æ¯å¦ä½¿ç¨sysdbaç»éè¿è¡ç®¡çæä½çæ¶åã
å½ç¶ï¼è¦ä½¿ç¨è¿ä¸¤ç§ä¸åç模å¼ï¼éè¦çè¿æ¯å¨æå¡å¨è¿è¡é
ç½®åè¿è¦å¨å®¢æ·ç«¯çè¿æ¥ä¸²é
ç½®ææä½ç°
ä¸ç¨æå¡å¨è¿æ¥---(SERVER = DEDICATED)
å
±äº«æå¡å¨è¿æ¥---(SERVER = SHARED)
é£ä¹å¦ä½é
ç½®å
±äº«æå¡å¨å¢ï¼æ两个åæ°æ¯å¿
é¡»çï¼
DISPATCHERS
SHARED_SERVERS
å¯éæ©é
ç½®çåæ°ï¼
MAX_DISPATCHERS
MAX_SHARED_SERVERS
CIRCUITS
SHARED_SERVER_SESSIONS
大é¨åæ
åµä¸æ们åªè¦ä¿®æ¹DISPATCHERSå³å¯ï¼æ们å
çä¸é»è®¤çä¸ç¨æå¡å¨æ
åµä¸åæ°ï¼
[oracle@test ~]$ sqlplus "/as sysdba"
SQL*Plus: Release 10.2.0.5.0 - Production on Tue Aug 14 15:04:26 2012
Copyright (c) 1982, 2010, Oracle. All Rights Reserved.
Connected to:
Oracle Database 10g Enterprise Edition Release 10.2.0.5.0 - Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options
sys@GT10G> select * from v$version;
BANNER
----------------------------------------------------------------
Oracle Database 10g Enterprise Edition Release 10.2.0.5.0 - Prod
PL/SQL Release 10.2.0.5.0 - Production
CORE 10.2.0.5.0 Production
TNS for Linux: Version 10.2.0.5.0 - Production
NLSRTL Version 10.2.0.5.0 - Production
sys@GT10G> show parameter disp;
NAME TYPE VALUE
------------------------------------ -------- ------------------------------
dispatchers string (PROTOCOL=TCP) (SERVICE=gt10gXDB)
max_dispatchers integer
å
±äº«æå¡å¨åä¸ç¨æå¡å¨è¿å¯ä»¥ä»çå¬ç¨åºçä¿¡æ¯ä½ç°åºæ¥ï¼æ们å
è®°å½ä¸ä¿®æ¹ä¹åçä¸ç¨æå¡å¨ççå¬ç¶æåä¿¡æ¯ï¼
[oracle@test ~]$ lsnrctl status
LSNRCTL for Linux: Version 10.2.0.5.0 - Production on 14-AUG-2012 15:03:32
Copyright (c) 1991, 2010, Oracle. All rights reserved.
Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=test)(PORT=1521)))
STATUS of the LISTENER
------------------------
Alias LISTENER
Version TNSLSNR for Linux: Version 10.2.0.5.0 - Production
Start Date 14-AUG-2012 14:52:08
Uptime 0 days 0 hr. 11 min. 24 sec
Trace Level off
Security ON: Local OS Authentication
SNMP OFF
Listener Parameter File /u01/oracle/10g/product/10.2.0/db_1/network/admin/listener.ora
Listener Log File /u01/oracle/10g/product/10.2.0/db_1/network/log/listener.log
Listening Endpoints Summary...
(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=test)(PORT=1521)))
(DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(KEY=EXTPROC0)))
Services Summary...
Service "PLSExtProc" has 1 instance(s).
Instance "PLSExtProc", status UNKNOWN, has 1 handler(s) for this service...
Service "gt10g" has 1 instance(s).
Instance "gt10g", status READY, has 1 handler(s) for this service...
Service "gt10gXDB" has 1 instance(s).
Instance "gt10g", status READY, has 1 handler(s) for this service...
Service "gt10g_XPT" has 1 instance(s).
Instance "gt10g", status READY, has 1 handler(s) for this service...
The command completed successfully
[oracle@test ~]$ lsnrctl service
LSNRCTL for Linux: Version 10.2.0.5.0 - Production on 14-AUG-2012 15:03:39
Copyright (c) 1991, 2010, Oracle. All rights reserved.
Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=test)(PORT=1521)))
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 "gt10g" has 1 instance(s).
Instance "gt10g", status READY, has 1 handler(s) for this service...
Handler(s):
"DEDICATED" established:0 refused:0 state:ready
LOCAL SERVER
Service "gt10gXDB" has 1 instance(s).
Instance "gt10g", status READY, has 1 handler(s) for this service...
Handler(s):
"D002" established:0 refused:0 current:0 max:1022 state:ready
DISPATCHER <machine: test, pid: 18635>
(ADDRESS=(PROTOCOL=tcp)(HOST=test)(PORT=47446))
Service "gt10g_XPT" has 1 instance(s).
Instance "gt10g", status READY, has 1 handler(s) for this service...
Handler(s):
"DEDICATED" established:0 refused:0 state:ready
LOCAL SERVER
The command completed successfully
ç°å¨æ们è¦è®¾ç½®ä¸ä¸å
±äº«æå¡å¨ï¼è¿éæ们åªè¦è®¾ç½®DISPATCHERSåæ°ï¼
sys@GT10G> alter system set DISPATCHERS = "(PROTOCOL=TCP)(DISPATCHERS=3)(PROTOCOL=IPC)(DISPATCHERS=1)";
System altered.
æ们é¦å
ä»çå¬ç¶æåä¿¡æ¯æ¥çä¸ååçä¸åï¼
[oracle@test ~]$ lsnrctl status
LSNRCTL for Linux: Version 10.2.0.5.0 - Production on 14-AUG-2012 15:07:37
Copyright (c) 1991, 2010, Oracle. All rights reserved.
Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=test)(PORT=1521)))
STATUS of the LISTENER
------------------------
Alias LISTENER
Version TNSLSNR for Linux: Version 10.2.0.5.0 - Production
Start Date 14-AUG-2012 14:52:08
Uptime 0 days 0 hr. 15 min. 28 sec
Trace Level off
Security ON: Local OS Authentication
SNMP OFF
Listener Parameter File /u01/oracle/10g/product/10.2.0/db_1/network/admin/listener.ora
Listener Log File /u01/oracle/10g/product/10.2.0/db_1/network/log/listener.log
Listening Endpoints Summary...
(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=test)(PORT=1521)))
(DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(KEY=EXTPROC0)))
Services Summary...
Service "PLSExtProc" has 1 instance(s).
Instance "PLSExtProc", status UNKNOWN, has 1 handler(s) for this service...
Service "gt10g" has 1 instance(s).
Instance "gt10g", status READY, has 2 handler(s) for this service...
Service "gt10gXDB" has 1 instance(s).
Instance "gt10g", status READY, has 1 handler(s) for this service...
Service "gt10g_XPT" has 1 instance(s).
Instance "gt10g", status READY, has 2 handler(s) for this service...
The command completed successfully
[oracle@test ~]$ lsnrctl service
LSNRCTL for Linux: Version 10.2.0.5.0 - Production on 14-AUG-2012 15:09:22
Copyright (c) 1991, 2010, Oracle. All rights reserved.
Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=test)(PORT=1521)))
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 "gt10g" has 1 instance(s).
Instance "gt10g", status READY, has 2 handler(s) for this service...
Handler(s):
"DEDICATED" established:0 refused:0 state:ready
LOCAL SERVER
"D000" established:0 refused:0 current:0 max:1022 state:ready
DISPATCHER <machine: test, pid: 19006>
(ADDRESS=(PROTOCOL=ipc)(KEY=#19006.1))
Service "gt10gXDB" has 1 instance(s).
Instance "gt10g", status READY, has 1 handler(s) for this service...
Handler(s):
"D002" established:0 refused:0 current:0 max:1022 state:ready
DISPATCHER <machine: test, pid: 18635>
(ADDRESS=(PROTOCOL=tcp)(HOST=test)(PORT=47446))
Service "gt10g_XPT" has 1 instance(s).
Instance "gt10g", status READY, has 2 handler(s) for this service...
Handler(s):
"DEDICATED" established:0 refused:0 state:ready
LOCAL SERVER
"D000" established:0 refused:0 current:0 max:1022 state:ready
DISPATCHER <machine: test, pid: 19006>
(ADDRESS=(PROTOCOL=ipc)(KEY=#19006.1))
The command completed successfully
æ¯è¾ä¸å¯ä»¥çå°æ大çååå°±æ¯å
±äº«æå¡å¨å¨çå¬ä¿¡æ¯ä¸ä½ç°åºäºè°åº¦è¿ç¨"D000"ã
æ¥ä¸æ¥æ们éè¿ä¿®æ¹tnsnameé
ç½®åæ°æ¥å®é
è¿æ¥ï¼åéè¿è§å¾å¯ä»¥çå°æ们已ç»æä¸ä¸ªå
±äº«æ¨¡å¼è¿æ¥å°æå¡å¨äºï¼
GT10G4 =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.1.4)(PORT = 1521))
(CONNECT_DATA =
(SERVER = SHARED) #éç¹å¨è¿é
(SERVICE_NAME = gt10g)
)
)
sys@GT10G> Select Count(*) From V$CIRCUIT;
COUNT(*)
----------
1
é£ä¹ï¼å¦ææ们没æé
ç½®å
±äº«æå¡æ¨¡å¼çåæ°ï¼ä½æ¯å®¢æ·ç«¯é
ç½®äºä½¿ç¨å
±äº«æ¨¡å¼è¿æ¥ï¼ä¼æ¯ä»ä¹ç»æå¢ï¼
alter system set DISPATCHERS="(PROTOCOL=TCP) (SERVICE=gt10gXDB)";
alter system reset DISPATCHERS scope=spfile sid='*';
å°è¯äºä¸è¿°ä¸¤æ¡è¯å¥åç°è¿æ¯æ æ³æ¢å¤å
åä¸çåæ°å¼ï¼åªå¥½éå¯æ°æ®åº,åç°è¿æ¯ä¸è¡ï¼åæ¥æç´¢äºä¸åç°ç´æ¥æ¸
空å³å¯ï¼
sys@GT10G> alter system set dispatchers='' scope=both;
System altered.
sys@GT10G> show parameter disp;
NAME TYPE VALUE
------------------------------------ -------- ------------------------------
dispatchers string
max_dispatchers integer
è¿ä¸ªæ¶åå¨å®¢æ·ç«¯ç»§ç»å°è¯ç¨å
±äº«æ¨¡å¼è¿æ¥ä¼åç°æ¥éäºï¼
C:\Users\Administrator>sqlplus gtlions/gtlions@gt10g4
SQL*Plus: Release 10.2.0.1.0 - Production on ææäº 8æ 14 15:41:14 2012
Copyright (c) 1982, 2005, Oracle. All rights reserved.
ERROR:
ORA-12520: TNS: çå¬ç¨åºæ æ³ä¸ºè¯·æ±çæå¡å¨ç±»åæ¾å°å¯ç¨çå¤çç¨åº
-The End-
温馨提示:答案为网友推荐,仅供参考