Export can not connect to import and gets below error in event_log:
Error 2017-06-20 14:41:56.811923 43600 2345564000 Cop: [SP-SYS01005] Request to start import failed; hostid collision detected. <CAUSE> The hostid of the source and the target is the same; SharePlex requires that each hostid is unique. <ADVICE> Change the hostid of either the source or the target and re-activate. See 'http://advice.shareplex.com/SP-SYS01005' for additional advice and support. [module cop]
SOLUTION:
Hostid under var dir/data is generated by SharePlex for each host based on ipv4 address and it is supposed to be unique among servers involved in replication.
Sometimes with VM image or in cloud environment, SharePlex may generate same hostid if the internal ip addresses are the same.
1. Shutdown sp_cop on both servers.
2. run ora_cleansp or other appropriate cleansp program for open target on each server.
3. Go to one of the server and change the contents under var dir/data/hostid to a different hex value which is not the same as the other server.
example:
hostid has 0x0a011642
change it to 0x0a011643
4. Restart sp_cop on both source and target and activate config.
© ALL RIGHTS RESERVED. Termini di utilizzo Privacy Cookie Preference Center