Re: RAC system Calls

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"
> <Rajendra.Jamadagni_at_espn.com> 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"
> > <Rajendra.Jamadagni_at_espn.com> 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: nandagokul_at_yahoo.com
> >
> > 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: ListGuru_at_fatcity.com (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: nandagokul_at_yahoo.com
>
> 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: ListGuru_at_fatcity.com (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: mgogala_at_adelphia.net

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: ListGuru_at_fatcity.com (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).