SEC_CASE_SENSITIVE_LOGON 参数

beginning with Oracle Database 11g Release 1, database passwords are case-sensitive. (You can
disable case sensitivity and return to pre–Release 11 g<wbr> behavior by setting the<wbr> SEC_CASE_SENSITIVE_LOGON initialization parameter to FALSE.)<br> 从11.1开始，数据库的密码开始区分大小写，但是可以同更改SEC_CASE_SENSITIVE_LOGON initialization=false 回归到以前的状态。<br> 在11.2 默认是true<br> SQL&gt; select * from v$version;</wbr></wbr>

BANNER
--------------------------------------------------------------------------------
Oracle Database 11g Enterprise Edition Release 11.2.0.1.0 - Production
PL/SQL Release 11.2.0.1.0 - Production
CORE<wbr><wbr><wbr> 11.2.0.1.0<wbr><wbr><wbr><wbr><wbr> Production<br> TNS for Linux: Version 11.2.0.1.0 - Production<br> NLSRTL Version 11.2.0.1.0 - Production</wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr>

SQL> show parameter SEC_CASE_SENSITIVE_LOGON

NAME<wbr><wbr><wbr><wbr><wbr><wbr><wbr><wbr><wbr><wbr><wbr><wbr><wbr><wbr><wbr><wbr><wbr><wbr><wbr><wbr><wbr><wbr><wbr><wbr><wbr><wbr><wbr><wbr><wbr><wbr><wbr><wbr> TYPE<wbr><wbr><wbr><wbr><wbr><wbr><wbr> VALUE<br> ------------------------------------ ----------- ------------------------------<br> sec_case_sensitive_logon<wbr><wbr><wbr><wbr><wbr><wbr><wbr><wbr><wbr><wbr><wbr><wbr> boolean<wbr><wbr><wbr><wbr> TRUE<br> SQL&gt;<br></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr>