Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: Advanced Replication URGENT!
Brian,
Hi. This is when it cannot find the remote database. Make sure you have run the
KLGR.SQL script. Run it and then get back to me and lets take it from there.
Tapan
bgbgbg wrote:
> 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 - 23:18:00 CST