Re: MTS_DISPTACHERS errors and ORACLE does not start

From: Kenneth C Stahl <BluesSax_at_Unforgettable.com>
Date: Mon, 30 Aug 1999 08:25:48 -0400
Message-ID: <37CA784C.9EE8831E@Unforgettable.com>

Ashish Pai wrote:

> Hello All:
>
> Have installed 8.0.5 on Linux RH 5.2. Everything works fine except.
>
> I need to start a dispatcher for tcp. I have the follwoing line in
> initSID.ora:
>
> mts_dispatchers="(PROTOCOL=TCP)(dispatchers=1)"
>
> Thru svrmgrl when I startup I get the following message:
>
> SVRMGR> startup
> ORA-00101: invalid specification for system parameter MTS_DISPATCHERS
> ORA-00102: network protocol (ADDRESS=(PARTIAL=YES)(PROTOCOL=TCP))
>
> Ofcourse oracle fails to startup.
>
> My oracle version is:
>
> Oracle Server Manager Release 3.0.5.0.0 - Production
>
> (c) Copyright 1997, Oracle Corporation. All Rights Reserved.
>
> Oracle8 Release 8.0.5.0.0 - Production
> PL/SQL Release 8.0.5.0.0 - Production
>
> I have tried all the stuff mentioned in the docs on oracle website, but
> no success.
>
> Can someone shed some light on the above? Or try the above and see if it
> suceeds?

Your parameters are messed up. Here is what you need:

mts_dispatchers="tcp,10"
mts_max_dispatchers=1
mts_servers=1
mts_max_servers=10
mts_service=mysid
mts_listener_address="(ADDRESS=(PROTOCOL=tcp)(host=123.123.123.123)(port=1521))"

Substitute your own sid and ip address.

Ken

---

---

---

---

---

---

Received on Mon Aug 30 1999 - 07:25:48 CDT