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