ORA-01017: invalid username/password; logon denied

bgvf

oracle从11g开始对用户密码支持大小写。主要得力于一个参数：

SQL> @getsp.sql
Enter value for par: sec_case

KSPPINM                                            KSPPSTVL             KSPPDESC
-------------------------------------------------- -------------------- ------------------------------------------------------------
sec_case_sensitive_logon                           TRUE                 case sensitive password enabled for logon

SQL>

为true则表示启用大小写认证，

[oracle@oracle-one admin]$ strace -o sqlplus.log sqlplus rhys/root@RHYS

SQL*Plus: Release 11.2.0.4.0 Production on Thu Dec 5 15:34:49 2013

Copyright (c) 1982, 2013, Oracle.  All rights reserved.

ERROR:
ORA-01017: invalid username/password; logon denied

该参数为动态参数。

SQL>
SQL> alter system set sec_case_sensitive_logon=false;

System altered.

SQL>

[oracle@oracle-one admin]$ strace -o sqlplus.log sqlplus rhys/root@RHYS

SQL*Plus: Release 11.2.0.4.0 Production on Thu Dec 5 15:40:14 2013

Copyright (c) 1982, 2013, Oracle.  All rights reserved.

Connected to:
Oracle Database 11g Enterprise Edition Release 11.2.0.4.0 - 64bit Production
With the Partitioning, Automatic Storage Management, OLAP, Data Mining
and Real Application Testing options

SQL> exit

10g则不存在该参数。

15:54:09 sys>select banner from v$version;

BANNER
----------------------------------------------------------------
Oracle Database 10g Enterprise Edition Release 10.2.0.5.0 - 64bi
PL/SQL Release 10.2.0.5.0 - Production
CORE    10.2.0.5.0      Production
TNS for HPUX: Version 10.2.0.5.0 - Production
NLSRTL Version 10.2.0.5.0 - Production

15:54:15 sys>show parameter sec_case_sensitive_logon
15:54:26 sys>

That's all!

dongfangho

虚伪的你，使我过上虚伪的生活。