| 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: How can I tell if MTS is activated -- more problems
Another place to look is how connections are made to the database.
Do you know if the connections are bypassing the tnsnames.ora altogether and using their own connect string wherein they could be specifying a dedicated server?
First thing to determine is whether connections are in fact using tnsnames.ora. The developers should be able to answer this question.
For example, an application could be using JDBC to connect to db and the connection could specify a complete connect string and not use tnsnames.ora at all.
HTH,
Gerardo
-----Original Message-----
Sent: Wednesday, November 06, 2002 11:39 AM
To: Multiple recipients of list ORACLE-L
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 - 16:13:41 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: Molina, Gerardo INET: Gerardo.Molina_at_schwab.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).
 |
 |