Re: Personal Oracle replication - HELP

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

Kszysiec wrote:

> I have some Oracle replication question:
 

> 6 When I add master database procedure has finished OK but repschema at
> this site
> ( masterdef site) has status Quiesced and I cannot change as worker
> table exmpltbl ( system is quiesced )
> 7 As repadmin at second site ( master site) check view repcat and
 

> repschema - repschema has status Normal. When I execute at this site
> resume_master_activity - an error has occured : connection description
> for remote database not found.
> 8 At masterdef site in view repcatlog I found 7 rows with status
> await_callback.
> 9 At master site as worker I can use replicated table exmpltbl but it
> is empty - when I add rows and execute dbms_defer_sys.execute at
> changes is not propagated.
> 10 What is wrong ? Why an example not work correctly ? Can anyone help
> me ?
> Krzysztof Wrona
> kszysiec_at_mamut.isi.wat.waw.pl
> kszysiec_at_polbox.com
Received on Sun Mar 29 1998 - 00:00:00 CST