My Oracle Support Banner

remtool -asrrectify Produces ORA-23419: Regenerate Replication Support Before Resuming Master Activity (Doc ID 389928.1)

Last updated on AUGUST 30, 2023

Applies to:

Oracle Internet Directory - Version 10.1.2 and later
Information in this document applies to any platform.

Symptoms

Replication is failing in previously working environment after failed attempt to add additional RMS i.e. -addnode failure then -delnode.

remtool.log shows error ORA-23419: regenerate replication support before resuming master activity.

remtool -asrrectify produces e.g. the following remtool.log entries

....
2006/08/22:16:36:28 * <MASTER_OID_HOSTNAME>.<DOMAIN>.COM is Master Definition Site (MDS). Connected to MDS.
2006/08/22:16:36:32 * <REPLICA1_OID_HOSTNAME.<DOMAIN>.COM is Remote Master Site (RMS). Connected to RMS.
2006/08/22:16:36:33 * <REPLICA2_OID_HOSTNAME.<DOMAIN>.COM is Remote Master Site (RMS). Connected to RMS.
.....
2006/08/22:16:37:30 * <MASTER_OID_HOSTNAME>.<DOMAIN>.COM : Verifying replication group...
2006/08/22:16:37:33 * ASR SETUP ERROR/WARNING:
2006/08/22:16:37:33 * <MASTER_OID_HOSTNAME>.<DOMAIN>.COM : Replication support cannot be generated for TABLE ODS.ODS_CHG_STAT. now.
2006/08/22:16:37:33 * <MASTER_OID_HOSTNAME>.<DOMAIN>.COM : Resuming replication activity...
2006/08/22:16:37:49 * Error occurred while altering replication status.
2006/08/22:16:37:49 * <MASTER_OID_HOSTNAME>.<DOMAIN>.COM: ORA-23419: regenerate replication support before resuming master activity
ORA-06512: at "SYS.DBMS_REPCAT_UTL4", line 2357
ORA-06512: at "SYS.DBMS_REPCAT_MAS", line 3544
ORA-06512: at "SYS.DBMS_REPCAT", line 826
ORA-06512: at line 1
.....
2006/08/22:16:39:04 * <MASTER_OID_HOSTNAME>.<DOMAIN>.COM : Executing deferred administrative requests...
2006/08/22:16:39:15 * <MASTER_OID_HOSTNAME>.<DOMAIN>.COM : RESUME_MASTER_ACTIVITY : ORA-23419: regenerate replication support before resuming master activity
2006/08/22:16:39:15 * <REPLICA1_OID_HOSTNAME.<DOMAIN>.COM : Verifying replication group...
2006/08/22:16:39:17 * <MASTER_OID_HOSTNAME>.<DOMAIN>.COM : Resuming replication activity...
2006/08/22:16:39:27 * Error occurred while altering replication status.
2006/08/22:16:39:27 * <MASTER_OID_HOSTNAME>.<DOMAIN>.COM : ORA-23419: regenerate replication support before resuming master activity
ORA-06512: at "SYS.DBMS_REPCAT_UTL4", line 2357
ORA-06512: at "SYS.DBMS_REPCAT_MAS", line 3544
ORA-06512: at "SYS.DBMS_REPCAT", line 826
ORA-06512: at line 1
....

Cause

To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!


In this Document
Symptoms
Cause
Solution

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.