Re: How can I tell if MTS is activated -- more problems

On Wed, Nov 06, 2002 at 11:39:06AM -0800, Pablo Rodriguez wrote:
> Dave,
>
> I've seen these processes (ora_S00... and
> ora_d00..) but all connections are being made through
> dedicated processes.
>
> Here's my configuration:
>
> mts_listener_address = "(ADDRESS=(PROTOCOL=TCP)
> (HOST=10.20.81.78) (PORT=1521))"
> mts_service = PRUE1
> mts_dispatchers = "tcp,2"

I think this is old syntax for mts_dispatchers, v7ish, maybe. Look at the docs on where you are (I have not been following the thread). Seems like this happened to me when moving from oracle 7 -> 8. Maybe:

mts_dispatchers = "(PROTOCOL=TCP)(DISPATCHERS=1)"

> mts_max_dispatchers = 10
> mts_servers = 6
> mts_max_servers = 100
>
>
> The listener has been started before the RDBMS:
>
> listener.ora
>
> LISTENER =
> (ADDRESS_LIST=
>
> (ADDRESS=(PROTOCOL=tcp)(HOST=10.20.81.78)(PORT=1521))
> (ADDRESS=(PROTOCOL=ipc)(KEY=PRUE1)))
> SID_LIST_LISTENER=
> (SID_LIST=
> (SID_DESC=
> (GLOBAL_DBNAME=PRUE1)
> (SID_NAME=PRUE1)
> (ORACLE_HOME=/u01/app/oracle/product/8.1.7)
> )
> )
>
>
> lsnrctl services
>
> LSNRCTL for Linux: Version 8.1.7.0.0 - Production on
> 06-NOV-2002 16:40:58
>
> (c) Copyright 1998 Oracle Corporation. All rights
> reserved.
>
> Connecting to
> (ADDRESS=(PROTOCOL=tcp)(HOST=10.20.81.78)(PORT=1521))
> Services Summary...
> PRUE1 has 2 service handler(s)
> DEDICATED SERVER established:0 refused:0
> LOCAL SERVER
> DEDICATED SERVER established:0 refused:0
> LOCAL SERVER
> The command completed successfully
>
>
> BUT the user processes are not using MTS.
>
> Why aren't they using MTS?
> What's wrong in this configuration?
>
>
> thanks for your help.
>
>
>
>
>
> ------------------------------------------------------
> To see how many dispatchers/shared servers are started
> up with the RDBMS, check the value of
> 'mts_dispatchers' and 'mts_servers' in the init.ora.
> You can also tell by looking in the alert.log(default
> location is $ORACLE_HOME/rdbms/log).
> Sample:
> PMON started
> DBWR started
> LGWR started
> RECO started
> Thu Sep 14 09:24:15 1995
> starting up 4 shared server(s) ...
> starting up 4 dispatcher(s) for network
> See Note:1012480.6 on Metastink for mor info on MTS
> Processes
>
> Dave
>
> -----Original Message-----
> Sent: Wednesday, November 06, 2002 10:59 AM
> To: Multiple recipients of list ORACLE-L
>
>
> Oracle 8i
>
> How can I tell if MTS is activated?
>
> Which parameters should I look at? (in init.ora and
> listener.ora)
>
>
> thanks
> Pablo
>
>
>
> _______________________________________________________________
> Yahoo! Messenger
> Nueva versi?n: Webcam, voz, y mucho m?s ?Gratis!
> Desc?rgalo ya desde http://messenger.yahoo.es
> --
> Please see the official ORACLE-L FAQ:
> http://www.orafaq.com
> --
> Author: =?iso-8859-1?q?Pablo=20Rodriguez?=
> INET: p_rodri99_at_yahoo.es
>
> Fat City Network Services -- 858-538-5051
> http://www.fatcity.com
> San Diego, California -- Mailing list and web
> hosting services
> ---------------------------------------------------------------------
> 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: Farnsworth, Dave
> INET: DFarnsworth_at_Ashleyfurniture.com
>
> Fat City Network Services -- 858-538-5051
> http://www.fatcity.com
> San Diego, California -- Mailing list and web
> hosting services
> ---------------------------------------------------------------------
> 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
>
> _______________________________________________________________
> Yahoo! Messenger
> Nueva versi?n: Webcam, voz, y mucho m?s ?Gratis!
> Desc?rgalo ya desde http://messenger.yahoo.es
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> --
> Author: =?iso-8859-1?q?Pablo=20Rodriguez?=
> INET: p_rodri99_at_yahoo.es
>
> Fat City Network Services -- 858-538-5051 http://www.fatcity.com
> San Diego, California -- Mailing list and web hosting services
> ---------------------------------------------------------------------
> 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).

-- 
===============================================================
Ray Stell   stellr_at_vt.edu     (540) 231-4109     KE4TJC    28^D
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Ray Stell
  INET: stellr_at_cns.vt.edu

Fat City Network Services    -- 858-538-5051 http://www.fatcity.com
San Diego, California        -- Mailing list and web hosting services
---------------------------------------------------------------------
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).