RE: RAC interconnects

2003-08-14 Thread Mladen Gogala
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

2003-08-14 Thread Tim Gorman
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

2003-08-14 Thread Jamadagni, Rajendra
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

2003-08-14 Thread K Gopalakrishnan
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

2003-08-14 Thread K Gopalakrishnan
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

2003-08-14 Thread Jamadagni, Rajendra
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