Oracle 11g 设置用户密码大小写敏感

Oracle 11g通过一个参数设置密码大小写敏感，下面来做个试验：

Oracle 11g通过一个参数设置密码大小写敏感，，下面来做个试验：

C:\Documents and Settings\guogang>sqlplus gg_test/[email protected]_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 本文来源gao($daima.com搞@代@#码$网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/[email protected]_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/[email protected]_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/[email protected]_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

本文永久更新链接地址：

喜欢 (0)赏

[搞代码]

分享 (0)