oracle 11g 设置用户密码大小写敏感测试
11g通过一个参数设置密码大小写敏感,下面来做个试验:
C:\DocumentsandSettings\guogang>sqlplusgg_test/gg_test@10.10.15.25_gg
SQL*Plus:Release10.2.0.1.0-Productionon星期一8月417:54:192014
Copyright(c)1982,2005,Oracle.Allrightsreserved.
连接到:
OracleDatabase11gEnterpriseEditionRelease11.2.0.1.0-64bitProduction
WiththePartitioning,OLAP,DataMiningandRealApplicationTestingoptions
SQL>select*fromv$version;
BANNER
--------------------------------------------------------------------------------
OracleDatabase11gEnterpriseEditionRelease11.2.0.1.0-64bitProduction
PL/SQLRelease11.2.0.1.0-Production
CORE11.2.0.1.0Production
TNSforLinux:Version11.2.0.1.0-Production
NLSRTLVersion11.2.0.1.0-Production
SQL>showparametersec_case_sensitive_logon
NAMETYPEVALUE
-----------------------------------------------------------------------------
sec_case_sensitive_logonbooleanTRUE
C:\DocumentsandSettings\guogang>sqlplusgg_test/gg_tesT@10.10.15.25_gg
SQL*Plus:Release10.2.0.1.0-Productionon星期一8月417:54:062014
Copyright(c)1982,2005,Oracle.Allrightsreserved.
ERROR:
ORA-01017:invalidusername/password;logondenied
请输入用户名:
C:\DocumentsandSettings\guogang>sqlplusgg_test/gg_test@10.10.15.25_gg
SQL*Plus:Release10.2.0.1.0-Productionon星期一8月417:52:352014
Copyright(c)1982,2005,Oracle.Allrightsreserved.
连接到:
OracleDatabase11gEnterpriseEditionRelease11.2.0.1.0-64bitProduction
WiththePartitioning,OLAP,DataMiningandRealApplicationTestingoptions
SQL>altersystemsetsec_case_sensitive_logon=false;
系统已更改。
SQL>从OracleDatabase11gEnterpriseEditionRelease11.2.0.1.0-64bitProduction
WiththePartitioning,OLAP,DataMiningandRealApplicationTestingoptions断开
C:\DocumentsandSettings\guogang>sqlplusgg_test/gg_tesT@10.10.15.25_gg
SQL*Plus:Release10.2.0.1.0-Productionon星期一8月417:53:482014
Copyright(c)1982,2005,Oracle.Allrightsreserved.
连接到:
OracleDatabase11gEnterpriseEditionRelease11.2.0.1.0-64bitProduction
WiththePartitioning,OLAP,DataMiningandRealApplicationTestingoptions
SQL>showparametersec_case_sensitive_logon
NAMETYPEVALUE
-----------------------------------------------------------------------------
sec_case_sensitive_logonbooleanFALSE