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;