Re: Configuring dispatching mechanism

You will find some additional information related to the error messages and possible causes listed at http://docs.oracle.com

I suggest your normal course of action be:

1. Identify the error message, (eg: ORA-00105)
2. Identify possible causes or actions by using the 'error message lookup' at the link above
3. Search the documentation for words or phrases in the reply to 2 using the 'search facility' at the link above

In this case, I suspect that it means that the dispatching mechanism is not configured for the TCP/IP network protocol that you are using in your loop back to your local host.

You will find there are 2 actions to take. However, you will find the action to error ORA-00120 much more useful to your scenario.

/Hans

Peter wrote:

> 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
Received on Wed Jun 04 2003 - 23:35:32 CDT