ORA-23313 error when calling CREATE_MASTER_REPGROUP
Oracle Database Tips by Donald Burleson
Question: I'm using the great
Replication" as my guide, and I'm getting an ORA-23313 error
when calling CREATE_MASTER_REPGROUP:
gname => '&&replication_mgroup_name.',
master => '&&master_linkname.',
propagation_mode => 'ASYNCHRONOUS');
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
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 ...
next_date => SYSDATE,
interval => 'SYSDATE + 1/24',
delay_seconds => 0);
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:
object group "name" is not mastered at
The group name is null, the group name is misspelled, the invocation
database is not a master, or the invocation database does not believe
the given database is a master.
If the given group name was correct, connect to a current master and
retry the request, make the invocation database a master with
ADD_MASTER_DATABASE, or use SWITCH_SNAPSHOT_MASTER if the invocation
database is a snapshot site. For more information about adding a master
site and changing a snapshot site's master, see the index entries on
"master sites, creating," "changing, master definition site," "ADD_MASTER_DATABASE,"
Oracle8 Server Distributed Systems.
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
You can buy it direct from the publisher for 30%-off and get
instant access to the code depot of Oracle tuning scripts.