Skip to content

How to change replication object IP#

Overview#

This is a procedure guide for changing the registered IP to another IP when creating a replication object.

Procedure#

1. Stop the replication object to be changed#

ALTER REPLICATION replication_name STOP;

2. Add new IP#

ALTER REPLICATION replication_name ADD HOST 'new_ip_address', replication_port;

3. Remove existing IP#

ALTER REPLICATION replication_name DROP HOST 'old_ip_address', replication_port;

4. Start the replication object#

ALTER REPLICATION replication_name START;

5. Check the host information of the replication object#

SELECT REPLICATION_NAME, HOST_IP, PORT_NO FROM SYSTEM_.SYS_REPL_HOSTS_ ORDER BY HOST_NO;