Hello,
I am having some problems in making 3 sites master replication!
I have tables with data in 3 sites.
I made a group 1 site, added sites,object,generate replication support for objects.
However when I make select from some tables for oracle, they say their is synonem loops.
this query
SELECT COUNT(*) FROM DBA_REPCATLOG WHERE GNAME = 'REP';
returns non zero counts.
this query
select sname, master, status from dba_repgroup;
returns quiesced status for the group.
I am not able to have the replication environment!
here are some of the queries:
I have tried some procedures at the end maybe they are not useful
begin
dbms_repcat.drop_master_repgroup(
gname => 'rep_group',
all_sites => true,
drop_contents => true
);
end;
/
--but public was created again!
EXECUTE Dbms_Repcat.Create_Master_Repgroup('rep');
--execute this at goods site, it is the master defenition site
begin
DBMS_REPCAT.ADD_MASTER_DATABASE (
gname => 'rep',
master => 'life.dept',
use_existing_objects => TRUE,
copy_rows => false,
propagation_mode => 'SYNCHRONOUS');
END;
/
begin
DBMS_REPCAT.ADD_MASTER_DATABASE (
gname => 'rep',
master => 'car.dept',
use_existing_objects => TRUE,
copy_rows => false,
propagation_mode => 'SYNCHRONOUS');
END;
/
SELECT DBLINK FROM DBA_REPSITES WHERE GNAME = 'REP';
sELECT table_owner, table_name, db_link
FROM dba_synonyms
WHERE owner = 'c##dept_admin';
--no synonyms
BEGIN
DBMS_REPCAT.SUSPEND_MASTER_ACTIVITY (
gname => 'REP');
END;
/
BEGIN
DBMS_REPCAT.GENERATE_REPLICATION_SUPPORT (
sname => 'c##dept_admin',
oname => 'city',
type => 'TABLE',
min_communication => TRUE);
END;
/
BEGIN
DBMS_REPCAT.GENERATE_REPLICATION_SUPPORT (
sname => 'c##dept_admin',
oname => 'region',
type => 'TABLE',
min_communication => TRUE);
END;
/
BEGIN
DBMS_REPCAT.GENERATE_REPLICATION_SUPPORT (
sname => 'c##dept_admin',
oname => 'person',
type => 'TABLE',
min_communication => TRUE);
END;
/
BEGIN
DBMS_REPCAT.GENERATE_REPLICATION_SUPPORT (
sname => 'c##dept_admin',
oname => 'address',
type => 'TABLE',
min_communication => TRUE);
END;
/
-- Start Replication
begin
Dbms_Repcat.Resume_Master_Activity(gname => 'rep');
end;
/
SELECT COUNT(*) FROM DBA_REPCATLOG WHERE GNAME = 'REP';
select sname, master, status from dba_repgroup;
BEGIN
DBMS_REPCAT.SUSPEND_MASTER_ACTIVITY (
gname => 'rep');
END;
/
delete FROM DBA_REPCATLOG WHERE GNAME = 'REP';
BEGIN
DBMS_OFFLINE_OG.RESUME_SUBSET_OF_MASTERS (
gname => 'rep',
new_site => 'life.dept');
END;
/
please help a