1、操作系统版本及数据库版本 SQL> !cat /etc/issue Red Hat Enterprise Linux Server release 6.5 (Santiago) Kernel \r on an \m SQL> select * from v$version; BANNER -------------------------------------------------------------------------------- Oracle Database 11g Enterprise Edition Release 11.2.0.4.0 - 64bit Production PL/SQL Release 11.2.0.4.0 - Production CORE 11.2.0.4.0 Production TNS for Linux: Version 11.2.0.4.0 - Production NLSRTL Version 11.2.0.4.0 - Production
2、当sec_case_sensitive_logon = TRUE时，启用区分密码大小写特性 SQL> show parameter sec_case_sensitive_logon NAME TYPE VALUE ------------------------------------ ----------- ------------------------------ sec_case_sensitive_logon boolean TRUE
SQL> alter user sys identified by Oracle; User altered. SQL> alter user system identified by Oracle; User altered.
SQL> create user tt identified by Tt; User created. SQL> grant connect,resource to tt; Grant succeeded.
SQL> conn tt/tt ERROR: ORA-01017: invalid username/password; logon denied Warning: You are no longer connected to ORACLE. SQL> conn tt/Tt Connected.
SQL> conn sys/Oracle@orcl as sysdba Connected. SQL> conn sys/oracle@orcl as sysdba ERROR: ORA-01017: invalid username/password; logon denied Warning: You are no longer connected to ORACLE.
SQL> conn system/oracle ERROR: ORA-01017: invalid username/password; logon denied SQL> conn system/Oracle Connected. 可知，当sec_case_sensitive_logon = TRUE时，所有用户密码均区分大小写。
3、当sec_case_sensitive_logon = false时，不启用区分密码大小写特性 SQL> conn / as sysdba Connected. 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
SQL> conn tt/tt Connected. SQL> conn tt/Tt Connected.
SQL> conn system/OracleConnected.SQL> conn system/oracleConnected.SQL>
SQL> conn sys/Oracle@orcl as sysdba Connected. SQL> conn sys/oracle@orcl as sysdba ERROR: ORA-01017: invalid username/password; logon denied Warning: You are no longer connected to ORACLE.
由此可知，当sec_case_sensitive_logon = false时，普通用户密码是不区分大小写的，但是sys的密码还是区分大小写。