Re: Oracle Replication Problems

This is usually a problem with parallel propagation, when you suspend replication it will attempt to push the deferred queue and for some reason the deferred scn's have become out of sync between the sites. You could try changing the propagation to serial, I think I saw a bug on MetaLink (www.support.oracle.com) like this, otherwise Oracle Support should be able to talk you through reseting the underlying def$_ tables.

Regards
David Russell

gplagge_at_my-dejanews.com wrote in message <6p8m5q$3tt$1_at_nnrp1.dejanews.com>...
>Hi,
>We are setting up Multi-master replication using Oracle 8.0.4.1.3 and NT
4.0.
>
>I am encountering 2 problems:
>When trying to quiesce replication, I get an error message:
>ORA-23388 replication parallel push watermark error
>
>The error message book says the recommended action is to call Oracle
>Tech Support, which I did. No help there yet.
>
>Also, one of the sql files in rdbms80\admin seems to have an error in it,
>resulting in one of the replication packages being marked invalid.
>The file is: prvtdfri.plb
>When I execute the file I get errors such as:
>2* :2 1 9 20 2b :3 1
>unknown command beginning ":3 0 1 :4 ..." - rest of line ignored. unknown
>command beginning ":3 0 3 0 3..." - rest of line ignored.
>3* 3 7 8 c 10 14 17
>2* :2 1 9 20 2b :3 1
>
>and other similar errors.
>
>Any ideas on either of these problems?
>Can anyone email me a copy of prvtdfri.plb?
>
>Thanks!
>
>Gene Plagge,
>Manager, I.S. Database Services
>WorldxChange, Inc.
>Phone +61 2 9937 9990
>Email: gplagge_at_hotmail.com
>
>-----== Posted via Deja News, The Leader in Internet Discussion ==-----
>http://www.dejanews.com/rg_mkgrp.xp Create Your Own Free Member Forum
Received on Sun Jul 26 1998 - 11:54:40 CDT