Oracle 11g通过一个参数设置密码大小写敏感，下面来做个试验：oracle 11g通过一个参数设置密码大小写敏感，，下面来做个试验：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 星期一 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/gg_tesT@10.10.15.25_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/gg_test@10.10.15.25_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/gg_tesT@10.10.15.25_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 Oracle 11g 在RedHat Linux 5.8_x64平台的安装手册Linux-6-64下安装Oracle 12C笔记在CentOS 6.4下安装Oracle 11gR2(x64) Oracle 11gR2 在VMWare虚拟机中安装步骤Debian 下 安装 Oracle 11g XE R2