- Public IP: The public IP address is for the server. This is the same as any server IP address, a unique address with exists in /etc/hosts.
- Virtual IP: Oracle uses a Virtual IP (VIP) for database access. The VIP must be on the same subnet as the public IP address. The VIP is used for RAC failover (TAF).
- Scan IP: provides a single name for clients to access Oracle Databases running in a cluster. The benefit is that the client’s connect information does not need to change if you add or remove nodes in the cluster.
Public IP Address: This is general IP address in a network, where the RAC node and non-RAC node can communicate with each other.
Virtual IP Address: Using virtual IP we can save our TCP/IP timeout problem because Oracle notification service maintains communication between each nodes and listeners. Once ONS found any listener down or node down, it will notify another nodes and listeners with same situation. While new connection is trying to establish connection to failure node or listener, virtual IP of failure node automatically divert to surviving node and session will be establishing in another surviving node. This process doesn't wait for TCP/IP timeout event. Due to this new connection gets faster session establishment to another surviving nodes/listener.
Scan IP address: It is an separate DNS server which resolves another 3 IP address. IT is very useful for scalability. Its a new feature in Oracle 11g. Before 11g if we add/delete new node from a cluster, all client's tns entry should be modified to make itself aware of node addition/deletion. But since this Scan IP listener is aware of all nodes addition/deletion information within the cluster, there is no need to modify anything at client's end.
Hope this helps.