Re: Oracle Replication problem

Bostjan Stupica wrote:
>
> I have a big problem by replication.
> I'm trying to test the replication in our firm between two Oracle Servers
> v7 with Advanced Replication Option installed. The problem is, that when I
> create Master Definition Site works all OK (the replication group status is
> Normal). But when I add another master site, then the replication don't
> want to work. The status is QUIESCED.
> Can be the problem related to the links?
> Both Oracle have Database name set to "Oracle" and the domain is "World".
> Can I (or must I) change this?
>
> Thank's in advance ...
>
> Bostjan

Bostjan,

When adding a master site to the repgroup(or repschema depends on server version), you have to make sure there is no entry in the dba_repcatlog table before you call dbms_repcat.resume_master_activity. Sometime it takes a while. dba_repcatlog gives you some information if things went wrong. If you are sure you wait long enough and the records in the dba_repcatlog still showing "waiting for callback", check your database links:

Sys creates public database link with destination and without the password.
Sys creates private database link and connect as repsys with repsys password and without destination.
Repadmin and schema owner create their own database links with password and without the destination.

As long as your global_name is unique, database name does not matter. Bob Received on Mon Apr 21 1997 - 00:00:00 CDT