URGENT !!! Need help in configuring Advance Replication ( Multimaster ) on Oracle 7 env.

From: (wrong string) înzatu <mvali_at_rds.ro>
Date: Wed, 23 Feb 2000 11:50:59 GMT
Message-ID: <DQPs4.7$%X1.331_at_nreader1.kpnqwest.net>



I have used the Oracle Replication Manager 1.3.6.0.1. I tried many times with its wizard but it didn't work. I managed to create the REPADMIN users on both instances, but that was all. In the script I've seen that it tries to make two database link for each of the instances with the generic name 'ORACLE.WORLD'. So, i said, here is the problem. I manually made those links like 'ORACLE.WORLD_at_SEATTLE'. The links are good, but after I made the master group and I added some tables to it, when I tried to assign a destination it crashed like that :

begin

   dbms_repcat.add_master_database(

      gname => '"LUV"',
      master => 'ORACLE.WORLD_at_SEATTLE',
      use_existing_objects => TRUE,
      copy_rows => TRUE,
      propagation_mode => 'ASYNCHRONOUS');
end;

/*****

ORA-23378: connection qualifier "_at_SEATTLE" is not valid for object group LUV
ORA-06512: at "SYS.DBMS_SYS_ERROR", line 92
ORA-06512: at "SYS.DBMS_REPCAT_UTL", line 2180
ORA-06512: at "SYS.DBMS_REPCAT_UTL", line 1182
ORA-06512: at "SYS.DBMS_REPCAT_MAS", line 481
ORA-06512: at "SYS.DBMS_REPCAT", line 76
ORA-06512: at line 2

*****/

I don't know what to do. Any suggestion is welcome.

Thanks in advance,
Valentin Mînzatu Received on Wed Feb 23 2000 - 12:50:59 CET

Original text of this message