Re: Oracle RAC VIP networking question

On Aug 8, 12:04 am, keith..._at_comcast.net wrote:
> Unfortunatley - I'm a networking person trying to assist our UNIX/DBA
> team. But, yes, I agree with your understanding of Network Bonding.
> It bonds 2 or more NIC's together to aggregate bandwidth which should
> have nothing to do with VIP's on multiple subnets.
>
> The bottom line is, we have a 3 node cluster. Each node has a public,
> private and (what we call) an isolated batch subnet NIC (3 NIC's total
> per node). Our Application vendor indicates that it is "strongly"
> encouraged to have this isolated network (where bulk batch processing
> takes place) and not compete with the public NIC where the clients
> access the application. In total, this is 3 seperate IP subnets per
> node. Our Unix/DBA's need to have multiple VIP's to service
> the applications that need to use the public and isolated batch
> subnet. One VIP to listen on the the client side for the actual
> application. And another VIP that will listen on a totally different
> subnet (the isolated batch network) that of course has it's own NIC.
> So, our concern is from what we have heard so far is that it appears
> the VIP per node that any application can use is only available on the
> "public" facing NIC

It's a pretty common situation, e.g. separate networks are often used for backups and admin purposes. You are right, out of the box RAC gives one VIP per node. You have to take care about additional VIP's yourself. Until 10gR2 you would create them using vendor clusterware. Cristian showed you how to create VIP with Oracle clusterware in 10gR2. If you go this way, test it well. It didn't work terribly well for me on Solaris 10 - VIP kept fail over.

Regards,
Igor

> Thanks
> Keith
Received on Tue Aug 07 2007 - 19:50:35 CDT