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: Oracle replication

Re: Oracle replication

From: <charlesjohn_at_my-deja.com>
Date: Wed, 18 Oct 2000 15:26:17 GMT
Message-ID: <8skfee$ug2$1@nnrp1.deja.com>

Yes it is.

In article <8sjpo8$oer$1_at_venus.telepac.pt>,   "Screamer" <mflopes_at_bigfoot.com> wrote:
> Is it 8.1.6 enterprise edition ?
>
> <charlesjohn_at_my-deja.com> wrote in message
> news:8sil13$gg2$1_at_nnrp1.deja.com...
> > I am trying to setup a multimaster replication environment between 2
> > Oracle 8.1.6 databases.
> >
> > The Advanced Replication option was installed on both servers.
 However
> > notice the error I get when the Replication Manager tries to run
 this
> > PL/SQL block.
> >
> > SQL> BEGIN
> > 2 DBMS_REPCAT.ADD_MASTER_DATABASE(
> > 3 gname => '"EMPLOYEE"',
> > 4 master => 'ABYSS.MERAK.COM',
> > 5 use_existing_objects => TRUE,
> > 6 copy_rows => TRUE,
> > 7 propagation_mode => 'ASYNCHRONOUS');
> > 8 END;
> > 9 /
> > BEGIN
> > *
> > ERROR at line 1:
> > ORA-00439: feature not enabled: Advanced replication
> > ORA-06512: at "SYS.DBMS_SNAP_INTERNAL", line 134
> > ORA-06512: at "SYS.DBMS_REPCAT_MAS", line 1873
> > ORA-06512: at "SYS.DBMS_REPCAT", line 121
> > ORA-06512: at line 2
> >
> > I ran the catrepr.sql to remove all Replication procedures and ran
> > catrep.sql to create them fresh on both servers. I re-installed
> > Advanced replication on the servers as well.
> >
> > Any helpful hints will be appreciated.
> >
> > Charles
> >
> >
> > Sent via Deja.com http://www.deja.com/
> > Before you buy.
>
>

Sent via Deja.com http://www.deja.com/
Before you buy. Received on Wed Oct 18 2000 - 10:26:17 CDT

Original text of this message

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