Case Sensitive issue while login

~ Case Sensitive issue while login

-- Default case sensitive in Oracle 11g
-- Reset case sensitive

In Oracle 11g ( above version 11.1.x.x), default case sensitive os ON, i.e., applies as it is password set with proper case. To make case sensitive flse, following steps can be followed.

-- To check/ verify what is the parameter value.
$ sqlplus / as sysdba
SQL>
SQL> SHOW PARAMETER SEC_CASE_SENSITIVE_LOGON;

NAME                                 TYPE        VALUE
------------------------------------ ----------- ------------------------------
sec_case_sensitive_logon             boolean     TRUE
SQL>
SQL>

-- To change / Alter

SQL> ALTER SYSTEM SET SEC_CASE_SENSITIVE_LOGON = FALSE;

System altered.

Note: No down time require. No restart required. It is a random parameter.