Questions about replication

[Laurent Boutet]

Hi ! (forgive my french accent ;-))))
I need your help :
- How can I make conflict management rules for replication in console mode
????

- the following sample :
on the first Oracle server :
BEGIN
DBMS_DEFER_SYS.SCHEDULE_PUSH(
destination => 'BASE_1',
interval => sysdate+1/(60*24),
next_date => sysdate,
stop_on_error => false,
delay_seconds =>0,
parallelism =>0);
END ;

The lines above are ok (i mean accepted by my first server).
On my second server, i have also the same lines :
BEGIN
DBMS_DEFER_SYS.SCHEDULE_PUSH(
destination => 'BASE_2',
interval => sysdate+1/(60*24),
next_date => sysdate,
stop_on_error => false,
delay_seconds =>0,
parallelism =>0);
END ;

It is also ok.

The problem is that the replication is not automatic (but the above lines
should automate that).
I launch replication manually...so the first replication is ok...and
then...no more replication.....what is wrong with my configuration ?

Thanks in advance,
Laurent.

[Van Messner]

Question 1. The replication documentation has a full description of the
conflict management methods that come from Oracle, and a description of how
you can define your own. BUT ... you will be a thousand times better off if
you design your system to avoid conflicts rather than try to manage them.
Unless your system is very cut and dried with a small standard set of
operations, sooner or later you'll regret conflict management.

Question 2. Maybe I don't understand what you're asking but there's a lot
more to setting up multimaster replication than just scheduling the push
jobs. Once again there's an excellent description in Oracle's replication
docs.

Van


"Laurent Boutet" <laurent.boutet@clinsight.fr> wrote in message
news:biut81$pkt$1@reader1.imaginet.fr... Hi ! (forgive my french accent ;-)))) I need your help : - How can I make conflict management rules for replication in console mode ???? - the following sample : on the first Oracle server : BEGIN DBMS_DEFER_SYS.SCHEDULE_PUSH( destination => 'BASE_1', interval => sysdate+1/(60*24), next_date => sysdate, stop_on_error => false, delay_seconds =>0, parallelism =>0); END ; The lines above are ok (i mean accepted by my first server). On my second server, i have also the same lines : BEGIN DBMS_DEFER_SYS.SCHEDULE_PUSH( destination => 'BASE_2', interval => sysdate+1/(60*24), next_date => sysdate, stop_on_error => false, delay_seconds =>0, parallelism =>0); END ; It is also ok. The problem is that the replication is not automatic (but the above lines should automate that). I launch replication manually...so the first replication is ok...and then...no more replication.....what is wrong with my configuration ? Thanks in advance, Laurent.

[Laurent Boutet]

Thank you very much for your answers.
For question 2, my pb is that the replication does not start automatically,
though it is configured to start every 1 minutes...
So the first replication works fine...and then, i mean the others 1 minutes,
nothing...

I hope you'll understand the pb...

Thanks in advance,
Laurent


"Van Messner" <vmessner@bestweb.net> a écrit dans le message de
news:vl7jkbb228du95@corp.supernews.com... Question 1. The replication documentation has a full description of the conflict management methods that come from Oracle, and a description of
how you can define your own. BUT ... you will be a thousand times better off
if you design your system to avoid conflicts rather than try to manage them. Unless your system is very cut and dried with a small standard set of operations, sooner or later you'll regret conflict management. Question 2. Maybe I don't understand what you're asking but there's a lot more to setting up multimaster replication than just scheduling the push jobs. Once again there's an excellent description in Oracle's replication docs. Van "Laurent Boutet" <laurent.boutet@clinsight.fr> wrote in message news:biut81$pkt$1@reader1.imaginet.fr... Hi ! (forgive my french accent ;-)))) I need your help : - How can I make conflict management rules for replication in console
mode ???? - the following sample : on the first Oracle server : BEGIN DBMS_DEFER_SYS.SCHEDULE_PUSH( destination => 'BASE_1', interval => sysdate+1/(60*24), next_date => sysdate, stop_on_error => false, delay_seconds =>0, parallelism =>0); END ; The lines above are ok (i mean accepted by my first server). On my second server, i have also the same lines : BEGIN DBMS_DEFER_SYS.SCHEDULE_PUSH( destination => 'BASE_2', interval => sysdate+1/(60*24), next_date => sysdate, stop_on_error => false, delay_seconds =>0, parallelism =>0); END ; It is also ok. The problem is that the replication is not automatic (but the above
lines should automate that). I launch replication manually...so the first replication is ok...and then...no more replication.....what is wrong with my configuration ? Thanks in advance, Laurent.

[Sybrand Bakker]

On Tue, 2 Sep 2003 09:14:10 +0200, "Laurent Boutet"
<laurent.boutet@clinsight.fr> wrote:
Thank you very much for your answers.For question 2, my pb is that the replication does not start automatically,though it is configured to start every 1 minutes...

Which is just utterly ridiculous as the job mechanism will be
incapable to keep up.
Check dba_jobs and you will see your replication jobs have failed.


Sybrand Bakker, Senior Oracle DBA

To reply remove -verwijderdit from my e-mail address