Virtual IP in Oracle RAC cluster.

[Wivo]

HI,

In SGeRAC cluster where the virtual IPs are configuring? I checked in the pkg control file where we configure cluster ip in normal SG cluster. But it is not there. Is it assigned from  Oracle side?? How we can find out the configured virtual IP from OS side?

Thanks

Wivo

[Duncan Edmonstone]

It is assigned on the Oracle side. You use Oracle commands to get/set these values. Try looking at the "olsnodes -i" and "oifcfg getif" commands

[Wivo]

Hi Duncan,

Thanks for reply.

# ./olsnodes -i
node1  node1-vip
node2  node2-vip
# ./oifcfg getif
lan902  192.168.3.0  global  cluster_interconnect
lan900  10.x.y.0  global  public

And  ifconfig lan900 gives the physical ip of node1. So where is  the virtual ip configured.? Does it map to the lan900  NIC itself?

In  /etc/hosts file the entry for vip is,

10.x.y.87   node1-vip
10.x.y.88   node2-vip

And physical ip entry is

 10.x.y.85   pfepdb1
10.x.y.86   pfepdb2

Except /etc/hosts file I couldn't find any entry for these virtual ips.

Though it is configured on Oracle side is there any  command to find the exact entry of  of virtual ip.

Thanks

Wivo

[Wivo]

Please  read  as follows in previous entry

And physical ip entry is

 10.x.y.85   node1
10.x.y.86    node2

[Duncan Edmonstone]

>> Though it is configured on Oracle side is there any  command to find the exact entry of  of virtual ip.

Doesn't "netstat -in" show you those IP addresses bound to lan900 somewhere? (maybe lan900:1 ?)

[Wivo]

Hi ,

Thanks for your reply.

 One more querry on this;  does system admin have any role to assign virtual ip in RAC..?

Thanks

Wivo