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: Screamer <mflopes_at_bigfoot.com>
Date: Wed, 18 Oct 2000 10:14:23 +0100
Message-ID: <8sjpo8$oer$1@venus.telepac.pt>

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.
Received on Wed Oct 18 2000 - 04:14:23 CDT

Original text of this message

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