Re: MTS not workin ??

On 19 Aug 2003 07:53:13 -0700, Ibrahim DOGAN <ibrahim.dogan_at_lowes.com> wrote:

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

I assume that you are suggesting that, despite following the advice to just have two lines in the init.ora for dispatchers and shared server, the thing is still not working?

What about all the other advice I put in the first reply?

lsnrctl services needs to be done, and the output posted here. And your tnsnames.ora needs to refer to a SERVICE and not a SID. So post that whilst you're at it.

And, most importantly, tell us what your Oracle version is. Otherwise this little bit of help can go no further.

Regards
HJR Received on Tue Aug 19 2003 - 14:46:16 CDT