Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: HELP: MTS_DISPATCHERS syntax

Re: HELP: MTS_DISPATCHERS syntax

From: Chris Hamilton <ToneCzar_at_erols.com>
Date: Sun, 21 Mar 1999 12:15:54 GMT
Message-ID: <36f5e265.2604818@news.erols.com>


On Sat, 20 Mar 1999 22:48:51 -0500, Huy Vu <huyv_at_usa.net> 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 ?

Here's a working configuration on 8.0.5 ...

Note the local_listener includes two different ports for load balancing.

local_listener = "(address_list = \
                  (address=(protocol=tcp)(host=sunbox)(port=1525)) \
                  (address=(protocol=tcp)(host=sunbox)(port=1526)) )"
mts_service = WSS1
mts_dispatchers = "(protocol=tcp)(dispatchers=5)"
mts_max_dispatchers = 30

mts_servers = 20
mts_max_servers = 200

Is the mts_listener_address you've used still valid in 8.x? Some parameters were obsoleted in Oracle8.

Chris



Chris Hamilton -- toneczar_at_erols.com
Oracle DBA -- Wall Street Sports
http://www.wallstreetsports.com/ Received on Sun Mar 21 1999 - 06:15:54 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US