Differences between vip/public/private IP addresses in Oracle RAC

Source: Internet
Author: User
Tags failover

In the Oracle RAC environment, each node has multiple IP addresses: Public, Private, and Vip. What is the difference between these three IP addresses? Which occasions are used separately? Let's take a look at the answers from foreigners.
1. private IP address is used only for internal clustering processing (Cache Fusion)
Private IP addresses are used for heartbeat synchronization, which can be ignored directly at the user level. This Ip address is used to ensure the private IP addresses used for data synchronization between the two servers.
2. VIP is used by database applications to enable fail over when one cluster node fails
The virtual IP address is used for client applications to support failover. In other words, one instance is suspended and the other instance is automatically taken over. The client does not feel any way.
This is one of the reasons for using RAC, and I think it is Server Load balancer.
3. public IP adress is the normal IP address typically used by DBA and SA to manage storage, system and database.
Public IP addresses are generally used by administrators to ensure that they can operate on the right machine. I prefer to call them real IP addresses.

Through the above explanation, it is hard to understand that, as a DBA, When configuring tnsnames. ora, vip is used in some cases, while public IP must be used in some cases.For example, when you locate a database deadlock and use a public ip address, you can ensure that you are connected to the machine you want to handle. On the contrary, when using a virtual ip address, there will be uncertainty, because Server Load balancer is enabled by default, that is, if you want to connect to server A, the system allocates server B to you.

For example:

    The following example shows how to use the VIP

  1. Infodb8=
  2. (DESCRIPTION=
  3. (ADDRESS= (PROTOCOL=TCP)(HOST= 138.*.1.81)(PORT=1521))
  4. (ADDRESS= (PROTOCOL=TCP)(HOST= 138.*.1.82)(PORT=1521))
  5. (LOAD_BALANCE=Yes)
  6. (FAILOVER=ON)
  7. (CONNECT_DATA=
  8. (SERVER=DEDICATED)
  9. (SERVICE_NAME=Infodb)
  10. (FAILOVER_MODE=
  11. (TYPE= SELECT)
  12. (METHOD=BASIC)
  13. (RETRIES=30)
  14. (DELAY=5)
  15. )
  16. ))

  1. In the following example, the Public IP address is used to specify the connection HOST 1. Note that the red font infodb1 further limits the connection instance.
  2. INFODB83=
  3. (DESCRIPTION=
  4. (ADDRESS_LIST=
  5. (ADDRESS= (PROTOCOL=TCP)(HOST= 138.*.1.83)(PORT=1521))
  6. )
  7. (CONNECT_DATA=
  8. (SERVICE_NAME= Infodb)
  9. (INSTANCE_NAME= Infodb1)
  10. )
  11. (HS=OK)
  12. )
  • 1
  • 2
  • Next Page

Related Article

Contact Us

The content source of this page is from Internet, which doesn't represent Alibaba Cloud's opinion; products and services mentioned on that page don't have any relationship with Alibaba Cloud. If the content of the page makes you feel confusing, please write us an email, we will handle the problem within 5 days after receiving your email.

If you find any instances of plagiarism from the community, please send an email to: info-contact@alibabacloud.com and provide relevant evidence. A staff member will contact you within 5 working days.

A Free Trial That Lets You Build Big!

Start building with 50+ products and up to 12 months usage for Elastic Compute Service

  • Sales Support

    1 on 1 presale consultation

  • After-Sales Support

    24/7 Technical Support 6 Free Tickets per Quarter Faster Response

  • Alibaba Cloud offers highly flexible support services tailored to meet your exact needs.