Enable and disable Case Sensitive password in Oracle
For case sensitive password in Oracle database, we need to set the parameter “sec_case_sensitive_logon”.
This parameter is dynamic we are not need to restart the database after changing its value.
Note: This parameter is depreciated in 12.2 version of Oracle and set as TRUE value if you change it to false user not able to connect. So, keep it value to TRUE.
SQL> show parameter sec_case_sensitive_logon
NAME TYPE VALUE ------------------------ ------- -------- sec_case_sensitive_logon boolean TRUE
Note: Default value is TRUE.
Disable the Case Sensitive Password in Oracle
ALTER SYSTEM SET SEC_CASE_SENSITIVE_LOGON=FALSE SCOPE=BOTH;
Enable the Case Sensitive Password in Oracle
ALTER SYSTEM SET SEC_CASE_SENSITIVE_LOGON=TRUE SCOPE=BOTH;
Note:
During creating of new password file you can use ORAPWD command with IGNORECASE=Y for handling case sensitivity in password.
Example
SQL> alter system set sec_case_sensitive_logon=TRUE scope=both;
System altered.
SQL> conn c##test/test
Connected.
SQL> conn c##test/Test
ERROR:
ORA-01017: invalid username/password; logon denied
Warning: You are no longer connected to ORACLE.
