Shulou(Shulou.com)05/31 Report--

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.

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.