After upgrading production database to 11g, I thought to try some other features of Oracle database 11g on test database. So tried to start configuring standby database. Created password files with manager password.
But we noticed that, archive file is not shipping to physical standby side and getting authentication error again and again. Finally I have shutdown my PC and went to watch News. While watching movie idea came into mind, this error might be because of 11g new feature case sensitive password. Well it is, and I created password file with following command and after that thing work fine.
orapwd file=orclpwd password=manager ignorecase=y
Password case sensitive by default, new init.ora parameter sec_case_sensitive_logon is introduce in 11g to switch on/off
alter system set sec_case_sensitive_logon = false#
#Find users who have case sensitive or case insensitive
SQL> COL USERNAME form a19
Since password are case sensitive, so DB link created from pre-11G DB to 11G DB might not work. When you create database link in pre-11G DB by default password saved in upper case and when you use database link you will get error "ORA-01017: invalid username/password; logon denied"
When creating database link, use following work around to force case sensitive password