Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: Multi-master replication in 9i - updates aren't automatically propagating--HELP!

Re: Multi-master replication in 9i - updates aren't automatically propagating--HELP!

From: Van Messner <vmessner_at_bestweb.net>
Date: Sat, 23 Nov 2002 17:37:21 -0500
Message-ID: <uu00q0btei4l8b@corp.supernews.com>


Every five seconds is asking for trouble (once you get your interval straightened out). If your master sites are more than two feet apart you're setting yourself up for conflicts.

"Jamie" <jamie.tinker_at_transcore.com> wrote in message news:44a974b5.0211220721.4d21a31e_at_posting.google.com...
> I am attempting to set up a replicated environment in Oracle 9i. I
> have all the replication set up properly (I think), yet when I make an
> update to a replicated table, the update doesn't automatically
> propagate. I can see the transaction in the replication
> administration deferred queue, and if I manually push the transaction
> it works, but it doesn't automatically send the transaction across. I
> have a schedule set up to push every 5 seconds (sysdate + 5/(60*60*24)
> ). I don't know what is going on. Why won't it use the schedule to
> push the transactions? Has anyone ran into this problem??
>
> Any ideas would be GREATLY appreciated.
>
> Thanks,
> Jamie Tinker
Received on Sat Nov 23 2002 - 16:37:21 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US