Re: MTS not workin ??

quarkman <quarkman_at_myrealbox.com> wrote in message news:<oprt4djwoozkogxn_at_haydn>...
> mts_dispatchers=(PROTOCOL=TCP)(DISPATCHERS=3)
> mts_servers=5
>
> You don't need a 'listener' parameter in the setting for dispatchers,
> because quite evidently, your listener runs tcp/ip on port 1521, and those
> are the defaults, and therefore the dispatchers will register themselves
> with that in any case. You only need all that other guff if your listener
> is not running tcp/ip, not on port 1521, or isn't called "listener".
>

here is the values of mts_* parameters after i left only 2 mts parameters in init.ora file as you specified above:

SELECT name, value FROM v$parameter WHERE name like 'mts%';

NAME	                     VALUE
--------------------         -----------------------------
mts_dispatchers	             (PROTOCOL=TCP)(DISPATCHERS=3)
mts_servers	             5
mts_max_servers	             20
mts_max_dispatchers	     5
mts_sessions	             33
mts_circuits	             38
mts_service	             PRACTICE
mts_listener_address	     [NULL]
mts_multiple_listeners	     FALSE