Replication Error
Hi
i'm having a replication between a branch and the headoffice db
This error is raised when we enter an entry in the snapshot site and another entry in the head office site and we do a fast refresh of the data.
The replication is done as a master snapshot replication.
in the master site we enter an entry with branch=4
and in the snapshot site we enter another entry with branch=4
this error is raised on refresh.
the snapshot was created for branch = 4 in the snapshot site
begin
*
ERROR at line 1:
ORA-23324: error ORA-01017: invalid username/password; logon denied
ORA-02063: preceding line from INTB.INTERBRANDN.COM.LB, while creating deferror
entry at "INTB.INTERBRANDN.COM.LB" with error -1017
ORA-06512: at "SYS.DBMS_SNAPSHOT", line 617
ORA-06512: at "SYS.DBMS_SNAPSHOT", line 674
ORA-06512: at "SYS.DBMS_IREFRESH", line 577
ORA-06512: at "SYS.DBMS_REFRESH", line 211
ORA-06512: at line 2
we are sure that the username password are correct since if we do an entry only in 1 site the working correctly.
my question: to have different data entries in this case do we need to make a master to master replication?
if yes will it work with Oracle8i Standard Edition?
Regards
Tony