While configuring the DG Broker, we are getting the following error. We have recreated the password files and recreated the configuration files but error persisted. We are in the 12c RAC environment. We are able connect to the standby from the primary using the TNSNAMES. Thanks in advance.
From PRIMARY SERVER
DGMGRL> create configuration odajc_dg_cfg as primary database is odajc connect identifier is odajc;
Configuration "odajc_dg_cfg" created with primary database "odajc"
DGMGRL> add database odacs as connect identifier is odacs;
Database "odacs" added
DGMGRL> show configuration
Configuration - odajc_dg_cfg
Protection Mode: MaxPerformance
Members:
odajc - Primary database
odacs - Physical standby database
Fast-Start Failover: DISABLED
Configuration Status:
DISABLED
DGMGRL> enable configuration
Enabled.
DGMGRL> show configuration
Configuration - odajc_dg_cfg
Protection Mode: MaxPerformance
Members:
odajc - Primary database
Error: ORA-16810: multiple errors or warnings detected for the database
odacs - Physical standby database
Error: ORA-16664: unable to receive the result from a database
Fast-Start Failover: DISABLED
Configuration Status:
ERROR (status updated 12683 seconds ago)
From Standby Server
Welcome to DGMGRL, type "help" for information.
Connected as SYSDBA.
DGMGRL> show configuration
Configuration - odajc_dg_cfg
Protection Mode: MaxPerformance
Members:
odajc - Primary database
Error: ORA-01017: invalid username/password; logon denied
odacs - Physical standby database
Fast-Start Failover: DISABLED
Configuration Status:
ERROR (status updated 0 seconds ago)