RE: RAC interconnects
Title: Message Strictly speaking, it's not a part of Oracle DLM, it's a part of vendor's cluster manager. In other words, it's a TCP stack thing. Your host must be able to have one "logical network card" that would automagically distribute load among several physical NIC's. --Mladen GogalaOracle DBA -Original Message-From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Jamadagni, RajendraSent: Friday, August 08, 2003 9:09 AMTo: Multiple recipients of list ORACLE-LSubject: RAC interconnects Hi all, Is it possible to somehow tell Oracle to use all available interconnects (between nodes) for the GC traffic? We have 2 private interconnects but we see all the traffic only on one of them. The other is used only if the first one is not available. If Oracle could use both, it would balance the load too ?? Is it possible? Raj Rajendra dot Jamadagni at nospamespn dot com All Views expressed in this email are strictly personal. QOTD: Any clod can have facts, having an opinion is an art ! Note: This message is for the named person's use only. It may contain confidential, proprietary or legally privileged information. No confidentiality or privilege is waived or lost by any mistransmission. If you receive this message in error,please immediately delete it and all copies of it from your system, destroy any hard copies of it and notify the sender. You must not, directly or indirectly, use, disclose, distribute, print, or copy any part of this message if you are not the intended recipient.Wang Trading LLCand any of its subsidiaries each reserve the right to monitor all e-mail communications through its networks. Any views expressed in this message are those of the individual sender, except where the message states otherwise and the sender is authorized to state them to be the views of any such entity.
Re: RAC interconnects
Title: Re: RAC interconnects Check out the init.ora parameter CLUSTER_INTERCONNECTS. Have never used it, but it appears to be what youre looking for... What platform? on 8/8/03 6:09 AM, Jamadagni, Rajendra at [EMAIL PROTECTED] wrote: Hi all, Is it possible to somehow tell Oracle to use all available interconnects (between nodes) for the GC traffic? We have 2 private interconnects but we see all the traffic only on one of them. The other is used only if the first one is not available. If Oracle could use both, it would balance the load too ?? Is it possible? Raj Rajendra dot Jamadagni at nospamespn dot com All Views expressed in this email are strictly personal. QOTD: Any clod can have facts, having an opinion is an art !
RE: RAC interconnects
Title: Re: RAC interconnects Thanks Tim, The problem with that parameter is Oracle will then restrict communication to only those listed in there, overriding the failover provided by OS and os clustering software. Raj Rajendra dot Jamadagni at nospamespn dot com All Views expressed in this email are strictly personal. QOTD: Any clod can have facts, having an opinion is an art ! -Original Message-From: Tim Gorman [mailto:[EMAIL PROTECTED]Sent: Friday, August 08, 2003 10:30 AMTo: Multiple recipients of list ORACLE-LSubject: Re: RAC interconnectsCheck out the init.ora parameter CLUSTER_INTERCONNECTS. Have never used it, but it appears to be what you're looking for...What platform?on 8/8/03 6:09 AM, Jamadagni, Rajendra at [EMAIL PROTECTED] wrote: Hi all, Is it possible to somehow tell Oracle to use all available interconnects (between nodes) for the GC traffic? We have 2 private interconnects but we see all the traffic only on one of them. The other is used only if the first one is not available.If Oracle could use both, it would balance the load too ?? Is it possible? Raj Rajendra dot Jamadagni at nospamespn dot com All Views expressed in this email are strictly personal. QOTD: Any clod can have facts, having an opinion is an art ! *This e-mail message is confidential, intended only for the named recipient(s) above and may contain information that is privileged, attorney work product or exempt from disclosure under applicable law. If you have received this message in error, or are not the named recipient(s), please immediately notify corporate MIS at (860) 766-2000 and delete this e-mail message from your computer, Thank you.*1
RE: RAC interconnects
Raj, In current versions of RAC there is no other way (other than specifying all the IPs in the Cluster_interconnects parameter) to force ALL available private networks for GC traffic. I think this 'feature' is available/planned for 10g. I have not tested that in beta. Check with Oracle support for any known issues (bugs??) for this parameters. Otherwise you can use them..! KG --- Jamadagni, Rajendra [EMAIL PROTECTED] wrote: KG, yes we see the GC traffic a lot, when there are 4 production instances on each node and that is why we were interested in finding out if we could make oracle use both interconnects. Any ideas? Raj -Original Message- Sent: Saturday, August 09, 2003 3:49 AM To: Multiple recipients of list ORACLE-L Raj: Raj: Use the cluster_interconnects parameter to specify all the IPs used for GC. But there is a catch. But sometimes a NIC failure will be seen as Node failure (though it is a very very rare case). BTW Why do you want to use both NICs for GC traffic? DO you see lots of waits for messages? KG --- Jamadagni, Rajendra [EMAIL PROTECTED] wrote: Hi all, Is it possible to somehow tell Oracle to use all available interconnects (between nodes) for the GC traffic? We have 2 private interconnects but we see all the traffic only on one of them. The other is used only if the first one is not available. If Oracle could use both, it would balance the load too ?? Is it possible? Raj Rajendra dot Jamadagni at nospamespn dot com All Views expressed in this email are strictly personal. QOTD: Any clod can have facts, having an opinion is an art ! *This e-mail message is confidential, intended only for the named recipient(s) above and may contain information that is privileged, attorney work product or exempt from disclosure under applicable law. If you have received this message in error, or are not the named recipient(s), please immediately notify corporate MIS at (860) 766-2000 and delete this e-mail message from your computer, Thank you.*1 = Have a nice day !! Best Regards, K Gopalakrishnan, Bangalore, INDIA. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: K Gopalakrishnan 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). This e-mail message is confidential, intended only for the named recipient(s) above and may contain information that is privileged, attorney work product or exempt from disclosure under applicable law. If you have received this message in error, or are not the named recipient(s), please immediately notify corporate MIS at (860) 766-2000 and delete this e-mail message from your computer, Thank you.*2 = Have a nice day !! Best Regards, K Gopalakrishnan, Bangalore, INDIA. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: K Gopalakrishnan 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: RAC interconnects
Raj: Raj: Use the cluster_interconnects parameter to specify all the IPs used for GC. But there is a catch. But sometimes a NIC failure will be seen as Node failure (though it is a very very rare case). BTW Why do you want to use both NICs for GC traffic? DO you see lots of waits for messages? KG --- Jamadagni, Rajendra [EMAIL PROTECTED] wrote: Hi all, Is it possible to somehow tell Oracle to use all available interconnects (between nodes) for the GC traffic? We have 2 private interconnects but we see all the traffic only on one of them. The other is used only if the first one is not available. If Oracle could use both, it would balance the load too ?? Is it possible? Raj Rajendra dot Jamadagni at nospamespn dot com All Views expressed in this email are strictly personal. QOTD: Any clod can have facts, having an opinion is an art ! *This e-mail message is confidential, intended only for the named recipient(s) above and may contain information that is privileged, attorney work product or exempt from disclosure under applicable law. If you have received this message in error, or are not the named recipient(s), please immediately notify corporate MIS at (860) 766-2000 and delete this e-mail message from your computer, Thank you.*1 = Have a nice day !! Best Regards, K Gopalakrishnan, Bangalore, INDIA. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: K Gopalakrishnan 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: RAC interconnects
Title: RE: RAC interconnects KG, yes we see the GC traffic a lot, when there are 4 production instances on each node and that is why we were interested in finding out if we could make oracle use both interconnects. Any ideas? Raj -Original Message- From: K Gopalakrishnan [mailto:[EMAIL PROTECTED]] Sent: Saturday, August 09, 2003 3:49 AM To: Multiple recipients of list ORACLE-L Subject: Re: RAC interconnects Raj: Raj: Use the cluster_interconnects parameter to specify all the IPs used for GC. But there is a catch. But sometimes a NIC failure will be seen as Node failure (though it is a very very rare case). BTW Why do you want to use both NICs for GC traffic? DO you see lots of waits for messages? KG --- Jamadagni, Rajendra [EMAIL PROTECTED] wrote: Hi all, Is it possible to somehow tell Oracle to use all available interconnects (between nodes) for the GC traffic? We have 2 private interconnects but we see all the traffic only on one of them. The other is used only if the first one is not available. If Oracle could use both, it would balance the load too ?? Is it possible? Raj Rajendra dot Jamadagni at nospamespn dot com All Views expressed in this email are strictly personal. QOTD: Any clod can have facts, having an opinion is an art ! *This e-mail message is confidential, intended only for the named recipient(s) above and may contain information that is privileged, attorney work product or exempt from disclosure under applicable law. If you have received this message in error, or are not the named recipient(s), please immediately notify corporate MIS at (860) 766-2000 and delete this e-mail message from your computer, Thank you.*1 = Have a nice day !! Best Regards, K Gopalakrishnan, Bangalore, INDIA. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: K Gopalakrishnan 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). This e-mail message is confidential, intended only for the named recipient(s) above and may contain information that is privileged, attorney work product or exempt from disclosure under applicable law. If you have received this message in error, or are not the named recipient(s), please immediately notify corporate MIS at (860) 766-2000 and delete this e-mail message from your computer, Thank you.*2