Oracle 11g 設定使用者密碼大小寫敏感

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