Note: The
sec_case_insensitive_login has been deprecated in Oracle
12c. The default value in 12c and beyond is
sec_case_sensitive_login=true.
Question: I want to know hot to
enable case sensitive passwords in Oracle. Is this
done with the sec_case_sensitive_logon init.ora
parameter?
Answer:
Yes,
the sec_case_sensitive_logon parameter will allow
case sensitive passwords when the value is set to
sec_case_sensitive_logon=true in your pfile or spfile
(init.ora).
The sec_case_sensitive_logon can be changed
dynamically in Oracle with the alter system
command::
SQL> show parameter
sec_case_sensitive_logon
NAME
TYPE VALUE
------------------------------------
----------- -----------------
sec_case_sensitive_logon
boolean TRUE
SQL> alter system set
sec_case_sensitive_logon=false
System altered.
SQL> show parameter
sec_case_sensitive_logon
NAME
TYPE VALUE
------------------------------------
----------- ------------------
sec_case_sensitive_logon
boolean FALSE
For password mismatch issues
ORA-16191 in primary/standby databases (Data Guard) you
need to set
sec_case_sensitive_logon=false and:
1: Create password files on both servers using the
same password and pass ignorecase=Y to the
orapwd utility.
2: Make sure you use
identical options during password file creation for both
primary and standby.
