ORA-28000: the account is locked的问题
来源:互联网 发布:导弹牵引车知乎 编辑:程序博客网 时间:2024/06/10 18:39
oracle11g 做了登录失败次数failed_login_attempts限制,超过指定的次数后就会自动锁了。
解决办法:
修改参数failed_login_attempts=unlimited;
遇见问题:
SQL> conn 用户/密码
ERROR:ORA-28000: ֊»§ӑ±»̸¶¨
SQL> conn / as sysdba
Connected.
SQL> alter user 用户 account unlock;
User altered.
SQL> conn 用户/密码
Connected.
SQL> alter user 用户 account unlock;
User altered.
SQL> conn 用户/密码
Connected.
1. 查询failed_login_attempts参数默认值:
RESOURCE_NAME LIMIT
-------------------------------- ----------------------------------------
FAILED_LOGIN_ATTEMPTS 10
FAILED_LOGIN_ATTEMPTS UNLIMITED
查询FAILED_LOGIN_ATTEMPTS值为10,也就是说从第一次登录失败开始计算,连续登陆失败的次数。而不是累计失败的次数
2.修改FAILED_LOGIN_ATTEMPTS的值
SQL> alter profile default limit failed_login_attempts unlimited;
Profile altered.
SQL> select resource_name,limit from dba_profiles where resource_name='FAILED_LOGIN_ATTEMPTS';
RESOURCE_NAME LIMIT
-------------------------------- ----------------------------------------
FAILED_LOGIN_ATTEMPTS UNLIMITED
FAILED_LOGIN_ATTEMPTS UNLIMITED
0 0
- ORA-28000: The Account is locked. 问题的解决
- ORA-28000: the account is locked的问题
- ora-28000 the account is locked。
- ORA-28000: the account is locked
- ora-28000 the account is locked
- ora-28000 the account is locked
- ORA-28000: the account is locked
- ora-28000 the account is locked
- ORA-28000: the account is locked
- ORA-28000: the account is locked
- ora-28000 the account is locked。
- ORA-28000: the account is locked
- ORA-28000: the account is locked
- ORA-28000 the account is locked
- ORA-28000: the account is locked
- ORA-28000: the account is locked
- ORA-28000: the account is locked
- ORA-28000: the account is locked解决办法
- leetcode Compare Version Numbers
- 观察者模式
- HashMap常见并发问题
- 性能监控Ganglia搭建
- Service 官方详解(从官方文档翻译而来)
- ORA-28000: the account is locked的问题
- ios8中用swift实现文本输入框适应键盘高度变化
- app-framework学习--公用加载、刷新
- 俩种将ppt转换成pdf的方法
- enum枚举与int string类型之间的相互转换
- 怎样扩展摩托罗拉的手机内存
- Service中onStartCommand的返回值问题
- 闲来无事的脚本编程
- DVWA平台熟悉以及利用BurpSuite进行暴力猜解