On Wed, Nov 06, 2002 at 11:39:06AM -0800, Pablo Rodriguez wrote: > 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"
I think this is old syntax for mts_dispatchers, v7ish, maybe. Look at the docs on where you are (I have not been following the thread). Seems like this happened to me when moving from oracle 7 -> 8. Maybe: mts_dispatchers = "(PROTOCOL=TCP)(DISPATCHERS=1)" > 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). -- =============================================================== Ray Stell [EMAIL PROTECTED] (540) 231-4109 KE4TJC 28^D -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Ray Stell 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).
