Re: Configuring dispatching mechanism

On Thu, 05 Jun 2003 04:35:32 GMT, Hans Forbrich <forbrich_at_telusplanet.net> wrote:

I did some research on ORA-00120 and I got:

ORA-00120 dispatching mechanism not enabled or installed

Cause: Either the dispatching mechanism was not enabled or the Oracle executable image was not installed with the dispatching mechanism.

Action: Refer to the Oracle9i Database Administrator's Guide and your operating system-specific documentation for procedures for starting and configuring the dispatcher process.

But what exactly is the dispatching mechanism? A search of the manual for "dispatching mechanism" returned 2 results:

Enterprise Edition System Administration Guide for OS/390 (1 matching topics)  

Error Messages (2 matching topics)

The first one is not related. The second one is the error messages.  

ORA-00105 dispatching mechanism not configured for network protocol string

Cause: An attempt was made to alter the dispatcher's configuration for a network protocol that was not specified in the initialization parameter file.

Action: Do one of the following:

Include the network protocol in the definition for the DISPATCHERS initialization parameter and restart the system. Use the ALTER SYSTEM SET DISPATCHERS statement with a network protocol that exists in the initialization parameter file.

For this error, I have already included dispatchers="(protocol=tcp)"
in my spfile, but still it didn't work.

>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 Thu Jun 05 2003 - 01:20:39 CDT