urgent help needed in multi master replication

Reply

Join Date: Jan 2007
Posts: 1
Reputation: agrawaltanu1 is an unknown quantity at this point 
Solved Threads: 0
agrawaltanu1 agrawaltanu1 is offline Offline
Newbie Poster

urgent help needed in multi master replication

 
0
  #1
Jan 24th, 2007
Hi

I am working on Oracle database 10g. I am trying to implement advanced replication on my database.
Till now I have replicated tables and those are working fine. Now I want to replicate procedure, in this case on running all the procedures(adding packages and generating replication support) I am not getting any error. But after this I am not able to resume replication. In DBA_REPGROUP status of master group is QUIESCED.
I want to know why I am getting this problem and how can i solve it.
I am running following code for this :
BEGIN
DBMS_REPCAT.create_master_repobject (sname => 'REPADMIN',
oname => 'PKG_COMMON_ERROR',
TYPE => 'PACKAGE',
use_existing_object => TRUE,
COMMENT => 'Added on ' || SYSDATE,
retry => FALSE,
gname => 'MYREPGRP'
);
DBMS_REPCAT.create_master_repobject (sname => 'REPADMIN',
oname => 'PKG_COMMON_ERROR',
TYPE => 'PACKAGE BODY',
use_existing_object => TRUE,
COMMENT => 'Added on ' || SYSDATE,
retry => FALSE,
gname => 'MYREPGRP'
);
END;

BEGIN
DBMS_REPCAT.generate_replication_support (sname => 'REPADMIN',
oname => 'PKG_COMMON_ERROR',
TYPE => 'PACKAGE',
DISTRIBUTED => TRUE,
min_communication => TRUE
);
DBMS_REPCAT.generate_replication_support (sname => 'REPADMIN',
oname => 'PKG_COMMON_ERROR',
TYPE => 'PACKAGE BODY',
DISTRIBUTED => TRUE,
min_communication => TRUE
);
END;


Thanks,
Tanu
Reply With Quote Quick reply to this message  
Reply

This thread is more than three months old.
Perhaps start a new thread instead?
Message:



Similar Threads
Other Threads in the Oracle Forum
Thread Tools Search this Thread



About Us | Contact Us | Advertise | DaniWeb | Acceptable Use Policy | RSS Feed

©2003 - 2009 DaniWeb® LLC