Get the App
SLTechnology News&Howtos  ›  Database  › 

What is the virtual IP in single instance DG handover?

Shulou Source: shulou.com Published: 2022-05-31 12:55:36 10月04日 Update

This article will explain in detail what the virtual IP is like in the switching of single-instance DG. The content of the article is of high quality, so the editor will share it with you for reference. I hope you will have a certain understanding of the relevant knowledge after reading this article.

When switching between DG master and slave, there are several methods to make the application connect to DG database normally without modifying the connection configuration.

First, the application connects to the host name, which can be adjusted by domain name resolution.

Second, the application connects the host to IP by setting VIP (manual configuration or cluster tools such as f5)

Third, the application connects the host to IP and modifies the host IP directly.

Make the DG master / slave switch transparent to the application by manually configuring VIP. The following is the configuration process:

1. Primary configure vip

Ifconfig eth2:0 192.168.206.95 netmask 255.255.255.128 # configure vip

Ifconfig eth2:0 down # Unconfigure

two。 Modify listener.ora

LISTENER =

(DESCRIPTION_LIST =

(DESCRIPTION =

(ADDRESS = (PROTOCOL = TCP) (HOST = 192.168.206.95) (PORT = 1521))

(ADDRESS = (PROTOCOL = TCP) (HOST = 192.168.206.61) (PORT = 1521))

(ADDRESS = (PROTOCOL = IPC) (KEY = EXTPROC1521))

)

)

3. Restart monitoring

Lsnrctl stop

Lsnrctl start

4. Switchover (abbreviated)

After the switch, the role exchange between primary and standby is completed.

5. Manually configure vip

a. Cancel the vip of the original primary

Ifconfig eth2:0 down # Unconfigure

Lsnrctl stop 、 lsnrctl start

b. Original Standby configuration vip

Repeat steps 1-3. Handover complete

This is how to share the virtual IP in the switching of single instance DG. I hope the above content can be helpful to you and learn more knowledge. If you think the article is good, you can share it for more people to see.

Tags: Configuration switching host application manual instance content article more knowledge article yes domain name tool form situation data database method Apple Docker Huawei Linux macOS MariaDB Microsoft MySQL NVidia OPPO Reno OPPO Reno MySQL vpn Redmi Microsoft