you did your dataguard setup and everything seems to be configured correct. the broker configuration is fine, you can cross connect to each instance as sysdba but when performing a switchover through dgmgrl you receive:
ORA-01017 : invalid username/password; logon denied
… and you even provided the sys password while connecting with dgmgrl:
dgmgrl sys/password@somedatabase
what went wrong ? just had this case and it took me an hour to figure it out: the sys password contained special characters. what a …. maybe this is mentioned somewhere in the documentation.
a quick way to test it:
if:
sqlplus sys/"somepasswordwithspecialcharacters"@somedb as sysdba
works, but the same connect without the quotes does not:
sqlplus sys/somepasswordwithspecialcharacters@somedb as sysdba
… try to change the password to anything without special characters and you will succeed ( remember to change the password for the password file, too ) ….
Daniel Westermann's Blog 