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笔记

PageGen

AI页面生成器，支持通过文本、图像、文件和URL一键生成网页。

下载

在CentOS 6.4下安装Oracle 11gR2(x64)

Oracle 11gR2 在VMWare虚拟机中安装步骤

Debian 下 安装 Oracle 11g XE R2

本文永久更新链接地址：