Ensure you dblinks are stepup properly, ie, public and private.
Ensure your jobs are ok and set to run at a specified interval (if not
what are the failures ... check the log files for explanation)
Check the alterlog to see if there is anything there with an error.
If you try to run the "Push" job manually thru sql, what do you get ?
(log on as the owner ... repadmin ??)
sql> execute dbms_job.run(jobnumber);
These tables contain the data and order to replicate. They could be empty
because, 1) the purge job ran and everything within these tables had already been sent to the destination db, 2) there is nothing being entered into the tables that are to be replicated, 3) replication has not been setup properly.
Did you setup replication thru the GUI ??? Do you see the replicated tables
in the Multimaster Replication section of the GUI ??
1. select object_name,object_type from all_objects where status <> 'VALID';
-- The above SQL is not returning anything.
2. what is CATREP.SQL ?
3. Are you running everything to create the replicated environment from the MASTER DEFINITION site ?
4. I have created replication using the book - Replication Management API Reference chapter 2
5. I have not used GUI to setup the replication? Is there any article on this?
Is there any article ...about how to solve replication problems step by step..
Ensure that you have defined anonymous public db link FROM MASTER TO MASTER
private db link (from REPADMIN) From master to master
And (replicated schema if needed)
Also check to ensure you INITxxx.ora parameters are set (use your own values)
JOB_QUEUE_INTERVAL=30 # Every 30 seconds
JOB_QUEUE_PROCESSES=4 # Number of jobs that run simultaneously
Also, for what it's worth ... I found that the following indexes and table will
extend significantly (Oracle8 ... don't worry if using local management)
alter table sys.source$ storage (next 1m);
alter INDEX sys.i_source1 storage (next 1m);
ALTER TABLE SYSTEM.DEF$_AQCALL STORAGE (NEXT 5m);
CATREP.SQL - Should be run from the sysdba priv account. It builds the Oracle internals for replication.
Once you have replication setup and gen'ed, you make a modification to a
table, you will see a row in deftran and deftrandest table. defcall will contain each row for the transaction.