ERROR ORA-23313
385160Aug 19 2003 — edited Oct 12 2003ORA-23313: object group "PUBLIC"."GTK_MG" is not mastered at CITY(second master DB)
My Script:
1.////////////////////////////
/* Setting up a multi-master replication enviroment */
/* Granting admin privileges to REPADMIN at site ORCL.GOROD.RU... */
BEGIN
DBMS_REPCAT_ADMIN.GRANT_ADMIN_ANY_SCHEMA(
username => '"REPADMIN"');
END;
grant comment any table to "REPADMIN"
grant lock any table to "REPADMIN"
/* Granting privileges to schema REPADMIN at site ORCL... */
grant execute any procedure to "REPADMIN"
/*Connecting to site ORCL as user REPADMIN...*/
/* A purge job has already been scheduled at site ORCL.GOROD.RU by user REPADMIN. Therefore it will not be re-scheduled by user "REPADMIN". */
/*Connecting to site ORCL.GOROD.RU as user REPADMIN...*/
/*Connecting to site ORCL.GOROD.RU as user SYSTEM...*/
2///////////////////////
/* Setting up a multi-master replication enviroment */
/* Granting admin privileges to REPADMIN at site MP480-3 */
BEGIN
DBMS_REPCAT_ADMIN.GRANT_ADMIN_ANY_SCHEMA(
username => '"REPADMIN"');
END;
grant comment any table to "REPADMIN"
grant lock any table to "REPADMIN"
/* Granting privileges to schema REPADMIN at site MP480-3... */
grant execute any procedure to "REPADMIN"
/*Connecting to site MP480-3 as user REPADMIN...*/
/* A purge job has already been scheduled at site MP480-3.GOROD.RU by user REPADMIN. Therefore it will not be re-scheduled by user "REPADMIN". */
/*Connecting to site MP480-3.GOROD.RU as user REPADMIN...*/
/*Connecting to site MP480-3.GOROD.RU as user SYSTEM...*/
3////////////////////////
BEGIN
DBMS_REPCAT.CREATE_MASTER_REPGROUP(
gname => '"GTK_MG"',
qualifier => '',
group_comment => '');
END;
/
BEGIN
DBMS_REPCAT.CREATE_MASTER_REPOBJECT(
gname => '"GTK_MG"',
type => 'TABLE',
oname => '"USERS"',
sname => '"CUSTOMSITE2"',
copy_rows => TRUE,
use_existing_object => TRUE);
END;
/
BEGIN
DBMS_REPCAT.ADD_MASTER_DATABASE(
gname => '"GTK_MG"',
master => 'CITY',
use_existing_objects => FALSE,
copy_rows => TRUE,
propagation_mode => 'ASYNCHRONOUS');
END;
/
BEGIN
DBMS_REPCAT.GENERATE_REPLICATION_SUPPORT(
sname => '"CUSTOMSITE2"',
oname => '"USERS"',
type => 'TABLE',
min_communication => TRUE,
generate_80_compatible => FALSE);
END;
/
BEGIN
DBMS_REPCAT.RESUME_MASTER_ACTIVITY(
gname => '"GTK_MG"');
END;
/