About VIP,SCAN IP ,HAIP

VIP：

Virtual IP address

 An IP address not statically linked to just one node or interface.

 Provides a mechanism for faster failovers.

 Each node must have one Virtual IP address.

 All primary VIPs of a cluster must be in the same subnet.

SCAN IP:

1. It is a better practice to have three SCAN IP addresses and three scan listeners to

provide fault tolerance.

2. These three SCAN IP addresses can be alive in any node of the cluster. If you have

more than three nodes in a cluster, then nodes joining initially to the cluster will

have SCAN resources running.Three SCAN IP addresses and three SCAN listeners, at most.

3. SCAN is an abstraction layer. In a huge cluster, client connect string do not need to

specify all nodes in a cluster. Even if the topology of the cluster changes, still, there

is no reason to change connect string.

4. SCAN and VIP addresses must be in the same subnet. Multiple subnets can be

created using listener_networks, but redirection is not contained within the same

subnet.

HAIP：          

High Availability IP address for private interconnect traffic.

 OS based solution: Bonding, Trunking etc

 HAIP Oracle based solution.

 Both clusterware and database uses HAIP plumbed IP address

for private interconnect traffic.

-------->>>整理自By Riyaj Shamsudeen. Blog: orainternals.wordpress.com

SQL> show parameter listener

NAME                                 TYPE        VALUE

------------------------------------ ----------- ------------------------------

listener_networks                    string

local_listener                       string      (DESCRIPTION=(ADDRESS_LIST=(AD

                                                 DRESS=(PROTOCOL=TCP)(HOST=192.

                                                 168.56.172)(PORT=1521))))

remote_listener                      string      elvis-cluster-scan:1521

[grid@elvis1 bin]$ oifcfg getif

eth0  192.168.56.0  global  public

eth1  172.168.1.0  global  cluster_interconnect

[grid@elvis1 bin]$ olsnodes -p -l

elvis1  172.168.1.191

[oracle@elvis1 ~]$ sqlplus / as sysdba

SQL*Plus: Release 11.2.0.3.0 Production on Mon Sep 17 16:05:03 2012

Copyright (c) 1982, 2011, Oracle.  All rights reserved.

Connected to:

Oracle Database 11g Enterprise Edition Release 11.2.0.3.0 - 64bit Production

With the Partitioning, Real Application Clusters, Automatic Storage Management, OLAP,

Data Mining and Real Application Testing options

SQL> select * from gv$cluster_interconnects;

   INST_ID NAME            IP_ADDRESS       IS_ SOURCE

---------- --------------- ---------------- --- -------------------------------

         1 eth1:1          169.254.254.78   NO