Re: Configuring dispatching mechanism

On Thu, 05 Jun 2003 06:20:39 GMT, Peter <peter_at_nomorenewsspammin.ca> wrote:

By adding (server = shared) to the
CONNECT_DATA attribute in the TNSNAMES.ORA file actually prevented me from logging on to an instance. Does this have anything to do with the errors?

>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:39:44 CDT