Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: Configuring dispatching mechanism
peter_at_nomorenewsspammin.ca said...
> When I was configuring the dispatching mechanism for a shared server
> setting, I got some error messages.
> What is the meaning of
> "ORA-00105: dispatching mechanism not configured for network
> protocol"?
>
>
> SQL> alter system set shared_servers=10;
> alter system set shared_servers=10
> *
> ERROR at line 1:
> ORA-02097: parameter cannot be modified because specified value is
> invalid
> ORA-00120: dispatching mechanism not enabled or installed
>
>
>
> SQL> alter system set
> dispatchers='(address=(protocol=tcp)(host=127.0.0.1))(dispatchers=2)';
> alter system set
> dispatchers='(address=(protocol=tcp)(host=127.0.0.1))(dispatchers=2)'
> *
> ERROR at line 1:
> ORA-00105: dispatching mechanism not configured for network protocol
> (address=(protocol=tcp)(host=127.0.0.1))
>
> shared_servers and dispatchers are supposed to dynamic so I should be
> able to change it.
>
> Thanks
>
You might want to check out the tips in this document:
http://www.oracleadvice.com/Tips/MTS.htm
You can find other documents by doing what I did and searching Google for the following:
oracle "shared server"
-- /Karsten DBA > retired > DBAReceived on Fri Jun 06 2003 - 10:44:20 CDT