Re: Personal Oracle replication - HELP

I have job_queue_processes set to 10 and snapshot_refresh_processes , too. ( I set job_queue_interval and snapshot_refresh_interval , too). But situation is still the same.System is quiesced even if I execute resume_master_activity several times.
In DBA_JOBS is rows with column what :
dbms_repcat.do_deferred_repcat_admin('schema',false) ( why false not true ?? )
this job is executing from time to time :) ( it appeared in dba_jobs_running) but system is still quiesced. when I execute do_deferred_repcat_admin('schema',true) nothing has changed.
Maybe I have configured my db_links not correctly, maybe between my databases is no suitable communication ? When I execute again resume_master_activity system is hanging.In view DBA_ADMINDEFTRAN is one row with values : DST_LNK db-link.world and BROKEN Job Not Found.In DBA_REPSCHEMA are two rows ( two masters) with column DB_LINK ORACLE_WORLD AND DB-LINK.WORLD. Is this correctly ? I suppose that something is wrong with communication configuration because in DB_REPCATLOG if MASTER is ORACLE.WORLD ( local , I mean ) then job STATUS is READY but if MASTER is db-link.WORLD ( remote master) then job status is AWAIT_CALLBACK. And at the end : when I execute drop_master_repschema en error has occured ORA-23353 deferred RPC queue has entries for replicated schema 'schema'
and when I execute delete system.repcat$_repcatlog : ORA-00060 deadlock detected while waiting for resource. So, what is wrong ? I have global_names set to false, is it correct ? Where I should look for errors ?

              Krzysztof    Wrona
                               kszysiec_at_mamut.isi.wat.waw.pl
                              kszysiec_at_polbox.com

On Sun, 29 Mar 1998 21:39:41 +0200, Olivier Bercovitz <oberco_at_club-internet.fr> wrote:

>Hello Krzysztof,
>
>Have you verified that you have jobs in dba_jobs and/or dba_jobs_running ?
>
>And so have you enable the snp processes (ora_snp0, ora_snp1...)
>by setting snapshot_refresh_processes in initSID.ora (and
>snapshot_refresh_interval also).
>Effectively when you work with the masterdef site, this one create a job
>to do administrative operations like
>resume, add database and so lot.
>So if you have not at least one snp process, the job is not executed.
>So to activate snp process, shutdown the db, modifiy your init.ora an
>startup your db
>
>Hope this help you.
>
>Regards. Olivier
>
Received on Wed Apr 01 1998 - 00:00:00 CST