Adding New Master Sites Without Quiescing the Master Group (10.1.0.2)

[JWH]

All three database are ASM and flashback logging enabled in RHEL 3 environment
Establishing asynchronous multimaster replication between two sites worked just fine.

Attempt to add third failed:-

Step1. Set up:
1.The replication administrator at new master site
2.A scheduled link from each existing master site to new master site
3.A scheduled link from new master site to each existing master site
4.A schedule purge job at new master site

Status OK

Step 2. CONNECT repadmin/[email protected]

BEGIN
DBMS_REPCAT.SPECIFY_NEW_MASTERS (
gname => 'hr_repg',
master_list => 'orc3.world');
END;

Status OK

Next step:-

variable masterdef_flashback_scn number;
variable extension_id varchar2(50);
BEGIN
DBMS_REPCAT.ADD_NEW_MASTERS (
export_required => true,
available_master_list => 'orc3.world',
masterdef_flashback_scn => :masterdef_flashback_scn,
extension_id => :,
break_trans_to_masterdef => false,
break_trans_to_new_masters => false,
percentage_for_catchup_mdef => 80,
cycle_seconds_mdef => 60,
percentage_for_catchup_new => 80,
cycle_seconds_new => 60);
END;

Procedure DBMS_REPCAT.ADD_NEW_MASTERS hangs.

Monitoring administrative requests at all three master sites through Java-Console is showing six administrative requests pending for a while (two at the one ,supposed to be added,three at Masterdef,one at second non-Masterdef Site )
For error tracking view:-
http://forums.oracle.com/forums/thread.jsp?forum=69&thread=282417&tstart=0&trange=15

Cannot escalate issue to vendor due to development phase

 

[JWH]

Adding New Master Sites Without Quiescing the Master Group (9.2.0.4)

The same procedures in the same environment work fine for 9.2.0.4.
Up on successful completion DBMS_REPCAT.ADD_NEW_MASTERS
returns value of masterdef_flashback_scn and updates FLASHBACK_SCN
field of view DBA_REPEXTENSIONS. This value is supposed to be used
to export desired schema on Masterdef Site for transfer and import on
newly added site to Multi-Master Replication System