Replication Error -ORA-23394: duplicate propagator

From: Oracle DBA <sami_resume_at_yahoo.com>
Date: Mon, 13 Oct 2003 09:29:25 -0800
Message-ID: <F001.005D2F2D.20031013092925@fatcity.com>

Hi List,

I am getting ORA-23394: duplicate propagator, but when I execute DBMS_DEFER_SYS.UNREGISTER_PROPAGATOR, it says
ORA-23357: the propagator does not exist.

How do i resolve this issue? Anyhelp would be really greatful.

Kindly see below

---

SQL> connect system/manager_at_DB1
Connected.

SQL> BEGIN
  2 DBMS_DEFER_SYS.REGISTER_PROPAGATOR (   3 username => 'repadmin');
  4 END;
  5 /
BEGIN
*

ERROR at line 1:

ORA-23394: duplicate propagator
ORA-06512: at "SYS.DBMS_SYS_ERROR", line 79
ORA-06512: at "SYSTEM.DEF$_PROPAGATOR_TRIG", line 9
ORA-04088: error during execution of trigger
'SYSTEM.DEF$_PROPAGATOR_TRIG'
ORA-06512: at "SYS.DBMS_DEFER_INTERNAL_SYS", line 1572

ORA-06512: at "SYS.DBMS_DEFER_SYS", line 2460 ORA-06512: at line 2

SQL> BEGIN
  2 DBMS_DEFER_SYS.UNREGISTER_PROPAGATOR (   3 username=> 'repadmin');
  4 END;
  5 /
BEGIN
*

ERROR at line 1:

ORA-23357: the propagator does not exist
ORA-06512: at "SYS.DBMS_SYS_ERROR", line 79
ORA-06512: at "SYS.DBMS_DEFER_SYS", line 2508
ORA-06512: at line 2

How do i resolve this issue? Anyhelp would be really greatful.

Thanks in advance,

---

Do you Yahoo!?
The New Yahoo! Shopping - with improved product search http://shopping.yahoo.com

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Oracle DBA
  INET: sami_resume_at_yahoo.com

Fat City Network Services    -- 858-538-5051 http://www.fatcity.com
San Diego, California        -- Mailing list and web hosting services
---------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

Received on Mon Oct 13 2003 - 12:29:25 CDT