| Error in DBMS_REPCAT.ADD_MASTER_DATABASE [message #489544] |
Mon, 17 January 2011 07:30  |
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  |
 |
Michel Cadot
Messages: 68732
Registered: March 2007
Location: Saint-Maur, France, https...
|
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
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
