Re: Configuring dispatching mechanism

"Peter" <peter_at_nomorenewsspammin.ca> wrote in message news:gkftdv4hvg7jok5t285a5cgdjcb1a1p05i_at_4ax.com...
> 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
>
>

IIRC, the correct parameter is *mts*_dispatchers, at least for 8i and before (you don't mention your version)
Also setting up mts on the server only (you are using the hardcoded localhost address, which shows you didn't set up your hosts file correctly) is pretty useless

-- 
Sybrand Bakker
Senior Oracle DBA

to reply remove '-verwijderdit' from my e-mail address