Oracle replication

From: <charlesjohn_at_my-deja.com>
Date: Tue, 17 Oct 2000 22:49:10 GMT
Message-ID: <8sil13$gg2$1@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 Tue Oct 17 2000 - 17:49:10 CDT