It's been long time everything was working fine with oracle DG broker (dgmgrl> ). Suddenly we faced this error in DG broker while trying to valid network configuration before a SWITCHOVER operation, even though no one change any credentials.
After sometime, we realized that we were connected to DG broker as SYSDG user (normally connect with SYS). and then found that, the SYSDG user's credential are not same in both PRIMARY and STANDBY password file. that's why it is not able to connect. Here is the query to check this in both environments -
SQL> select * from v$pwfile_users;
Then logout and connect back with SYS user, everything worked perfectly.
dgmgrl> connect sys
So solution is- 1) Either you need to change SYSDG user's credentials in both database same (since remote_login_passwordfile is set to EXCLUSIVE) . so it will saved and match in Password file.
2) OR login with a different super user (like SYS) who's credentials are same for both databases.
For details you may read- ora-01017
