11g use one parameter to set the password case sensitivity, below to do an experiment:
C:\Documents and Settings\guogang>sqlplus Gg_test/[email Protected]_gg
Sql*plus:release 10.2.0.1.0-production on Monday August 4 17:54:19 2014
Copyright (c) 1982, 2005, Oracle. All rights reserved.
Connect to:
Oracle Database 11g Enterprise Edition Release 11.2.0.1.0-64bit Production
With the partitioning, OLAP, Data Mining and Real application testing options
Sql> select * from V$version;
BANNER
--------------------------------------------------------------------------------
Oracle Database 11g Enterprise Edition Release 11.2.0.1.0-64bit Production
PL/SQL Release 11.2.0.1.0-production
CORE 11.2.0.1.0 Production
TNS for Linux:version 11.2.0.1.0-production
Nlsrtl Version 11.2.0.1.0-production
Sql> Show Parameter Sec_case_sensitive_logon
NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
Sec_case_sensitive_logon Boolean TRUE
C:\Documents and Settings\guogang>sqlplus gg_test/[email protected]_gg
Sql*plus:release 10.2.0.1.0-production on Monday August 4 17:54:06 2014
Copyright (c) 1982, 2005, Oracle. All rights reserved.
ERROR:
Ora-01017:invalid Username/password; Logon denied
Please enter user name:
C:\Documents and Settings\guogang>sqlplus Gg_test/[email Protected]_gg
Sql*plus:release 10.2.0.1.0-production on Monday August 4 17:52:35 2014
Copyright (c) 1982, 2005, Oracle. All rights reserved.
Connect to:
Oracle Database 11g Enterprise Edition Release 11.2.0.1.0-64bit Production
With the partitioning, OLAP, Data Mining and Real application testing options
Sql> alter system set SEC_CASE_SENSITIVE_LOGON=FALSE;
The system has changed.
Sql> from Oracle Database 11g Enterprise Edition Release 11.2.0.1.0-64bit Production
With the partitioning, OLAP, Data Mining and Real application testing options Disconnect
C:\Documents and Settings\guogang>sqlplus gg_test/gg_test@10.10.15.25_gg
Sql*plus:release 10.2.0.1.0-production on Monday August 4 17:53:48 2014
Copyright (c) 1982, 2005, Oracle. All rights reserved.
Connect to:
Oracle Database 11g Enterprise Edition Release 11.2.0.1.0-64bit Production
With the partitioning, OLAP, Data Mining and Real application testing options
Sql> Show Parameter Sec_case_sensitive_logon
NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
Sec_case_sensitive_logon Boolean FALSE
