ORA-01017: invalid username/password; logon denied

Recommended for you: Get network issues from WhatsUp Gold. Not end users.

Oracle began to support the case for user code from 11g. Mainly due to a parameter:

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 said the case authentication enabled,

[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

The parameters for the dynamic parameters.

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 does not exist in this parameter.

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!

Recommended from our users: Dynamic Network Monitoring from WhatsUp Gold from IPSwitch. Free Download

Posted by Peter at December 06, 2013 - 5:40 PM