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?= <[EMAIL PROTECTED]>
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: [EMAIL PROTECTED]
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: [EMAIL PROTECTED] (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: [EMAIL PROTECTED]
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: [EMAIL PROTECTED] (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: [EMAIL PROTECTED]
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: [EMAIL PROTECTED] (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: [EMAIL PROTECTED]
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: [EMAIL PROTECTED] (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).
