ORA-01017: invalid username/password; logon denied

原创 2013年12月05日 15:55:41

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!

 

相关文章推荐

java中JDBCf访问数据库时报java.sql.SQLException: ORA-01017: invalid username/password; logon denied的错误

java中JDBCf访问数据库时报java.sql.SQLException: ORA-01017: invalid username/password; logon denied的错误...

ORA-01017: invalid username/password; logon denied

ORACLE 10.2.0.1中创建到 Oracle 11.2.0.3.0 的DBLINK 时遇到下述错误: ORA-01017: invalid username/password; logon ...

启动ArcSDE服务提示:ORA-01017:invalid username/password;logon denied

转自:http://blog.csdn.net/linghe301/article/details/8506198 本文适用于:经常使用ArcSDE服务的用户、Windows操作系统、Ora...

EMCA fails with error "ORA-01017: invalid username/password; logon denied"

Creation of dbcontrol repository fails when execute $ emca -config dbcontrol -repos createWith error...

invalid username/password logon denied

在使用oracle数据库中的sql Develop中,用scott登陆创建连接时报错的解决办法:                         1、先要确保自己输入没错,用户名一...

scott 用户在PLSQL Develope上登录时提示错误:ORA-01017: invalid username/password的解决方案

scott 用户在PLSQL Develope上登录时提示错误:ORA-01017: invalid username/password的几种原因,这位博主写的很好,贴地址 http://blog....

lots of invalid username/password lead to login hang(library cache lock)

很早之前就遇到过ji

WCF Rest UserName Password

  • 2012年02月02日 10:18
  • 224KB
  • 下载

用HttpPost登陆验证时,用户名和密码放在请求头部header中的处理方法,形式为Authorization: username password。

 post.setHeader("Authorization", "your token"); 这里主要是要
内容举报
返回顶部
收藏助手
不良信息举报
您举报文章:ORA-01017: invalid username/password; logon denied
举报原因:
原因补充:

(最多只允许输入30个字)