Re: Configuring dispatching mechanism

"Daniel Morgan" <damorgan_at_exxesolutions.com> wrote in message news:3EE8CA32.67FD5358_at_exxesolutions.com...
> 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
>
> Yet again we go through this:
>
> 1. What hardware platform and operating system?
> 2. How many CPUs?
> 3. What version and edition of Oracle?
>
> Tried reading your mind but I'm hard of thinking today.
> --
> Daniel Morgan
> http://www.outreach.washington.edu/extinfo/certprog/oad/oad_crs.asp
> damorgan_at_x.washington.edu
> (replace 'x' with a 'u' to reply)
>

I bet he is still thinking you can use 127.0.0.1 as a proper IP address.

-- 
Sybrand Bakker
Senior Oracle DBA

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



>