ORA-23493/ORA-1403 Adding a new master site without quiescing the group in Oracle 12c
(Doc ID 2139872.1)
Last updated on AUGUST 06, 2021
Applies to:
Oracle Database Cloud Service - Version N/A and laterOracle Database - Enterprise Edition - Version 12.1.0.1 to 12.1.0.2 [Release 12.1]
Oracle Database Cloud Schema Service - Version N/A and later
Gen 1 Exadata Cloud at Customer (Oracle Exadata Database Cloud Machine) - Version N/A and later
Oracle Cloud Infrastructure - Database Service - Version N/A and later
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: "DBNAME.ORGANIZATION.REGION.EXAMPLE.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
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 |