11g通过一个参数设置密码大小写敏感，下面来做个试验：

C:/Documents and Settings/guogang>sqlplus gg_test/[email protected]_gg
SQL*Plus: Release 10.2.0.1.0 – Production on 星期一 8月 4 17:54:19 2014
Copyright (c) 1982, 2005, Oracle. All rights reserved.
连接到:
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 星期一 8月 4 17:54:06 2014
Copyright (c) 1982, 2005, Oracle. All rights reserved.
ERROR:
ORA-01017: invalid username/password; logon denied
请输入用户名:

C:/Documents and Settings/guogang>sqlplus gg_test/[email protected]_gg
SQL*Plus: Release 10.2.0.1.0 – Production on 星期一 8月 4 17:52:35 2014
Copyright (c) 1982, 2005, Oracle. All rights reserved.
连接到:
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;
系统已更改。

SQL> 从 Oracle Database 11g Enterprise Edition Release 11.2.0.1.0 – 64bit Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options 断开

C:/Documents and Settings/guogang>sqlplus gg_test/[email protected]_gg
SQL*Plus: Release 10.2.0.1.0 – Production on 星期一 8月 4 17:53:48 2014
Copyright (c) 1982, 2005, Oracle. All rights reserved.
连接到:
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

声明：本站（华域联盟www.cnhackhy.com）所有文章，如无特殊说明或标注，均为本站原创发布。任何个人或组织，在未征得本站同意时，禁止复制、盗用、采集、发布本站内容到任何网站、书籍等各类媒体平台。如若本站内容侵犯了原著者的合法权益，可联系我们进行处理。