| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
 |
 | |||
| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
|
| |||
Home -> Community -> Mailing Lists -> Oracle-L -> Re:RE: How can I tell if MTS is activated -- more problems
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.
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
-- 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-LReceived on Wed Nov 06 2002 - 14:19:54 CST
(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).
 |
 |