Oninit cdi / Archive
Talk to an expert →

Help on ER ; remote/cyclic synchronization

Posted in 2009

Topics: High Availability & Replication, Server Administration, Networking & sqlhosts Configuration

JEAN-MICHEL RAMSEYER — — source: IIUG Forums & Mailing Lists

Hello all, I'm trying to set ER between 2 servers on different geographic sites, but both running IDS 11.5 xC3. So here is the sqlhost content on the root server : group1 group - - i=2000 instance1 onsoctcp LAN_IP 9088 g=group1 group2 group - - i=2001 instance2 onsoctcp WAN_IP 9088 g=group2 And here the sqlhost content on the leaf server group1 group - - i=2000 instance1 onsoctcp WAN_IP 9088 g=group1 group2 group - - i=2001 instance2 onsoctcp LAN_IP 9088 g=group2 I've checked I was abble to connect on each instance from the other server by using dbaccess. I've set everything needed for cdr spaces in the onconfig and restart my instance. Then on the root server I have no problem when I do : cdr define server -I group1 But when I : cdr define server -L -S group1 -I group2 I get the following error : command failed -- remote/cyclic synchronization not allowed (64) So how can I solve this? Thank you for your help

↪ replying to JEAN-MICHEL RAMSEYER
Madison Pruet — — source: IIUG Forums & Mailing Lists

Try cdr define server -c group2 -L -S group1 -I group2 You must be connected to the server that you are defining when issueing= "cdr define server" = "JEAN-MICHEL = RAMSEYER" = <jm.ramseyer@gree = To nivory.com> ids@iiug.org = Sent by: = cc ids-bounces@iiug. = org Subj= ect Help on ER ; remote/cyclic = synchronization [15988] = 06/10/2009 03:39 = AM = = = Please respond to = ids@iiug.org = = = Hello all, I'm trying to set ER between 2 servers on different geographic sites, b= ut both running IDS 11.5 xC3. So here is the sqlhost content on the root server : group1 group - - i=3D2000 instance1 onsoctcp LAN_IP 9088 g=3Dgroup1 group2 group - - i=3D2001 instance2 onsoctcp WAN_IP 9088 g=3Dgroup2 And here the sqlhost content on the leaf server group1 group - - i=3D2000 instance1 onsoctcp WAN_IP 9088 g=3Dgroup1 group2 group - - i=3D2001 instance2 onsoctcp LAN_IP 9088 g=3Dgroup2 I've checked I was abble to connect on each instance from the other ser= ver by using dbaccess. I've set everything needed for cdr spaces in the onconfig and restart m= y instance. Then on the root server I have no problem when I do : cdr define server -I group1 But when I : cdr define server -L -S group1 -I group2 I get the following error : command failed -- remote/cyclic synchronization not allowed (64) So how can I solve this? Thank you for your help ***********************************************************************= ******** Forum Note: Use "Reply" to post a response in the discussion forum. =

Glossary