关闭

ORA-01017: invalid username/password; logon denied

1068人阅读 评论(0) 收藏 举报
分类:

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!

 

0
0

查看评论
* 以上用户言论只代表其个人观点,不代表CSDN网站的观点或立场
    个人资料
    • 访问:269438次
    • 积分:4564
    • 等级:
    • 排名:第6398名
    • 原创:192篇
    • 转载:7篇
    • 译文:1篇
    • 评论:38条
    国内链接
    最新评论