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.