Oracle-L: Re: REPLICATION: ORA-23313: object group "PUBLIC"."HR

Home -> Community -> Mailing Lists -> Oracle-L -> Re: REPLICATION: ORA-23313: object group "PUBLIC"."HR_REPG" is not mastered at ORC1.WORLD

From: Arup Nanda <orarup_at_hotmail.com>
Date: Mon, 01 Sep 2003 13:59:25 -0800
Message-ID: <F001.005CE73E.20030901135925@fatcity.com>

Sami,

Setting up replication is pretty straight forward as long as you follow all the steps dilligently. Unfortunately if a step is missed, it's hard to diagnose the problem until one is at the terminal looking at the actual database. In this case there are several steps that my not have been correctly executed. Here are some:

(1) Have you built the replication support for the master group?

begin

        dbms_repcat.generate_replication_support(
                sname=>'HR',
                oname=>'DEPATMENTS',
                type=>'TABLE',
                min_communication=>TRUE);

end;

(2) Have you started replication activity?

begin

        dbms_repcat.resume_master_activity(
                gname=>'HR_REPG');

end;

(3) Have you created the snaphsot group at the MV Site using dbms_refresh.make?

You should do this steps before you create the MV RepGroup. You may find an article I wrote for DBAZine (http://www.dbazine.com/nanda2.html), a related but separate issue. And please let us know your progress.

HTH. Arup

Original Message ----- To: "Multiple recipients of list ORACLE-L" <ORACLE-L_at_fatcity.com> Sent: Monday, September 01, 2003 5:09 PM mastered at ORC1.WORLD

> Dear Arup,
>
> Thanks for your response. But i have done the same
> which is mentioned in page # 3-6(Replication API
> Reference Manual). Please see below. What else could
> be wrong? TIA
>
> CONNECT repadmin/repadmin_at_orc1.world
> BEGIN
> DBMS_REPCAT.CREATE_MASTER_REPGROUP (
> gname => 'hr_repg');
> END;
> /
>
> BEGIN
> DBMS_REPCAT.CREATE_MASTER_REPOBJECT (
> gname => 'hr_repg',
> type => 'TABLE',
> oname => 'departments',
> sname => 'hr',
> use_existing_object => TRUE,
> copy_rows => FALSE);
> END;
> /
>
>
>
> --- Arup Nanda <orarup_at_hotmail.com> wrote:
> > Before you create the Materialized View Group, you
> > must create the REPGROUP
> > at the Master site, which in you case is ORC1.world.
> >
> > In the database ORC1, use the
> > DBMS_REPCAT.CREATE_MASTER_REPGROUP and
> > DBMS_REPCAT.CREATE_MASTER_REPOBJECT before calling
> > the procedure
> > DBMS_REPCAT.CREATE_MVIEW_REPGROUP.
> >
> > HTH.
> >
> > Arup Nanda
> >
> > ----- Original Message -----
> > To: "Multiple recipients of list ORACLE-L"
> > <ORACLE-L_at_fatcity.com>
> > Sent: Monday, September 01, 2003 4:24 PM
> > mastered at ORC1.WORLD
> >
> >
> > > Hi list
> > >
> > > I am using Oracle 9.2.0.1.0 enterprise on windows.
> > >
> > > I am going thru the examples provided in
> > "Replication
> > > Management API Reference-Part No. A96568-01".
> > >
> > > While creating MVIEW REPLICATION GROUP, getting
> > the
> > > following error (page # 5-7)
> > >
> > >
> > > SQL> CONNECT mviewadmin/mviewadmin_at_mv1.world
> > > Connected.
> > > SQL> BEGIN
> > > 2 DBMS_REPCAT.CREATE_MVIEW_REPGROUP (
> > > 3 gname => 'hr_repg',
> > > 4 master => 'orc1.world',
> > > 5 propagation_mode => 'ASYNCHRONOUS');
> > > 6 END;
> > > 7 /
> > > BEGIN
> > > *
> > > ERROR at line 1:
> > > ORA-23313: object group "PUBLIC"."HR_REPG" is not
> > > mastered at ORC1.WORLD
> > > ORA-06512: at "SYS.DBMS_SYS_ERROR", line 105
> > > ORA-06512: at "SYS.DBMS_REPCAT_SNA_UTL", line 2424
> > > ORA-06512: at "SYS.DBMS_REPCAT_SNA_UTL", line 1757
> > > ORA-06512: at "SYS.DBMS_REPCAT_SNA", line 64
> > > ORA-06512: at "SYS.DBMS_REPCAT", line 1262
> > > ORA-06512: at line 2
> > >
> > >
> > > Any help would be really greatful.
> > >
> > > Thanks
> > > Sami
> > >
> > > __________________________________
> > > Do you Yahoo!?
> > > The New Yahoo! Search - Faster. Easier. Bingo.
> > > http://search.yahoo.com
> > > --
> > > Please see the official ORACLE-L FAQ:
> > http://www.orafaq.net
> > > --
> > > Author: Oracle DBA
> > > INET: sami_resume_at_yahoo.com
> > >
> > > Fat City Network Services -- 858-538-5051
> > http://www.fatcity.com
> > > San Diego, California -- Mailing list and
> > web hosting services
> > >
> >
> ---------------------------------------------------------------------
> > > To REMOVE yourself from this mailing list, send an
> > E-Mail message
> > > to: ListGuru_at_fatcity.com (note EXACT spelling of
> > 'ListGuru') and in
> > > the message BODY, include a line containing: UNSUB
> > ORACLE-L
> > > (or the name of mailing list you want to be
> > removed from). You may
> > > also send the HELP command for other information
> > (like subscribing).
> > >
> > --
> > Please see the official ORACLE-L FAQ:
> > http://www.orafaq.net
> > --
> > Author: Arup Nanda
> > INET: orarup_at_hotmail.com
> >
> > Fat City Network Services -- 858-538-5051
> > http://www.fatcity.com
> > San Diego, California -- Mailing list and web
> > hosting services
> >
> ---------------------------------------------------------------------
> > To REMOVE yourself from this mailing list, send an
> > E-Mail message
> > to: ListGuru_at_fatcity.com (note EXACT spelling of
> > 'ListGuru') and in
> > the message BODY, include a line containing: UNSUB
> > ORACLE-L
> > (or the name of mailing list you want to be removed
> > from). You may
> > also send the HELP command for other information
> > (like subscribing).
>
>
> __________________________________
> Do you Yahoo!?
> The New Yahoo! Search - Faster. Easier. Bingo.
> http://search.yahoo.com
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.net
> --
> Author: Oracle DBA
> INET: sami_resume_at_yahoo.com
>
> Fat City Network Services -- 858-538-5051 http://www.fatcity.com
> San Diego, California -- Mailing list and web hosting services
> ---------------------------------------------------------------------
> To REMOVE yourself from this mailing list, send an E-Mail message
> to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
> the message BODY, include a line containing: UNSUB ORACLE-L
> (or the name of mailing list you want to be removed from). You may
> also send the HELP command for other information (like subscribing).
>

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Arup Nanda
  INET: orarup_at_hotmail.com

Fat City Network Services    -- 858-538-5051 http://www.fatcity.com
San Diego, California        -- Mailing list and web hosting services
---------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

Received on Mon Sep 01 2003 - 16:59:25 CDT