-- 密码敏感参数,是一个布尔参数,通过修改参数,使用户在输入密码登录时可以不区分大小写
-- 系统默认是 TRUE 状态
-- 修改为 FALSE 之后,本地登录用 SYS 用户登录发现,这个参数对于拥有 SYSDBA 用户权限的用户没有效果
-- 把参数恢复默认
-- 创建一个测试用户,测试参数
-- 修改参数为 FALSE,连接用户测试
-- 通过测试,通过连接字符串远程登录时,在不使用 SYSDBA 身份登录时是没有问题的
-- 系统默认是 TRUE 状态
点击(此处)折叠或打开
-
SYS@RAC1> show parameter case_sensitive_logon
-
-
NAME TYPE VALUE
-
------------------------------------ ----------- ------------------------------
- sec_case_sensitive_logon boolean TRUE
点击(此处)折叠或打开
-
SYS@RAC1> alter system set sec_case_sensitive_logon = false;
-
-
System altered.
-
-
SYS@RAC1> show parameter case_sensitive_logon
-
-
NAME TYPE VALUE
-
------------------------------------ ----------- ------------------------------
-
sec_case_sensitive_logon boolean FALSE
-
SYS@RAC1> conn sys/OraclE as sysdba
- Connected.
点击(此处)折叠或打开
-
SYS@RAC1> show parameter case_sensitive_logon
-
-
NAME TYPE VALUE
-
------------------------------------ ----------- ------------------------------
- sec_case_sensitive_logon boolean TRUE
-- 创建一个测试用户,测试参数
点击(此处)折叠或打开
-
SYS@RAC1> create user test identified by oracle account unlock;
-
-
User created.
-
-
SYS@RAC1> grant connect to test;
-
-
Grant succeeded.
-
- SYS@RAC1> conn test/Oracle
- ERROR:
- ORA-01017: invalid username/password; logon denied
-
-
Warning: You are no longer connected to ORACLE.
点击(此处)折叠或打开
-
SYS@RAC1> conn / as sysdba
-
Connected.
-
SYS@RAC1> alter system set sec_case_sensitive_logon = false;
-
-
System altered.
-
-
SYS@RAC1> conn test/Oracle
- Connected.
点击(此处)折叠或打开
-
[oracle@rac1 admin]$ sqlplus system/OraclE@rac as sysdba
-
-
SQL*Plus: Release 11.2.0.4.0 Production on Thu Aug 18 22:28:13 2016
-
-
Copyright (c) 1982, 2013, Oracle. All rights reserved.
-
-
ERROR:
-
ORA-01017: invalid username/password; logon denied
-
-
-
Enter user-name:
-
ERROR:
-
ORA-01017: invalid username/password; logon denied
-
-
-
Enter user-name:
-
ERROR:
-
ORA-01017: invalid username/password; logon denied
-
-
-
SP2-0157: unable to CONNECT to ORACLE after 3 attempts, exiting SQL*Plus
-
[oracle@rac1 admin]$
-
[oracle@rac1 admin]$ sqlplus system/OracLe@rac
-
-
SQL*Plus: Release 11.2.0.4.0 Production on Thu Aug 18 22:28:27 2016
-
-
Copyright (c) 1982, 2013, Oracle. All rights reserved.
-
-
-
Connected to:
-
Oracle Database 11g Enterprise Edition Release 11.2.0.4.0 - 64bit Production
-
With the Partitioning, Real Application Clusters, Automatic Storage Management, OLAP,
-
Data Mining and Real Application Testing options
-
- SYSTEM@rac>
来自 “ ITPUB博客 ” ，链接：https://blog.itpub.net/31369239/viewspace-2123702/ ，如需转载，请注明出处，否则将追究法律责任。
上一篇：
service_names 参数更改方法
下一篇：
失效对象编译
请登录后发表评论
登录
全部评论
