remtool -asrrectify Produces ORA-23419: Regenerate Replication Support Before Resuming Master Activity

(Doc ID 389928.1)

Last updated on JULY 01, 2016

Applies to:

Oracle Internet Directory - Version: 10.1.2 and later   [Release: 10gR2 and later ]
Information in this document applies to any platform.
***Checked for relevance on 03/24/2011***

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 * OIDUK.ORACLE.COM is Master Definition Site (MDS). Connected to MDS.
2006/08/22:16:36:32 * OIDHKG.ORACLE.COM is Remote Master Site (RMS). Connected to RMS.
2006/08/22:16:36:33 * OIDNYK.ORACLE.COM is Remote Master Site (RMS). Connected to RMS.
.....
2006/08/22:16:37:30 * OIDUK.ORACLE.COM : Verifying replication group...
2006/08/22:16:37:33 * ASR SETUP ERROR/WARNING:
2006/08/22:16:37:33 * OIDUK.ORACLE.COM : Replication support cannot be generated for TABLE ODS.ODS_CHG_STAT. now.
2006/08/22:16:37:33 * OIDUK.ORACLE.COM : Resuming replication activity...
2006/08/22:16:37:49 * Error occurred while altering replication status.
2006/08/22:16:37:49 * OIDUK.ORACLE.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 * OIDUK.ORACLE.COM : Executing deferred administrative requests...
2006/08/22:16:39:15 * OIDUK.ORACLE.COM : RESUME_MASTER_ACTIVITY : ORA-23419: regenerate replication support before resuming master activity
2006/08/22:16:39:15 * OIDNYK.GAM.COM : Verifying replication group...
2006/08/22:16:39:17 * OIDUK.ORACLE.COM : Resuming replication activity...
2006/08/22:16:39:27 * Error occurred while altering replication status.
2006/08/22:16:39:27 * OIDUK.ORACLE.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

Sign In with your My Oracle Support account

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

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms