Disable Case Sensitive in Oracle Database 11g

Prior to 11g Passwords in Oracle are not case sensitive. Now from 11g Oracle passwords are Case sensitive. Parameter sec_case_sensitive_logon has been included in Oracle 11g.

SQL> show parameter logon

NAME                                 TYPE                              VALUE
------------------------------------ --------------------------------- ------------------------------
sec_case_sensitive_logon             boolean                           TRUE

SQL> conn amit/AMIT
ERROR:
ORA-01017: invalid username/password; logon denied

Warning: You are no longer connected to ORACLE.
SQL> conn amit/amit
Connected.

Disable Password case sensitive :-

SQL> alter system set sec_case_sensitive_logon=false;

System altered.

SQL> conn amit/AMIT

Connected.

Case Sensitive has been Disabled.

I hope this article helped you.

Regards,

Amit Rath