Oracle 共享服务器(Shared Server/MTS)的配置简析
Oracle 共享服务器(Shared Server/MTS)的配置简析
Oracle 9i 下的共享服务器 Shared Server(8i 中的多线程服务器 MTS共享服务器的配置
1.设置 DISPATCHERS 参数:
*.DISPATCHERS='(PROTOCOL=TCP)(SERVICE=SKYSH)(DISPATCHERS=2)(PROTOCOL=IPC)(DISPATCHERS=1)'
*.DISPATCHERS='(ADDRESS=(PROTOCOL=TCP)(PORT=5000))(DISPATCHERS=1)','(ADDRESS=(PROTOCOL=TCP)(PORT=5001))(DISPATCHERS=1)'
*.dispatchers='(ADDRESS=(PROTOCOL=TCP)(PORT=5130))(SERVICE=SKYSHR)(DISPATCHERS=1)'
2.设置客户端 tnsnames.ora 文件:
SKY3 =
ERROR:
ORA-12523: TNS:listener could not find instance appropriate for the client connection
3.SHARED_SERVERS 参数:
ERROR:
ORA-12520: TNS:listener could not find available handler for requested type of server
4.其他一些相关参数:
5.一些注意事项:
ORA-00106: cannot startup/shutdown database when connected to a dispatcher
6.一些相关动态视图:
例子:查看使用哪种方式连接数据库
SQL> select sid from v$mystat where rownum=1;
----------
SQL> select server from v$session
SERVER
---------
SHARED
7.查看 listener 信息:
C:\Documents and Settings\Administrator>lsnrctl
LSNRCTL for 32-bit Windows: Version 9.2.0.3.0 - Production on 17-MAY-2006 23:22:58
Copyright (c) 1991, 2002, Oracle Corporation.
Welcome to LSNRCTL, type "help" for information.
LSNRCTL> status
Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=heysky)(PORT=1521)))
STATUS of the LISTENER
------------------------
Alias
Version
tion
Start Date
Uptime
Trace Level
Security
SNMP
Listener Parameter File
Listener Log File
Listening Endpoints Summary...
Services Summary...
Service "PLSExtProc" has 1 instance(s).
Service "SKYSHARED.heysky.net" has 1 instance(s).
Service "SKYTEST" has 1 instance(s).
The command completed successfully
LSNRCTL> service
Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=heysky)(PORT=1521)))
Services Summary...
Service "PLSExtProc" has 1 instance(s).
Service "SKYSHARED.heysky.net" has 1 instance(s).