Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: Configuring dispatching mechanism

Re: Configuring dispatching mechanism

From: Peter <peter_at_nomorenewsspammin.ca>
Date: Thu, 05 Jun 2003 06:33:20 GMT
Message-ID: <3votdvslebqn121rfmfpd50aa6s5rsboic@4ax.com>


On Thu, 5 Jun 2003 06:30:11 +0200, "Sybrand Bakker" <postbus_at_sybrandb.demon.nl> wrote:

>
>"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

I am using Oracle9i Received on Thu Jun 05 2003 - 01:33:20 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US