Re: MTS help requested...

From: Kenneth C Stahl <BlueSax_at_Unforgetable.com>
Date: Thu, 13 Jan 2000 07:49:39 -0500
Message-ID: <387DC9E3.1CB7A054@Unforgetable.com>

David wrote:
>
> Looking for some help, trying to set up MTS on NT and Linux (both
> oracle 8.0.5) and I keep getting the following error on startup with
> both systems.
>
> ORA-00101: invalid specification for system parameter MTS_DISPATCHERS
> ORA-00102: network protocol (ADDRESS=(PARTIAL=YES)(PROTOCOL=tcp))
> cannot be used by dispatchers
>
> The parameters in the init.ora file as as follows....
>
> mts_dispatchers="(DIS=2)(PRO=TCP)"
> mts_max_dispatchers=10
> mts_servers=1
> mts_max_servers=10
> local_listener = MTSLSNR
>
> I have tried messing with mts_dispatchers string format (i.e. single
> quotes, upper case, different order of arguements even though these
> should not matter as far as I have read)
>
> Now BOTH machines are part of a TCP/IP network, so the TCP/IP protocol
> is on both and I can do local naming and host naming to both oracle
> instances so it confuses me that the dispatchers "can't" use tcp.

Try:

mts_dispatchers="tcp,1"
mts_max_dispatchers=10
mts_servers=1
mts_max_servers=10
mts_service="orcl"        # Substitute the name you want to give to the

service
mts_listener_address="(ADDRESS=(PROTOCOL=tcp)(host=myhost)(port=1521))"

(where "myhost" is the name of your system in the hosts file). Received on Thu Jan 13 2000 - 06:49:39 CST