Oracle 11g New feaures Case Sensitive Password

Oracle 11g New feaures : Case Sensitive Password

Virag Sharma virag123@gmail.com

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

# # 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 ---------- -------- ABCXYZ12 10G 11G ADKULABC 10G 11G ORACLE12 10G 11G VIRAGSHA 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 identified by "tiger" using 'ORCL2';

Reference

Oracle Database Security Guide11g Release 1 (11.1)