第一次使用 Oracle 11g 是冲着它的 interval 分区去的，当把应用迁过去之后发现登录不了，死活说密码错误，当时应急的做法是把密码改纯数字，今天有空好好地搜索了一下，才发现“密码大小写敏感”是 Oracle 11g 才引入的新特性，对应的参数是 sec_case_sensitive_logon ，看以下的实验过程：
sys@FWDB SQL> show parameter sec_case_sensitive_logon NAME TYPE VALUE ------------------------------------ ----------- ------------------------------ sec_case_sensitive_logon boolean TRUE sys@FWDB SQL> alter user scott account unlock ; User altered. Elapsed: 00:00:00.01 sys@FWDB SQL> alter user scott identified by tIger; User altered. Elapsed: 00:00:00.00 sys@FWDB SQL> connect scott/tiger ERROR: ORA-01017: invalid username/password; logon denied Warning: You are no longer connected to ORACLE. sys@FWDB SQL> connect scott/tIger Connected. scott@FWDB SQL> connect / as sysdba Connected. sys@FWDB SQL> alter system set sec_case_sensitive_logon=false; System altered. Elapsed: 00:00:00.01 sys@FWDB SQL> connect scott/tiger Connected. scott@FWDB SQL> connect scott/tIger Connected.
说真的，我不喜欢这个新特性。