I've seen a problem with CLIC interface, which are, for some reason, not used by oracle. It is a bug (Oxford is on HP-UX) and there is a specific one-off patch. This was OPS, not RAC. The symptoms are very similar: one of the processes was spinning like crazy in the kernel mode. However, RAC != OPS and I don't have any experience with RAC.
On 2003.07.11 20:24, Ravi Kulkarni wrote:
I have tested using cluster_interconnects parameter. Oradebug IPC dump shows it chooses first IP correctly, recognizes the 2nd interconnect, but with a wrong IP - 0.0.0.0. Looks like a bug.. Has anyone seen this earlier? (I understand there is a bug in HP with similar behaviour - we are on Solaris)
SSKGXPT 0x3066b00 flags info for network 0 socket no 9 IP 164.22.21.1 UDP 61635 sflags SSKGXPT_UP info for network 1 socket no 12 IP 0.0.0.0 UDP 61636 sflags SSKGXPT_UP
Is there a workaround to make Oracle choose the correct IP for the interconnect?
TIA, Ravi.
--- "Jamadagni, Rajendra" <[EMAIL PROTECTED]> wrote: > Yup, we have 2 private interconnects and one public > ... can't display the > ips though ... > > 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----- > Sent: Friday, July 11, 2003 4:19 PM > To: Multiple recipients of list ORACLE-L > > > Do you use 1 or 2 interconnects? Does your oradebug > ipc dump show both IPs? For me shows: > > SSKGXPT 0x3066b00 flags info for network 0 > socket no 9 IP 172.168.193.2 UDP 41143 > sflags SSKGXPT_UP info for network 1 > socket no 0 IP 0.0.0.0 UDP 0 > sflags SSKGXPT_DOWN > > Even 172.168.193.2 is not one of the (2) IPs we have > for interconnect. > > Thanks, > Ravi. > > --- "Jamadagni, Rajendra" > <[EMAIL PROTECTED]> wrote: > > We don't use cluster_interconnects (it is null) > ... > > but for us, the RAC is > > using the fat private interconnects without any > > problems. > > > > 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----- > > Sent: Friday, July 11, 2003 3:34 PM > > To: Multiple recipients of list ORACLE-L > > > > > > Correct. Looks like we need to configure > > CLUSTER_INTERCONNECTS parameter. Automatic > > configuration (Sun Cluster3.0/RAC) did not choose > > the > > (correct) IP(s) for interconnect. KG noticed it. I > > have sent netstat -ai, oradebug IPC dump, ping -s > > info > > to him. If you are interested, I can paste it > here. > > > > -Thanks, > > Ravi. > > > > ********************************************************************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 > > > > > __________________________________ > Do you Yahoo!? > SBC Yahoo! DSL - Now only $29.95 per month! > http://sbc.yahoo.com > -- > Please see the official ORACLE-L FAQ: > http://www.orafaq.net > -- > Author: Ravi Kulkarni > 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 >
__________________________________ Do you Yahoo!? SBC Yahoo! DSL - Now only $29.95 per month! http://sbc.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Ravi Kulkarni 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).
-- Mladen Gogala Oracle DBA -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Mladen Gogala 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).