Re: HELP: MTS_DISPATCHERS syntax

Don't know why they have changed that, ipc doesn't seem to be allowed as MTS address anymore.
This does make sense to me, as IPC is interprocess communication, so on the server only. You will need dedicated connections on the server, as SYSDBA based operations are not allowed with MTS (ie shutting the database). I assume you want MTS on TCP/IP. In this case the dispatcher should read "tcp,1", and the listener address, the usual listener address for tcp/ip

Hth,

Sybrand Bakker, Oracle DBA

Huy Vu wrote:

> Hi all,
>
> I'm trying to create an oracle database 8.0.4 with patch 8.0.4.3 but it
> refused to starting with MTS enable:
>
> SVRMGR> @cr1ACAR
> Connected.
> ORA-00101: invalid specification for system parameter MTS_DISPATCHERS
> create database "ACAR"
> *
> ORA-01034: ORACLE not available
>
> Here is the value of MTS in init.ora file:
>
> mts_dispatchers="ipc,1"
> mts_max_dispatchers=10
> mts_servers=1
> mts_max_servers=10
> mts_service=ACAR
> mts_listener_address="(ADDRESS=(PROTOCOL=ipc)(KEY=ACAR))"
>
> Do I miss something ?
>
> Thanks in advance for any help....
>
> H.V

Received on Sat Mar 20 1999 - 23:59:37 CST