DG Broker reports show configuration ORA-16642: DB_UNIQUE_NAME mismatch
Error:
DG broker show configuration is giving errors
DGMGRL> show configuration
Configuration - BE122
Protection Mode: MaxPerformance
Members:
PRMY - Primary database
Error: ORA-16642: DB_UNIQUE_NAME mismatch
STBY - Physical standby database
Fast-Start Failover: DISABLED
In the alert log file we found that the Fatal NI connect 12514 error was seen.
When found the tnsnames.ora was having wrong host name for the primary host
Solution:
1) Correct the tnsnames.ora hostname value for the primary
2) Disable and enable DG Broker :
-- At Both PRIMARY & STANDBY :
$ sqlplus / as sysdba
SQL> alter system set dg_broker_start=FALSE scope=both sid='*';
SQL> alter system set dg_broker_start=TRUE scope=both sid='*';
Post a Comment
Post a Comment