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
## Init.ora parameter #sec_case_sensitive_logon = (TRUE FALSE)
## On system level you can switch off#
alter system set sec_case_sensitive_logon = false
##Find users who have case sensitive or case insensitive#passwords#
SQL> COL USERNAME form a19
SQL> SELECT USERNAME,PASSWORD_VERSIONS FROM DBA_USERS where rownum <>
USERNAME PASSWORD_VERSIONS
ABCXYZ12 10G 11G
ADKULABC 10G 11G
ORACLE12 10G 11G
ANAND 10G
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
## Use quote " with password like "tiger"#create database link abc connect to scott identifiedby "tiger" using 'ORCL2';
