Oraclue

Oracle internals, debugging and undocumented features

Issue with Oracle 11.2.0.2 new Redundant Interconnect

MOS note  11.2.0.2 Patch Set – List of Bug Fixes by Problem Type [ID 1179583.1]

If you look for patch 9974223  you can see that patch is there:

under Undocumented Oracle Server

9969284 9969539 9971646 9972586 9973072 9973560 9974223 9974736 9975343 9975837

but  Bug 9974223 :

Oracle Grid Infrastructure for a cluster needs multicast communication on 230.0.1.0 addresses
working properly between the cluster nodes.

“When first attempting to start an 11.2.0.2 cluster node, either during a fresh install or after an
upgrade attempt, it is possible that the node will be unable to join the cluster.
The Oracle Cluster Synchronization Services (OCSSD) will report a failure to join the
existing cluster members.This will be noted as an inability for the CSS to connect to the other active members of the cluster.
The problem occurs because the clusterware in 11.2.0.2 uses multicast messages to initiate communications on the 230.0.1.0 address.
If multicast on these addresses is not enabled for the private interfaces, then the clusterware will be unable to connect to it’s peer nodes.”

still exists.

When I run mcast1 program ( MOS note 1212703.1 )on my nodes using 230.0.1.0 address it never locates new peer..

but when I use 224.0.0.251 it works..

Here is what Oracle says:Note ID 1054902.1

For 11.2.0.2 and above, private network, without patch 9974223, multicast address 230.0.1.0 should work; with the patch,
another multicast address 224.0.0.251 is supported. See Multicast section to verify.

Guess what.There is no patch 9974223 and multicast does not work for 230.0.1.0 address.

One of the solution I have found on internet

(if you are using Cisco switches) is to configure no ip igmp snooping on the switch.

http://juliandyke.wordpress.com/2010/10/06/oracle-11-2-0-2-requires-multicasting-on-the-interconnect/

And answer from MOS:

Oracle released Patch 9974223.It is available to download.

Advertisements

3 responses to “Issue with Oracle 11.2.0.2 new Redundant Interconnect

  1. oraclue November 2, 2010 at 10:17 am

    Hi Martiin,

    I am working with my Network folks to enable port 230.0.0.1 .. 224 is default..

    So probably some Cisco switch configuration.

    Did you get estimate for patch? How long before they released it?

    Thanks,

    Miladin

  2. oraclue November 2, 2010 at 10:42 am

    Just got this from Oracle:

    Patch is in the test phase, so I believe it will be released soon

    Miladin

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s

%d bloggers like this: