Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Mailing Lists -> Oracle-L -> RE: mts connections
Hi,
That it is because you aren't using a service referencing the dispatcher.
F.e.
On 8i: in init.ora
mts_dispatchers="(protocol=ipc)(dispatchers=1)(service=mtsipc)"
And in the tnsnames.ora
mtsservice= (DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL =IPC)(KEY=<SID or if you use listener.ora, then
the ipc alias>))
)
(CONNECT_DATA = (service_name= mtsipc))
)
> -----Mensaje original-----
> De: exu_at_nnng.com [SMTP:exu_at_nnng.com]
> Enviado el: lunes 19 de febrero de 2001 18:21
> Para: Multiple recipients of list ORACLE-L
> Asunto: mts connections
>
>
>
> Hi list,
>
> I set up MTS for one of my instance in Sun OS 5.7 Looks like that the
> setup
> works fine by issue 'lsnrctl services' command:
>
> tsp has 2 service handler(s)
> DEDICATED SERVER established:6332 refused:0
> LOCAL SERVER
> DISPATCHER established:0 refused:0 current:0 max:254 state:ready
> D000 <machine: nnidb1, pid: 5412>
> (ADDRESS=(PROTOCOL=ipc)(DEV=20)(KEY=#5412.1))
>
> My question is, why no session has ever established through dispather,
> even
> though there are 6332 session connected through
> dedicated services. Is there a threshod for MTS kicks in?
>
> TIA
>
> Eveleen
>
>
>
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> --
> Author:
> INET: exu_at_nnng.com
>
> Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051
> San Diego, California -- Public Internet access / Mailing Lists
> --------------------------------------------------------------------
> To REMOVE yourself from this mailing list, send an E-Mail message
> to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
> the message BODY, include a line containing: UNSUB ORACLE-L
> (or the name of mailing list you want to be removed from). You may
> also send the HELP command for other information (like subscribing).
-- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Trassens, Christian INET: CTrassens_at_uni2.es Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051 San Diego, California -- Public Internet access / Mailing Lists -------------------------------------------------------------------- To REMOVE yourself from this mailing list, send an E-Mail message to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).Received on Mon Feb 19 2001 - 12:35:22 CST