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

From: <dgoulet_at_vicr.com>
Date: Wed, 06 Nov 2002 12:19:54 -0800
Message-ID: <F001.004FD23E.20021106121954@fatcity.com>

What does your TNSNAMES.ORA file look like? If there is a line in there '(server=dedicated)' you might as well turn MTS off.

Dick Goulet

____________________Reply Separator____________________
Author: =?iso-8859-1?q?Pablo=20Rodriguez?= <p_rodri99_at_yahoo.es>
Date:       11/6/2002 11:39 AM

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"
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).

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: 
  INET: dgoulet_at_vicr.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 HELP command for other information (like subscribing).

Received on Wed Nov 06 2002 - 14:19:54 CST