Configuring dispatching mechanism

From: Peter <peter_at_nomorenewsspammin.ca>
Date: Thu, 05 Jun 2003 04:00:43 GMT
Message-ID: <gkftdv4hvg7jok5t285a5cgdjcb1a1p05i@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 Received on Wed Jun 04 2003 - 23:00:43 CDT