RE: How can I tell if MTS is activated -- more problems
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).
Re: How can I tell if MTS is activated -- more problems
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
Re: How can I tell if MTS is activated -- more problems
Pablo, init.ora -- Look at the dispatchers=... parameter (You can comment it out if you don't want MTS) listener.ora -- Look for (SERVER = DEDICATED) vs. (SERVER = SHARED) In SQLPLUS -- SQL SELECT servers_started FROM v$mts; -Scott Stefick -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 ** Scott Stefick UNIX Systems Administrator Oracle Certified Professional DBA Wm. Rainey Harper College 847.925.6130 ** -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Scott Stefick 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).
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. -- 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).
