ORA-23313 error when calling CREATE_MASTER_REPGROUP Oracle Database Tips by Donald Burleson

Question: I'm using the great book "Oracle Replication" as my guide, and I'm getting an ORA-23313 error when calling CREATE_MASTER_REPGROUP:

BEGIN
DBMS_REPCAT.CREATE_MVIEW_REPGROUP(
gname => '&&replication_mgroup_name.',
master => '&&master_linkname.',
propagation_mode => 'ASYNCHRONOUS');
END;
/
SHOW ERRORS

as repadmin on the UMV (remote) site, I get...

ORA-23313: object group "PUBLIC"."ROADOCCS_MASTER_REPGROUP" is not mastered at GISDB_DB.TMC
ORA-06512: at "SYS.DBMS_SYS_ERROR", line 105
ORA-06512: at "SYS.DBMS_REPCAT_SNA_UTL", line 2456
ORA-06512: at "SYS.DBMS_REPCAT_SNA_UTL", line 1779
ORA-06512: at "SYS.DBMS_REPCAT_SNA", line 64
ORA-06512: at "SYS.DBMS_REPCAT", line 1262
ORA-06512: at line 2

I have been over the code that many times my brain is spinning.

I do NOT want to use any GUI tools as I am remote from the client site AND they want a PL/SQL script that can be run in a data centre and does not depend on such tools.

I have read the Oracle 10g documentation and, as is usual with Oracle documentation, quite confused as the doco's example involves multi-master sites (3) with 2 UMV sites. The doco talks about "proxy_mviewadmin" and "proxy_refresher" users along with things like ...

BEGIN
DBMS_DEFER_SYS.SCHEDULE_PURGE (
next_date => SYSDATE,
interval => 'SYSDATE + 1/24',
delay_seconds => 0);
END;

Answer: As a prerequisite to calling CREATE_MVIEW_REPGROUP from your remote site, you must first run DBMS_REPCAT.CREATE_MASTER_REPGROUP and DBMS_REPCAT.CREATE_MASTER_REPOBJECT on the master site.  Here are details on the ORA-23313 error from the docs:
 

Before you can call CREATE_MVIEW_REPGROUP to create the Materialized View group, you must first create the REPGROUP at your Master site, in your case, at &&master_linkname.

 

 

If you like Oracle tuning, see the book "Oracle Tuning: The Definitive Reference", with 950 pages of tuning tips and scripts.  You can buy it direct from the publisher for 30%-off and get instant access to the code depot of Oracle tuning scripts.