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