11g通過(guò)一個(gè)參數(shù)設(shè)置密碼大小寫(xiě)敏感，下面來(lái)做個(gè)試驗(yàn)：
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
請(qǐng)輸入用戶(hù)名:
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;
系統(tǒng)已更改。
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 斷開(kāi)
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
標(biāo)簽：蘇州 玉樹(shù) 來(lái)賓 大興安嶺 遼寧 棗莊 長(zhǎng)沙 贛州
巨人網(wǎng)絡(luò)通訊聲明：本文標(biāo)題《oracle 11g 設(shè)置用戶(hù)密碼大小寫(xiě)敏感測(cè)試》，本文關(guān)鍵詞 oracle,11g,設(shè)置,用戶(hù),密碼,；如發(fā)現(xiàn)本文內(nèi)容存在版權(quán)問(wèn)題，煩請(qǐng)?zhí)峁┫嚓P(guān)信息告之我們，我們將及時(shí)溝通與處理。本站內(nèi)容系統(tǒng)采集于網(wǎng)絡(luò)，涉及言論、版權(quán)與本站無(wú)關(guān)。
