Skip to Main Content

Database Software

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

ERROR ORA-23313

385160Aug 19 2003 — edited Oct 12 2003
ORA-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;
/
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Nov 9 2003
Added on Aug 19 2003
1 comment
1,707 views