Re: MTS IS CONFIGURED BUT STILL DEDICATED CONNECTIONS USED
hi, have u made it? i also encounted the same problem of oracle 817 on solaris, if i specify server=shared in tnsnames.ora, then it gives out 12520 error code. - Original Message - From: Harvinder Singh [EMAIL PROTECTED] To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Wednesday, July 25, 2001 11:36 PM Subject: MTS IS CONFIGURED BUT STILL DEDICATED CONNECTIONS USED Hi, I have configured the server to use MTS and still dedicated connections r used. What might be the reasondatabase is 8.1.6.3.4 LSNRCTL services Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=IPC)(KEY=EXTPROC0))) Services Summary... ora2000 has 6 service handler(s) DISPATCHER established:0 refused:0 current:0 max:1022 state:ready D004 machine: ORA2000, pid: 1956 (ADDRESS=(PROTOCOL=tcp)(HOST=ora2000)(PORT=1393)) DISPATCHER established:0 refused:0 current:0 max:1022 state:ready D003 machine: ORA2000, pid: 1952 (ADDRESS=(PROTOCOL=tcp)(HOST=ora2000)(PORT=1391)) DISPATCHER established:0 refused:0 current:0 max:1022 state:ready D002 machine: ORA2000, pid: 1948 (ADDRESS=(PROTOCOL=tcp)(HOST=ora2000)(PORT=1390)) DISPATCHER established:0 refused:0 current:0 max:1022 state:ready D001 machine: ORA2000, pid: 1944 (ADDRESS=(PROTOCOL=tcp)(HOST=ora2000)(PORT=1387)) DISPATCHER established:0 refused:0 current:0 max:1022 state:ready D000 machine: ORA2000, pid: 1940 (ADDRESS=(PROTOCOL=tcp)(HOST=ora2000)(PORT=1385)) PLSExtProchas 1 service handler(s) DEDICATED SERVER established:0 refused:0 LOCAL SERVER ora2000 has 6 service handler(s) DISPATCHER established:0 refused:0 current:0 max:1022 state:ready D004 machine: ORA2000, pid: 1956 (ADDRESS=(PROTOCOL=tcp)(HOST=ora2000)(PORT=1393)) DISPATCHER established:0 refused:0 current:0 max:1022 state:ready D003 machine: ORA2000, pid: 1952 (ADDRESS=(PROTOCOL=tcp)(HOST=ora2000)(PORT=1391)) DISPATCHER established:0 refused:0 current:0 max:1022 state:ready D002 machine: ORA2000, pid: 1948 (ADDRESS=(PROTOCOL=tcp)(HOST=ora2000)(PORT=1390)) DISPATCHER established:0 refused:0 current:0 max:1022 state:ready D001 machine: ORA2000, pid: 1944 (ADDRESS=(PROTOCOL=tcp)(HOST=ora2000)(PORT=1387)) DISPATCHER established:0 refused:0 current:0 max:1022 state:ready D000 machine: ORA2000, pid: 1940 (ADDRESS=(PROTOCOL=tcp)(HOST=ora2000)(PORT=1385)) ora2000 has 1 service handler(s) DEDICATED SERVER established:0 refused:0 LOCAL SERVER ora2000 has 6 service handler(s) DEDICATED SERVER established:76 refused:0 LOCAL SERVER The command completed successfully init.ora looks like: mts_dispatchers = TCP,5 mts_max_dispatchers=50 mts_servers=20 mts_max_servers=50 LOCAL_LISTENER = (ADDRESS_LIST = (Address = (Protocol = TCP) (Host=ora2000) (Port=1521))) Thanks Harvinder -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Harvinder Singh INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists 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). æ¬zǶ¨}ø©ND ±@Bm§ÿðà +iöªrºØhÈZ¢§DMÈZ¢§Éòj(rV +r5ëp¢¹z»âqëçÎwó9ÔPó9ßÎtçT8'è®xæåÂ'µêçzÖqë,üÆ¢)à.+-±:Ã*.®Ç¥}úèØb²f¢)à+-±éÝjq +j)fzËëh.+-êî}«\Ü¢ièµá $ì¥éex(|¸¬´k«¹©Ý{azg¬±¨àØw%¹×)Þríj)â +I@ND º+¶§jg¨~f¢)à+-Ê°j{m¡·«zj/y×ë¢f(ºf²j[(±éݶ³Ü¢i×è®az¸§~æjبX¤z˱Êân)à
RE: MTS IS CONFIGURED BUT STILL DEDICATED CONNECTIONS USED
I'm betting you have epc_disabled in your listener.ora file. (ENVS='EPC_DISABLED=TRUE') This was put in to disable oracle trace in 8.0.5, but I was told it caused problems for 8.1.6. I hadn't looked on metalink for details, but after removing the epc_disabled line from my listener.ora, my MTS works fine under 8.1.6.3. I was having the same trouble getting only dedicated connections. I just looked so I guess I'll have to try double quotes. HTH Brian *** upgrade question 8.06 to 8.1.6 (EPC_DISABLED) Hello, friday i upgraded 8.0.6 to 8.1.6. thanks to you for the help l I became succesfull. The only issue i had was with the listener having this EPC_DISABLED=TRUE. the following is my current litsener configuration for 816. How can I enable EPC_DISABLED=TRUE for 8.1.6? When epc was enabled i received the following error message so i had to comment it out. === TNS-12500: TNS:listener failed to start a dedicated server process TNS-12533: TNS:illegal ADDRESS parameters TNS-12560: TNSrotocol adapter error TNS-00503: Illegal ADDRESS parameter = LISTENER = (ADDRESS_LIST = (ADDRESS = (PROTOCOL = IPC) (KEY = listener)) (ADDRESS = (PROTOCOL = IPC) (KEY = prod)) (ADDRESS = (PROTOCOL = tcp) (HOST = chihpdv2) (PORT = 1521)) ) CONNECT_TIMEOUT_LISTENER = 90 SID_LIST_LISTENER = (SID_LIST = (SID_DESC = (SID_NAME = prod) (ORACLE_HOME = /home/oracle/product/8.1.6) # (ENVS='EPC_DISABLED=TRUE') ) ) use double quotes around the environment string. -Original Message- From: chao_ping [mailto:[EMAIL PROTECTED]] Sent: Monday, August 06, 2001 2:46 AM To: Multiple recipients of list ORACLE-L Subject: Re: MTS IS CONFIGURED BUT STILL DEDICATED CONNECTIONS USED hi, have u made it? i also encounted the same problem of oracle 817 on solaris, if i specify server=shared in tnsnames.ora, then it gives out 12520 error code. - Original Message - From: Harvinder Singh [EMAIL PROTECTED] To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Wednesday, July 25, 2001 11:36 PM Subject: MTS IS CONFIGURED BUT STILL DEDICATED CONNECTIONS USED Hi, I have configured the server to use MTS and still dedicated connections r used. What might be the reasondatabase is 8.1.6.3.4 LSNRCTL services Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=IPC)(KEY=EXTPROC0))) Services Summary... ora2000 has 6 service handler(s) DISPATCHER established:0 refused:0 current:0 max:1022 state:ready D004 machine: ORA2000, pid: 1956 (ADDRESS=(PROTOCOL=tcp)(HOST=ora2000)(PORT=1393)) DISPATCHER established:0 refused:0 current:0 max:1022 state:ready D003 machine: ORA2000, pid: 1952 (ADDRESS=(PROTOCOL=tcp)(HOST=ora2000)(PORT=1391)) DISPATCHER established:0 refused:0 current:0 max:1022 state:ready D002 machine: ORA2000, pid: 1948 (ADDRESS=(PROTOCOL=tcp)(HOST=ora2000)(PORT=1390)) DISPATCHER established:0 refused:0 current:0 max:1022 state:ready D001 machine: ORA2000, pid: 1944 (ADDRESS=(PROTOCOL=tcp)(HOST=ora2000)(PORT=1387)) DISPATCHER established:0 refused:0 current:0 max:1022 state:ready D000 machine: ORA2000, pid: 1940 (ADDRESS=(PROTOCOL=tcp)(HOST=ora2000)(PORT=1385)) PLSExtProchas 1 service handler(s) DEDICATED SERVER established:0 refused:0 LOCAL SERVER ora2000 has 6 service handler(s) DISPATCHER established:0 refused:0 current:0 max:1022 state:ready D004 machine: ORA2000, pid: 1956 (ADDRESS=(PROTOCOL=tcp)(HOST=ora2000)(PORT=1393)) DISPATCHER established:0 refused:0 current:0 max:1022 state:ready D003 machine: ORA2000, pid: 1952 (ADDRESS=(PROTOCOL=tcp)(HOST=ora2000)(PORT=1391)) DISPATCHER established:0 refused:0 current:0 max:1022 state:ready D002 machine: ORA2000, pid: 1948 (ADDRESS=(PROTOCOL=tcp)(HOST=ora2000)(PORT=1390)) DISPATCHER established:0 refused:0 current:0 max:1022 state:ready D001 machine: ORA2000, pid: 1944 (ADDRESS=(PROTOCOL=tcp)(HOST=ora2000)(PORT=1387)) DISPATCHER established:0 refused:0 current:0 max:1022 state:ready D000 machine: ORA2000, pid: 1940 (ADDRESS=(PROTOCOL=tcp)(HOST=ora2000)(PORT=1385)) ora2000 has 1 service handler(s) DEDICATED SERVER established:0 refused:0 LOCAL SERVER ora2000 has 6 service handler(s) DEDICATED SERVER established:76 refused:0 LOCAL SERVER The command completed successfully init.ora looks like: mts_dispatchers = TCP,5 mts_max_dispatchers=50 mts_servers=20 mts_max_servers=50 LOCAL_LISTENER = (ADDRESS_LIST
Re: MTS IS CONFIGURED BUT STILL DEDICATED CONNECTIONS USED
Probably your clients or the users have in their sqlnet.ora the parameter use_dedicated_server=TRUE or in the entry of the tnsnames.ora a clause like (SERVER=DEDICATED). Also issue an netstat to see if everything is alright. If you find any problem with the ports of the dispatchers, try forcing them in the parameter mts_dispatcher. Regards. --- Harvinder Singh [EMAIL PROTECTED] wrote: Hi, I have configured the server to use MTS and still dedicated connections r used. What might be the reasondatabase is 8.1.6.3.4 LSNRCTL services Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=IPC)(KEY=EXTPROC0))) Services Summary... ora2000 has 6 service handler(s) DISPATCHER established:0 refused:0 current:0 max:1022 state:ready D004 machine: ORA2000, pid: 1956 (ADDRESS=(PROTOCOL=tcp)(HOST=ora2000)(PORT=1393)) DISPATCHER established:0 refused:0 current:0 max:1022 state:ready D003 machine: ORA2000, pid: 1952 (ADDRESS=(PROTOCOL=tcp)(HOST=ora2000)(PORT=1391)) DISPATCHER established:0 refused:0 current:0 max:1022 state:ready D002 machine: ORA2000, pid: 1948 (ADDRESS=(PROTOCOL=tcp)(HOST=ora2000)(PORT=1390)) DISPATCHER established:0 refused:0 current:0 max:1022 state:ready D001 machine: ORA2000, pid: 1944 (ADDRESS=(PROTOCOL=tcp)(HOST=ora2000)(PORT=1387)) DISPATCHER established:0 refused:0 current:0 max:1022 state:ready D000 machine: ORA2000, pid: 1940 (ADDRESS=(PROTOCOL=tcp)(HOST=ora2000)(PORT=1385)) PLSExtProchas 1 service handler(s) DEDICATED SERVER established:0 refused:0 LOCAL SERVER ora2000 has 6 service handler(s) DISPATCHER established:0 refused:0 current:0 max:1022 state:ready D004 machine: ORA2000, pid: 1956 (ADDRESS=(PROTOCOL=tcp)(HOST=ora2000)(PORT=1393)) DISPATCHER established:0 refused:0 current:0 max:1022 state:ready D003 machine: ORA2000, pid: 1952 (ADDRESS=(PROTOCOL=tcp)(HOST=ora2000)(PORT=1391)) DISPATCHER established:0 refused:0 current:0 max:1022 state:ready D002 machine: ORA2000, pid: 1948 (ADDRESS=(PROTOCOL=tcp)(HOST=ora2000)(PORT=1390)) DISPATCHER established:0 refused:0 current:0 max:1022 state:ready D001 machine: ORA2000, pid: 1944 (ADDRESS=(PROTOCOL=tcp)(HOST=ora2000)(PORT=1387)) DISPATCHER established:0 refused:0 current:0 max:1022 state:ready D000 machine: ORA2000, pid: 1940 (ADDRESS=(PROTOCOL=tcp)(HOST=ora2000)(PORT=1385)) ora2000 has 1 service handler(s) DEDICATED SERVER established:0 refused:0 LOCAL SERVER ora2000 has 6 service handler(s) DEDICATED SERVER established:76 refused:0 LOCAL SERVER The command completed successfully init.ora looks like: mts_dispatchers = TCP,5 mts_max_dispatchers=50 mts_servers=20 mts_max_servers=50 LOCAL_LISTENER = (ADDRESS_LIST = (Address = (Protocol = TCP) (Host=ora2000) (Port=1521))) Thanks Harvinder -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Harvinder Singh INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists 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). = Eng. Christian Trassens Senior DBA Systems Engineer [EMAIL PROTECTED] [EMAIL PROTECTED] Phone : 541149816062 __ Do You Yahoo!? Make international calls for as low as $.04/minute with Yahoo! Messenger http://phonecard.yahoo.com/ -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Christian Trassens INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists 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).
MTS IS CONFIGURED BUT STILL DEDICATED CONNECTIONS USED
Hi, I have configured the server to use MTS and still dedicated connections r used. What might be the reasondatabase is 8.1.6.3.4 LSNRCTL services Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=IPC)(KEY=EXTPROC0))) Services Summary... ora2000 has 6 service handler(s) DISPATCHER established:0 refused:0 current:0 max:1022 state:ready D004 machine: ORA2000, pid: 1956 (ADDRESS=(PROTOCOL=tcp)(HOST=ora2000)(PORT=1393)) DISPATCHER established:0 refused:0 current:0 max:1022 state:ready D003 machine: ORA2000, pid: 1952 (ADDRESS=(PROTOCOL=tcp)(HOST=ora2000)(PORT=1391)) DISPATCHER established:0 refused:0 current:0 max:1022 state:ready D002 machine: ORA2000, pid: 1948 (ADDRESS=(PROTOCOL=tcp)(HOST=ora2000)(PORT=1390)) DISPATCHER established:0 refused:0 current:0 max:1022 state:ready D001 machine: ORA2000, pid: 1944 (ADDRESS=(PROTOCOL=tcp)(HOST=ora2000)(PORT=1387)) DISPATCHER established:0 refused:0 current:0 max:1022 state:ready D000 machine: ORA2000, pid: 1940 (ADDRESS=(PROTOCOL=tcp)(HOST=ora2000)(PORT=1385)) PLSExtProchas 1 service handler(s) DEDICATED SERVER established:0 refused:0 LOCAL SERVER ora2000 has 6 service handler(s) DISPATCHER established:0 refused:0 current:0 max:1022 state:ready D004 machine: ORA2000, pid: 1956 (ADDRESS=(PROTOCOL=tcp)(HOST=ora2000)(PORT=1393)) DISPATCHER established:0 refused:0 current:0 max:1022 state:ready D003 machine: ORA2000, pid: 1952 (ADDRESS=(PROTOCOL=tcp)(HOST=ora2000)(PORT=1391)) DISPATCHER established:0 refused:0 current:0 max:1022 state:ready D002 machine: ORA2000, pid: 1948 (ADDRESS=(PROTOCOL=tcp)(HOST=ora2000)(PORT=1390)) DISPATCHER established:0 refused:0 current:0 max:1022 state:ready D001 machine: ORA2000, pid: 1944 (ADDRESS=(PROTOCOL=tcp)(HOST=ora2000)(PORT=1387)) DISPATCHER established:0 refused:0 current:0 max:1022 state:ready D000 machine: ORA2000, pid: 1940 (ADDRESS=(PROTOCOL=tcp)(HOST=ora2000)(PORT=1385)) ora2000 has 1 service handler(s) DEDICATED SERVER established:0 refused:0 LOCAL SERVER ora2000 has 6 service handler(s) DEDICATED SERVER established:76 refused:0 LOCAL SERVER The command completed successfully init.ora looks like: mts_dispatchers = TCP,5 mts_max_dispatchers=50 mts_servers=20 mts_max_servers=50 LOCAL_LISTENER = (ADDRESS_LIST = (Address = (Protocol = TCP) (Host=ora2000) (Port=1521))) Thanks Harvinder -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Harvinder Singh INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists 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: MTS IS CONFIGURED BUT STILL DEDICATED CONNECTIONS USED
Check the client's sqlnet.ora. It can override the server config with USE_DEDICATED_SERVER=ON setting. Steve -Original Message- Sent: Wednesday, July 25, 2001 10:36 AM To: Multiple recipients of list ORACLE-L Hi, I have configured the server to use MTS and still dedicated connections r used. What might be the reasondatabase is 8.1.6.3.4 LSNRCTL services Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=IPC)(KEY=EXTPROC0))) Services Summary... ora2000 has 6 service handler(s) DISPATCHER established:0 refused:0 current:0 max:1022 state:ready D004 machine: ORA2000, pid: 1956 (ADDRESS=(PROTOCOL=tcp)(HOST=ora2000)(PORT=1393)) DISPATCHER established:0 refused:0 current:0 max:1022 state:ready D003 machine: ORA2000, pid: 1952 (ADDRESS=(PROTOCOL=tcp)(HOST=ora2000)(PORT=1391)) DISPATCHER established:0 refused:0 current:0 max:1022 state:ready D002 machine: ORA2000, pid: 1948 (ADDRESS=(PROTOCOL=tcp)(HOST=ora2000)(PORT=1390)) DISPATCHER established:0 refused:0 current:0 max:1022 state:ready D001 machine: ORA2000, pid: 1944 (ADDRESS=(PROTOCOL=tcp)(HOST=ora2000)(PORT=1387)) DISPATCHER established:0 refused:0 current:0 max:1022 state:ready D000 machine: ORA2000, pid: 1940 (ADDRESS=(PROTOCOL=tcp)(HOST=ora2000)(PORT=1385)) PLSExtProchas 1 service handler(s) DEDICATED SERVER established:0 refused:0 LOCAL SERVER ora2000 has 6 service handler(s) DISPATCHER established:0 refused:0 current:0 max:1022 state:ready D004 machine: ORA2000, pid: 1956 (ADDRESS=(PROTOCOL=tcp)(HOST=ora2000)(PORT=1393)) DISPATCHER established:0 refused:0 current:0 max:1022 state:ready D003 machine: ORA2000, pid: 1952 (ADDRESS=(PROTOCOL=tcp)(HOST=ora2000)(PORT=1391)) DISPATCHER established:0 refused:0 current:0 max:1022 state:ready D002 machine: ORA2000, pid: 1948 (ADDRESS=(PROTOCOL=tcp)(HOST=ora2000)(PORT=1390)) DISPATCHER established:0 refused:0 current:0 max:1022 state:ready D001 machine: ORA2000, pid: 1944 (ADDRESS=(PROTOCOL=tcp)(HOST=ora2000)(PORT=1387)) DISPATCHER established:0 refused:0 current:0 max:1022 state:ready D000 machine: ORA2000, pid: 1940 (ADDRESS=(PROTOCOL=tcp)(HOST=ora2000)(PORT=1385)) ora2000 has 1 service handler(s) DEDICATED SERVER established:0 refused:0 LOCAL SERVER ora2000 has 6 service handler(s) DEDICATED SERVER established:76 refused:0 LOCAL SERVER The command completed successfully init.ora looks like: mts_dispatchers = TCP,5 mts_max_dispatchers=50 mts_servers=20 mts_max_servers=50 LOCAL_LISTENER = (ADDRESS_LIST = (Address = (Protocol = TCP) (Host=ora2000) (Port=1521))) Thanks Harvinder -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Harvinder Singh INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists 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: Austin, Steve S INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists 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: MTS IS CONFIGURED BUT STILL DEDICATED CONNECTIONS USED
this option is not set so i assume default is OFF... any other clue... -Original Message- Sent: Wednesday, July 25, 2001 12:26 PM To: Multiple recipients of list ORACLE-L Check the client's sqlnet.ora. It can override the server config with USE_DEDICATED_SERVER=ON setting. Steve -Original Message- Sent: Wednesday, July 25, 2001 10:36 AM To: Multiple recipients of list ORACLE-L Hi, I have configured the server to use MTS and still dedicated connections r used. What might be the reasondatabase is 8.1.6.3.4 LSNRCTL services Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=IPC)(KEY=EXTPROC0))) Services Summary... ora2000 has 6 service handler(s) DISPATCHER established:0 refused:0 current:0 max:1022 state:ready D004 machine: ORA2000, pid: 1956 (ADDRESS=(PROTOCOL=tcp)(HOST=ora2000)(PORT=1393)) DISPATCHER established:0 refused:0 current:0 max:1022 state:ready D003 machine: ORA2000, pid: 1952 (ADDRESS=(PROTOCOL=tcp)(HOST=ora2000)(PORT=1391)) DISPATCHER established:0 refused:0 current:0 max:1022 state:ready D002 machine: ORA2000, pid: 1948 (ADDRESS=(PROTOCOL=tcp)(HOST=ora2000)(PORT=1390)) DISPATCHER established:0 refused:0 current:0 max:1022 state:ready D001 machine: ORA2000, pid: 1944 (ADDRESS=(PROTOCOL=tcp)(HOST=ora2000)(PORT=1387)) DISPATCHER established:0 refused:0 current:0 max:1022 state:ready D000 machine: ORA2000, pid: 1940 (ADDRESS=(PROTOCOL=tcp)(HOST=ora2000)(PORT=1385)) PLSExtProchas 1 service handler(s) DEDICATED SERVER established:0 refused:0 LOCAL SERVER ora2000 has 6 service handler(s) DISPATCHER established:0 refused:0 current:0 max:1022 state:ready D004 machine: ORA2000, pid: 1956 (ADDRESS=(PROTOCOL=tcp)(HOST=ora2000)(PORT=1393)) DISPATCHER established:0 refused:0 current:0 max:1022 state:ready D003 machine: ORA2000, pid: 1952 (ADDRESS=(PROTOCOL=tcp)(HOST=ora2000)(PORT=1391)) DISPATCHER established:0 refused:0 current:0 max:1022 state:ready D002 machine: ORA2000, pid: 1948 (ADDRESS=(PROTOCOL=tcp)(HOST=ora2000)(PORT=1390)) DISPATCHER established:0 refused:0 current:0 max:1022 state:ready D001 machine: ORA2000, pid: 1944 (ADDRESS=(PROTOCOL=tcp)(HOST=ora2000)(PORT=1387)) DISPATCHER established:0 refused:0 current:0 max:1022 state:ready D000 machine: ORA2000, pid: 1940 (ADDRESS=(PROTOCOL=tcp)(HOST=ora2000)(PORT=1385)) ora2000 has 1 service handler(s) DEDICATED SERVER established:0 refused:0 LOCAL SERVER ora2000 has 6 service handler(s) DEDICATED SERVER established:76 refused:0 LOCAL SERVER The command completed successfully init.ora looks like: mts_dispatchers = TCP,5 mts_max_dispatchers=50 mts_servers=20 mts_max_servers=50 LOCAL_LISTENER = (ADDRESS_LIST = (Address = (Protocol = TCP) (Host=ora2000) (Port=1521))) Thanks Harvinder -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Harvinder Singh INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists 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: Austin, Steve S INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists 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: Harvinder Singh INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists 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: MTS IS CONFIGURED BUT STILL DEDICATED CONNECTIONS USED
A couple of things I would check. I don't believe you need the ADDRESS_LIST parameter, unless you will have multiples. I would remove the spaces in the parameter. I would make sure that the HOST equals the machine name, possibly make the entry upper case. As foolish as it sounds, I've seen these things make a difference. Set it up to look like this and see if it helps. LOCAL_LISTENER = (Address=(Protocol=TCP)(Host=ORA2000)(Port=1521)) I recently had a problem where the HOST wasn't the same as the machine name. Fixed that and the problem went away. Hope this helps out, Durinda -Original Message- Sent: Wednesday, July 25, 2001 1:11 PM To: Multiple recipients of list ORACLE-L this option is not set so i assume default is OFF... any other clue... -Original Message- Sent: Wednesday, July 25, 2001 12:26 PM To: Multiple recipients of list ORACLE-L Check the client's sqlnet.ora. It can override the server config with USE_DEDICATED_SERVER=ON setting. Steve -Original Message- Sent: Wednesday, July 25, 2001 10:36 AM To: Multiple recipients of list ORACLE-L Hi, I have configured the server to use MTS and still dedicated connections r used. What might be the reasondatabase is 8.1.6.3.4 LSNRCTL services Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=IPC)(KEY=EXTPROC0))) Services Summary... ora2000 has 6 service handler(s) DISPATCHER established:0 refused:0 current:0 max:1022 state:ready D004 machine: ORA2000, pid: 1956 (ADDRESS=(PROTOCOL=tcp)(HOST=ora2000)(PORT=1393)) DISPATCHER established:0 refused:0 current:0 max:1022 state:ready D003 machine: ORA2000, pid: 1952 (ADDRESS=(PROTOCOL=tcp)(HOST=ora2000)(PORT=1391)) DISPATCHER established:0 refused:0 current:0 max:1022 state:ready D002 machine: ORA2000, pid: 1948 (ADDRESS=(PROTOCOL=tcp)(HOST=ora2000)(PORT=1390)) DISPATCHER established:0 refused:0 current:0 max:1022 state:ready D001 machine: ORA2000, pid: 1944 (ADDRESS=(PROTOCOL=tcp)(HOST=ora2000)(PORT=1387)) DISPATCHER established:0 refused:0 current:0 max:1022 state:ready D000 machine: ORA2000, pid: 1940 (ADDRESS=(PROTOCOL=tcp)(HOST=ora2000)(PORT=1385)) PLSExtProchas 1 service handler(s) DEDICATED SERVER established:0 refused:0 LOCAL SERVER ora2000 has 6 service handler(s) DISPATCHER established:0 refused:0 current:0 max:1022 state:ready D004 machine: ORA2000, pid: 1956 (ADDRESS=(PROTOCOL=tcp)(HOST=ora2000)(PORT=1393)) DISPATCHER established:0 refused:0 current:0 max:1022 state:ready D003 machine: ORA2000, pid: 1952 (ADDRESS=(PROTOCOL=tcp)(HOST=ora2000)(PORT=1391)) DISPATCHER established:0 refused:0 current:0 max:1022 state:ready D002 machine: ORA2000, pid: 1948 (ADDRESS=(PROTOCOL=tcp)(HOST=ora2000)(PORT=1390)) DISPATCHER established:0 refused:0 current:0 max:1022 state:ready D001 machine: ORA2000, pid: 1944 (ADDRESS=(PROTOCOL=tcp)(HOST=ora2000)(PORT=1387)) DISPATCHER established:0 refused:0 current:0 max:1022 state:ready D000 machine: ORA2000, pid: 1940 (ADDRESS=(PROTOCOL=tcp)(HOST=ora2000)(PORT=1385)) ora2000 has 1 service handler(s) DEDICATED SERVER established:0 refused:0 LOCAL SERVER ora2000 has 6 service handler(s) DEDICATED SERVER established:76 refused:0 LOCAL SERVER The command completed successfully init.ora looks like: mts_dispatchers = TCP,5 mts_max_dispatchers=50 mts_servers=20 mts_max_servers=50 LOCAL_LISTENER = (ADDRESS_LIST = (Address = (Protocol = TCP) (Host=ora2000) (Port=1521))) Thanks Harvinder -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Harvinder Singh INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists 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: Austin, Steve S INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists 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
RE: MTS IS CONFIGURED BUT STILL DEDICATED CONNECTIONS USED
i tried removing the spaces but it didn't help..if the client and server r on the same machine ... will it use ipc instead of tcp and if so do i have to configure dispacher for ipc and mention ipc in local_listener. -H -Original Message- Sent: Wednesday, July 25, 2001 3:09 PM To: Multiple recipients of list ORACLE-L A couple of things I would check. I don't believe you need the ADDRESS_LIST parameter, unless you will have multiples. I would remove the spaces in the parameter. I would make sure that the HOST equals the machine name, possibly make the entry upper case. As foolish as it sounds, I've seen these things make a difference. Set it up to look like this and see if it helps. LOCAL_LISTENER = (Address=(Protocol=TCP)(Host=ORA2000)(Port=1521)) I recently had a problem where the HOST wasn't the same as the machine name. Fixed that and the problem went away. Hope this helps out, Durinda -Original Message- Sent: Wednesday, July 25, 2001 1:11 PM To: Multiple recipients of list ORACLE-L this option is not set so i assume default is OFF... any other clue... -Original Message- Sent: Wednesday, July 25, 2001 12:26 PM To: Multiple recipients of list ORACLE-L Check the client's sqlnet.ora. It can override the server config with USE_DEDICATED_SERVER=ON setting. Steve -Original Message- Sent: Wednesday, July 25, 2001 10:36 AM To: Multiple recipients of list ORACLE-L Hi, I have configured the server to use MTS and still dedicated connections r used. What might be the reasondatabase is 8.1.6.3.4 LSNRCTL services Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=IPC)(KEY=EXTPROC0))) Services Summary... ora2000 has 6 service handler(s) DISPATCHER established:0 refused:0 current:0 max:1022 state:ready D004 machine: ORA2000, pid: 1956 (ADDRESS=(PROTOCOL=tcp)(HOST=ora2000)(PORT=1393)) DISPATCHER established:0 refused:0 current:0 max:1022 state:ready D003 machine: ORA2000, pid: 1952 (ADDRESS=(PROTOCOL=tcp)(HOST=ora2000)(PORT=1391)) DISPATCHER established:0 refused:0 current:0 max:1022 state:ready D002 machine: ORA2000, pid: 1948 (ADDRESS=(PROTOCOL=tcp)(HOST=ora2000)(PORT=1390)) DISPATCHER established:0 refused:0 current:0 max:1022 state:ready D001 machine: ORA2000, pid: 1944 (ADDRESS=(PROTOCOL=tcp)(HOST=ora2000)(PORT=1387)) DISPATCHER established:0 refused:0 current:0 max:1022 state:ready D000 machine: ORA2000, pid: 1940 (ADDRESS=(PROTOCOL=tcp)(HOST=ora2000)(PORT=1385)) PLSExtProchas 1 service handler(s) DEDICATED SERVER established:0 refused:0 LOCAL SERVER ora2000 has 6 service handler(s) DISPATCHER established:0 refused:0 current:0 max:1022 state:ready D004 machine: ORA2000, pid: 1956 (ADDRESS=(PROTOCOL=tcp)(HOST=ora2000)(PORT=1393)) DISPATCHER established:0 refused:0 current:0 max:1022 state:ready D003 machine: ORA2000, pid: 1952 (ADDRESS=(PROTOCOL=tcp)(HOST=ora2000)(PORT=1391)) DISPATCHER established:0 refused:0 current:0 max:1022 state:ready D002 machine: ORA2000, pid: 1948 (ADDRESS=(PROTOCOL=tcp)(HOST=ora2000)(PORT=1390)) DISPATCHER established:0 refused:0 current:0 max:1022 state:ready D001 machine: ORA2000, pid: 1944 (ADDRESS=(PROTOCOL=tcp)(HOST=ora2000)(PORT=1387)) DISPATCHER established:0 refused:0 current:0 max:1022 state:ready D000 machine: ORA2000, pid: 1940 (ADDRESS=(PROTOCOL=tcp)(HOST=ora2000)(PORT=1385)) ora2000 has 1 service handler(s) DEDICATED SERVER established:0 refused:0 LOCAL SERVER ora2000 has 6 service handler(s) DEDICATED SERVER established:76 refused:0 LOCAL SERVER The command completed successfully init.ora looks like: mts_dispatchers = TCP,5 mts_max_dispatchers=50 mts_servers=20 mts_max_servers=50 LOCAL_LISTENER = (ADDRESS_LIST = (Address = (Protocol = TCP) (Host=ora2000) (Port=1521))) Thanks Harvinder -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Harvinder Singh INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists 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: Austin, Steve S INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists
MTS IS CONFIGURED BUT STILL DEDICATED CONNECTIONS USED
Hi, I have configured the server to use MTS and still dedicated connections r used. What might be the reasondatabase is 8.1.6.3.4 LSNRCTL services Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=IPC)(KEY=EXTPROC0))) Services Summary... ora2000 has 6 service handler(s) DISPATCHER established:0 refused:0 current:0 max:1022 state:ready D004 machine: ORA2000, pid: 1956 (ADDRESS=(PROTOCOL=tcp)(HOST=ora2000)(PORT=1393)) DISPATCHER established:0 refused:0 current:0 max:1022 state:ready D003 machine: ORA2000, pid: 1952 (ADDRESS=(PROTOCOL=tcp)(HOST=ora2000)(PORT=1391)) DISPATCHER established:0 refused:0 current:0 max:1022 state:ready D002 machine: ORA2000, pid: 1948 (ADDRESS=(PROTOCOL=tcp)(HOST=ora2000)(PORT=1390)) DISPATCHER established:0 refused:0 current:0 max:1022 state:ready D001 machine: ORA2000, pid: 1944 (ADDRESS=(PROTOCOL=tcp)(HOST=ora2000)(PORT=1387)) DISPATCHER established:0 refused:0 current:0 max:1022 state:ready D000 machine: ORA2000, pid: 1940 (ADDRESS=(PROTOCOL=tcp)(HOST=ora2000)(PORT=1385)) PLSExtProchas 1 service handler(s) DEDICATED SERVER established:0 refused:0 LOCAL SERVER ora2000 has 6 service handler(s) DISPATCHER established:0 refused:0 current:0 max:1022 state:ready D004 machine: ORA2000, pid: 1956 (ADDRESS=(PROTOCOL=tcp)(HOST=ora2000)(PORT=1393)) DISPATCHER established:0 refused:0 current:0 max:1022 state:ready D003 machine: ORA2000, pid: 1952 (ADDRESS=(PROTOCOL=tcp)(HOST=ora2000)(PORT=1391)) DISPATCHER established:0 refused:0 current:0 max:1022 state:ready D002 machine: ORA2000, pid: 1948 (ADDRESS=(PROTOCOL=tcp)(HOST=ora2000)(PORT=1390)) DISPATCHER established:0 refused:0 current:0 max:1022 state:ready D001 machine: ORA2000, pid: 1944 (ADDRESS=(PROTOCOL=tcp)(HOST=ora2000)(PORT=1387)) DISPATCHER established:0 refused:0 current:0 max:1022 state:ready D000 machine: ORA2000, pid: 1940 (ADDRESS=(PROTOCOL=tcp)(HOST=ora2000)(PORT=1385)) ora2000 has 1 service handler(s) DEDICATED SERVER established:0 refused:0 LOCAL SERVER ora2000 has 6 service handler(s) DEDICATED SERVER established:76 refused:0 LOCAL SERVER The command completed successfully init.ora looks like: mts_dispatchers = TCP,5 mts_max_dispatchers=50 mts_servers=20 mts_max_servers=50 LOCAL_LISTENER = (ADDRESS_LIST = (Address = (Protocol = TCP) (Host=ora2000) (Port=1521))) Thanks Harvinder -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Harvinder Singh INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists 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).