ORA-01017: invalid username/password; logon denied

最新推荐文章于 2025-05-19 09:15:21 发布

原创最新推荐文章于 2025-05-19 09:15:21 发布 · 1.5k 阅读

0 ·

CC 4.0 BY-SA版权

ORACLE之基本术语知识专栏收录该内容

25 篇文章

订阅专栏

本文介绍Oracle 11g中如何通过sec_case_sensitive_logon参数控制用户登录时密码的大小写敏感性，并展示了如何动态修改此参数。

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

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

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!