Oracle FAQ Your Portal to the Oracle Knowledge Grid

Home -> Community -> Mailing Lists -> Oracle-L -> ** advanced replication :: not propagating

** advanced replication :: not propagating

From: A Joshi <>
Date: Thu, 18 Dec 2003 12:29:26 -0800
Message-ID: <>

  I newly setup master to master replication : I followed the steps. It is 9i so no need to run catrep  :
1) Create replication administrator repadmin
 2) Grant privileges and register repadmin as propagator and receiver
3) Create public database links, private database link in repadmin.
4) Create master groups, add objects and generate support. 
5) Add master sites.
6) Schedule push and purge jobs.
7) Resume master activity
The arrangement is primary --> secondary. I have made the push and purge jobs at secondary as broken.
After that I made updates to the replicated tables and I can see the entry in deftran. The push job executes at primary but transactions are not being propagated to secondary. I ran the job manually. It does not give any error but does not propagate. I can still see the entries in deftrandest.
The links are working fine. Maybe I missed a step but cannot figure out.
When I give the command to quisce replication that is SUSPEND_MASTER_ACTIVITY, then it propagates and applies the change to the other site. Which is strange of course. I tried this couple of times just to make sure that is the case. Maybe quisce does some operation and it leads to it and maybe there is a clue there but I cannot find.
Can someone help? Thank You.

Do you Yahoo!?
Protect your identity with Yahoo! Mail AddressGuard
Please see the official ORACLE-L FAQ:
Author: A Joshi

Fat City Network Services    -- 858-538-5051
San Diego, California        -- Mailing list and web hosting services
To REMOVE yourself from this mailing list, send an E-Mail message
to: (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).
Received on Thu Dec 18 2003 - 14:29:26 CST

Original text of this message