Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: problems with replication (oracle8i)

Re: problems with replication (oracle8i)

From: FSN <cyberming_at_hotmail.com>
Date: Thu, 18 Oct 2001 16:52:02 -0400
Message-ID: <9qnfbq$oh220$1@ID-58123.news.dfncis.de>


Carlos,I would first check that schema at Kepler which database link uses has proper privileges.Also if check if syntax is correct i.e oracle is expecting schemaowner.object,try qualifying scott_mg with schema owner.

Anwer
Carlos Matsuki wrote in message ...
>Hi,
>
> i have the following problem: I followed the step from Oracle8i
>replication management API Reference to test the replication between
>ORACLE databases, using only 1 database master and 1 snapshot
>database, but when I tried to create a snapshot group associating with
>the master replication, occurred the ORA-23313 (not mastered), but
>this master replication exists, as follow:
>
>-- as snapadmin from snapshot database
>SQL> BEGIN
> 2 DBMS_REPCAT.CREATE_SNAPSHOT_REPGROUP (
> 3 gname => 'SCOTT_MG',
> 4 master => 'KEPLER',
> 5 propagation_mode => 'ASYNCHRONOUS');
> 6 END;
> 7 /
>BEGIN
>*
>ERROR at line 1:
>ORA-23313: object group "PUBLIC"."SCOTT_MG" is not mastered at KEPLER
>ORA-06512: at "SYS.DBMS_SYS_ERROR", line 105
>ORA-06512: at "SYS.DBMS_REPCAT_SNA_UTL", line 2140
>ORA-06512: at "SYS.DBMS_REPCAT_SNA_UTL", line 1536
>ORA-06512: at "SYS.DBMS_REPCAT_SNA", line 64
>ORA-06512: at "SYS.DBMS_REPCAT", line 1045
>ORA-06512: at line 2
>
>-- as master database
>SQL> select * from dba_repgroup
> 2 where sname = 'SCOTT_MG';
>
>SNAME M STATUS
>------------------------------ - ---------
>SCHEMA_COMMENT
>---------------------------------------------------------------------------



>GNAME FNAME R OWNER
>------------------------------ ------------------------------ -
>------------------------------
>SCOTT_MG Y NORMAL
>
>SCOTT_MG N PUBLIC
>
>
>exists PUBLIC.SCOTT_MG, and it's a master repgroup... what's probably
>happening here???
>
>Thanks in advance,
>
>Carlos Matsuki
Received on Thu Oct 18 2001 - 15:52:02 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US