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.
------------------------------------------------------
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: Molina, Gerardo
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).
