Advanced Replication URGENT!

From: bgbgbg <brian.gallagher_at_iona.com>
Date: Wed, 3 Nov 1999 15:48:38 -0000
Message-ID: <7vpliu$ekh$1@bvweb.dublin.iona.ie>

I'm setting up advanced async multi-master replication DB1 --> DB2 DB1 = Master DEf. Site
DB2 = Remote Master
system.,sys, repadmin, repsys and scott all have the same username passwords on both and links between accounts work fine.

when i go to add the remote master on DB1 (connected as repadmin) i get the following errors:

SQL> execute DBMS_REPCAT.ADD_MASTER_DATABASE('SCOTT','DB2.World'); begin DBMS_REPCAT.ADD_MASTER_DATABASE('SCOTT','DB2.World'); end;

*
ERROR at line 1:

ORA-04052: error occurred when looking up remote object REPSYS.SYS_at_DB2.WORLD
ORA-00604: error occurred at recursive SQL level 2
ORA-01017: invalid username/password; logon denied
ORA-02063: preceding line from DB2
ORA-06512: at "SYS.DBMS_REPCAT_UTL", line 136
ORA-06512: at "SYS.DBMS_REPCAT_MAS", line 483
ORA-06512: at "SYS.DBMS_REPCAT", line 76
ORA-06512: at line 1

any help greatly appreciated ???? Received on Wed Nov 03 1999 - 09:48:38 CST