Re:RE: MTS config
Thanks to all who replied. It took filing an iTAR to get the answer and then it took OTS 2 days to find the "fat finger" that caused the problems. Dick Goulet Reply Separator Author: "Adrian Roe" <[EMAIL PROTECTED]> Date: 2/25/2003 7:09 AM Looks fine. We only have the following entries on a 9i database.. dispatchers = "(protocol = TCP)(dispatchers = 6)" max_dispatchers = 12 shared_servers = 10 max_shared_servers = 40 Works fine, we ended up commenting out local_listener. How long have you waited for the dispatchers to register ? It does not happen instantly. Have you tried "lsnrctl reload" ? -Original Message- Sent: 25 February 2003 14:04 To: Multiple recipients of list ORACLE-L OK, Someone dope slap me! I added the following to my init.ora file (8.1.7.0 on HP-UX 11.0). The dispatchers start up just fine, but won't register with the listener (also 8.1.7.0). I've already done the RTFM and MetaLink RTFM but can't see the problem. mts_servers=5 mts_max_dispatchers=10 mts_max_servers=40 service_names=05 # mts_dispatchers="(PROTOCOL=ipc)(DISPATCHERS=2)" mts_dispatchers="(PROTOCOL=TCP)(DISPATCHERS=4)" local_listener="(address_list=(ADDRESS=(PROTOCOL=ipc)(KEY=05)) (ADDRESS=(PROTOCOL=tcp)(PORT=1521)(HOST=bart)))" Thanks for the second set of eyes. BTW, the end result would be to have all outside TCP connections use MTS only. Dick Goulet -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: 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). -- Live Life in Broadband www.telewest.co.uk The information transmitted is intended only for the person or entity to which it is addressed and may contain confidential and/or privileged material. Statements and opinions expressed in this e-mail may not represent those of the company. Any review, retransmission, dissemination or other use of, or taking of any action in reliance upon, this information by persons or entities other than the intended recipient is prohibited. If you received this in error, please contact the sender immediately and delete the material from any computer. == -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Adrian Roe 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.net -- Author: 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:RE: MTS config
Let's see, how about overnight and yes I have reloaded the listener. Dick Goulet Reply Separator Author: "Adrian Roe" <[EMAIL PROTECTED]> Date: 2/25/2003 7:09 AM Looks fine. We only have the following entries on a 9i database.. dispatchers = "(protocol = TCP)(dispatchers = 6)" max_dispatchers = 12 shared_servers = 10 max_shared_servers = 40 Works fine, we ended up commenting out local_listener. How long have you waited for the dispatchers to register ? It does not happen instantly. Have you tried "lsnrctl reload" ? -Original Message- Sent: 25 February 2003 14:04 To: Multiple recipients of list ORACLE-L OK, Someone dope slap me! I added the following to my init.ora file (8.1.7.0 on HP-UX 11.0). The dispatchers start up just fine, but won't register with the listener (also 8.1.7.0). I've already done the RTFM and MetaLink RTFM but can't see the problem. mts_servers=5 mts_max_dispatchers=10 mts_max_servers=40 service_names=05 # mts_dispatchers="(PROTOCOL=ipc)(DISPATCHERS=2)" mts_dispatchers="(PROTOCOL=TCP)(DISPATCHERS=4)" local_listener="(address_list=(ADDRESS=(PROTOCOL=ipc)(KEY=05)) (ADDRESS=(PROTOCOL=tcp)(PORT=1521)(HOST=bart)))" Thanks for the second set of eyes. BTW, the end result would be to have all outside TCP connections use MTS only. Dick Goulet -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: 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). -- Live Life in Broadband www.telewest.co.uk The information transmitted is intended only for the person or entity to which it is addressed and may contain confidential and/or privileged material. Statements and opinions expressed in this e-mail may not represent those of the company. Any review, retransmission, dissemination or other use of, or taking of any action in reliance upon, this information by persons or entities other than the intended recipient is prohibited. If you received this in error, please contact the sender immediately and delete the material from any computer. == -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Adrian Roe 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.net -- Author: 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).