Change Target IP without downtime on Source (4264980)

When the IP Address on the target needs to changed for Business Needs without a downtime.

Shareplex uses this IP address in messages for routing purpose .

Procedure:

1) Stop export on all source boxes
2) Shutdown shareplex sp_cop on target, change ip address on target, update /etc/hosts file on both source and target to reflect the new target ip
3) Set SP_XPT_ALTERNATE_HOST on all source servers to the new target ip address.

If you have multiple targets on the source with named export queues for each target. You use the command below to set the SP_XPT_ALTERNATE_HOST for the specific target export queue where the IP change is going to occur.

sp_ctrl>set param SP_XPT_ALTERNATE_HOST queue <queuename><target new hostname>

To verify that it is set for just that queue run <list param all export> and check.

4)Copy the current config file and Edit that Config file to create a new export queue with the new target IP.

5) Activate config on all source servers, it should generate a new export process since target ip now changed.
6) Start export for the Old export queue(sp_ctrl>start export queue <queuename> let all messages drain.
7) Check to verify the post new object cache is on target . Post stops due to the following error :

Internal error: 15010 - Error reading pre-sync'd objcache for datasource 0x0a0a30a5+PP+test+sp_opst+o.ccstge-o.ccstgw
Move the existing objcache file to the file name post is looking for ( 0x0a0a30a5+PP+test+sp_opst+o.ccstge-o.ccstgw-objcache_sp_opst.88).You can get this from Event log.

8)Unset the SP_XPT_ALTERNATE_HOST parameter (sp_ctrl>reset param SP_XPT_ALTERNATE_HOST queue <queuename>)
9)Then start the export for the new queue.
10) All messages should now go to target using the new target ip, check to verify the post new object cache is on target. That means all old messages related to old target ip are now posted.
11) Shutdown shareplex sp_cop on all source boxes and delete the old export queue and post queue related to old target ip.

To Delete Queues :

b)ON SOURCE
Shareplex must be shutdown
1../qview
qview> qsetup <port#>
qview> list --this will show all queues on the source box
qview> deleteq X -delete the old export queue

qview> exit

c)ON TARGET

Shareplex must be shutdown
./qview
qview> qsetup <port#>
qview> list
qview> deleteq P (delete the old post queue)
qview> exit
d)ON TARGET
./sqlplus splex_user/splex_pwd
truncate shareplex_trans