ORA-23493/ORA-1403 Adding a new master site without quiescing the group in Oracle 12c (Doc ID 2139872.1)

Last updated on MAY 19, 2016

Applies to:

Oracle Database - Enterprise Edition - Version 12.1.0.1 to 12.1.0.2 [Release 12.1]
Information in this document applies to any platform.

Symptoms

Adding a new Master Site to an existing replication group without quiescing fails with the following errors in Oracle 12c following the instructions in chapter 7 "Adding New Master Sites Without Quiescing the Master Group" of the Oracle® Database Advanced Replication Management API Reference Guide fails with the following errors:

SQL> BEGIN
DBMS_REPCAT.PREPARE_INSTANTIATED_MASTER (
    extension_id => '3206AE9CEEF90B57E0536B5EF00A65DD');
END;
/
BEGIN
*
ERROR at line 1:
ORA-23493: "DBS3.REGRESS.RDBMS.DEV.US.ORACLE.COM" is not a new site for
extension request "3206AE9CEEF90B57E0536B5EF00A65DD"
ORA-01403: no data found
ORA-06512: at "SYS.DBMS_REPCAT_ADD_MASTER", line 2651
ORA-06512: at "SYS.DBMS_REPCAT_DEFINER", line 1200
ORA-06512: at "SYS.DBMS_REPCAT", line 1189
ORA-06512: at line 2

 

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