alter system set sec_case_sensitive_logon=false scope=both;
sec_case_sensitive_logon 哦……第一次听说这个参数 可是我试了试 为什么改不了呢 SQL> alter system set sec_case_sensitive_logon=true scope=both; alter system set sec_case_sensitive_logon=true scope=both * ERROR at line 1: ORA-02065: illegal option for ALTER SYSTEM SQL> alter system set sec_case_sensitive_logon=true scope=spfile; alter system set sec_case_sensitive_logon=true scope=spfile * ERROR at line 1: ORA-02065: illegal option for ALTER SYSTEM SQL> alter system set sec_case_sensitive_logon=true scope=momery; alter system set sec_case_sensitive_logon=true scope=momery * ERROR at line 1: ORA-02065: illegal option for ALTER SYSTEM SQL>而且我登录的时候用户名一直是大小写不敏感的SQL> show parameter sec_case --没有结果 SQL> conn scott/tiger Connected. SQL> conn SCOTT/TIGER Connected.我的版本是10.2.0.1.0 OS是WINDOWS XP SP3
哦……第一次听说这个参数
可是我试了试 为什么改不了呢
SQL> alter system set sec_case_sensitive_logon=true scope=both;
alter system set sec_case_sensitive_logon=true scope=both
*
ERROR at line 1:
ORA-02065: illegal option for ALTER SYSTEM
SQL> alter system set sec_case_sensitive_logon=true scope=spfile;
alter system set sec_case_sensitive_logon=true scope=spfile
*
ERROR at line 1:
ORA-02065: illegal option for ALTER SYSTEM
SQL> alter system set sec_case_sensitive_logon=true scope=momery;
alter system set sec_case_sensitive_logon=true scope=momery
*
ERROR at line 1:
ORA-02065: illegal option for ALTER SYSTEM
SQL>而且我登录的时候用户名一直是大小写不敏感的SQL> show parameter sec_case
--没有结果
SQL> conn scott/tiger
Connected.
SQL> conn SCOTT/TIGER
Connected.我的版本是10.2.0.1.0 OS是WINDOWS XP SP3
这个是设置密码是否区分大小写的
前面给的那个链接是错的应该是这个http://blog.csdn.net/wh62592855/archive/2009/09/24/4589068.aspx