dispatcher confusion [message #194621] |
Sat, 23 September 2006 01:15 |
M.Shakeel Azeem
Messages: 226 Registered: September 2006
|
Senior Member |
|
|
When i needed to set dispatchers for shared_server architecter
SQL> alter system set dispatchers='(PROTOCOL=TCP)(DISP=3)';
alter system set dispatchers='(PROTOCOL=TCP)(DISP=3)'
*
ERROR at line 1:
ORA-00105: dispatching mechanism not configured for network protocol
(ADDRESS=(PARTIAL=YES)(PROTOCOL=TCP))
Do anybody have idea where is the problem?
thanx in advance
|
|
|
Re: dispatcher confusion [message #194672 is a reply to message #194621] |
Sat, 23 September 2006 22:27 |
nmacdannald
Messages: 460 Registered: July 2005 Location: Stockton, California - US...
|
Senior Member |
|
|
tnsnames.ora =
ORCL =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = <hardware_ip>)(PORT = <some port, usually 1521>))
(CONNECT_DATA =
(SERVER = <Shared or DEDICATED> )
(SERVICE_NAME = <your_sid>)
)
)
EXTPROC_CONNECTION_DATA =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1))
)
(CONNECT_DATA =
(SID = PLSExtProc)
(PRESENTATION = RO)
)
)
SHARED_SERVERS
SHARED_SERVERS specifies the number of server processes that you want to create
when an instance is started. If system load decreases, then this minimum number of
servers is maintained. Therefore, you should take care not to set SHARED_SERVERS
too high at system startup.
Use the log_archive_dest, log_archive_max_processes, log_archive_min_succeed_dest parameters in the init.ora file
lsnrctl reload
[Updated on: Sat, 23 September 2006 22:38] Report message to a moderator
|
|
|