A technical troubleshooting blog about Oracle with other Databases & Cloud Technologies.

ORA-16525: DGMGRL Create Configuration Failing

1 min read

PROBLEM:

When DGMGRL is used to create DG broker configuration it fails with below error :

DGMGRL> connect sys
Password:
Connected to "<DB_UNIQUE_NAME>"
Connected as SYSDBA.
DGMGRL> Create configuration '<Configuration name>' as Primary database is '<Primary db_unique_name>' Connect identifier is '<standby db_unique_name>';
Error:
ORA-16525: The Oracle Data Guard broker is not yet available.

On primary database the log_archive_dest parameter is already set to remote standby database. 

log_archive_dest_2 string SERVICE=<standby db_unique_name> async noaffirm valid_for=(online_logfiles,primary_role) max_failure=1 db_unique_name=<standby db_unique_name>

Solution:

1. Make sure DG_BROKER_START is set to TRUE on all nodes of primary and standby.

2. Reset the Log_archive_dest_n value to NULL .

3. Try to create configuration.

On Primary Database:

DGMGRL> CREATE CONFIGURATION '<CONFIGURATION_NAME>' AS PRIMARY DATABASE IS '<PRIMARY_DATABASE_NAME>' CONNECT IDENTIFIER IS <CONNECT_IDENTIFIER>;

DGMGRL> ADD DATABASE '<STANDBY_DATABASE_NAME>' AS CONNECT IDENTIFIER IS <CONNECT_IDENTIFIER> MAINTAINED AS PHYSICAL;

DGMGRL> ENABLE CONFIGURATION;