Home » Server Options » Replication » Error in DBMS_REPCAT.ADD_MASTER_DATABASE (Oracle 10G R1)
Error in DBMS_REPCAT.ADD_MASTER_DATABASE [message #489544] Mon, 17 January 2011 07:30 Go to next message
Tlg13team
Messages: 100
Registered: June 2008
Location: MGL
Senior Member
hi all,

I'm try to implement multi master replication on my virtual machines.

I using instruction below:
http://www.akadia.com/services/ora_replication_guide.html

I'm get a error when execute procedure below:


SQL> BEGIN
  2     DBMS_REPCAT.ADD_MASTER_DATABASE (
  3        gname => 'REPG',
  4        master => 'REP1.WORLD',
  5        use_existing_objects => TRUE,
  6        copy_rows => FALSE,
  7        propagation_mode => 'ASYNCHRONOUS');
  8  END;
  9  /
BEGIN
*
ERROR at line 1:
ORA-04052: error occurred when looking up remote object REPADMIN.SYS@REP1.WORLD
ORA-00604: error occurred at recursive SQL level 2
ORA-02085: database link REP1.WORLD connects to
REP1.REGRESS.RDBMS.DEV.US.ORACLE.COM
ORA-06512: at "SYS.DBMS_REPCAT_UTL", line 4271
ORA-06512: at "SYS.DBMS_REPCAT_MAS", line 2156
ORA-06512: at "SYS.DBMS_REPCAT", line 146
ORA-06512: at line 2


How to solve this issue?
Re: Error in DBMS_REPCAT.ADD_MASTER_DATABASE [message #489552 is a reply to message #489544] Mon, 17 January 2011 08:28 Go to previous message
Michel Cadot
Messages: 67134
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
ORA-02085: database link %s connects to %s
 *Cause: a database link connected to a database with a different name.
  The connection is rejected.
 *Action: create a database link with the same name as the database it
  connects to, or set global_names=false.

Regards
Michel
Previous Topic: Replication of table for DML from source to destination DB
Next Topic: Is ODI the right technology for me to use?
Goto Forum:
  


Current Time: Wed May 27 16:52:40 CDT 2020