oracle用户被锁定the account is locked的解决办法
账户频繁被锁住 ora-280000 the account is locked
修改default profiles中的failed_login_attempts参数设置
------------以下以as sysdba进入-----
1 desc dba_profiles; --查询属性文件
Name Null? Type
----------------------------------------- -------- -------------------
PROFILE NOT NULL VARCHAR2(30)
RESOURCE_NAME NOT NULL VARCHAR2(32)
RESOURCE_TYPE VARCHAR2(8)
LIMIT VARCHAR2(40)
2 select resource_name, limit from dba_profiles where resource_name = 'FAILED_LOGIN_ATTEMPTS'; --查询
RESOURCE_NAME LIMIT
-------------------------------- -------------------------------------
FAILED_LOGIN_ATTEMPTS 10
FAILED_LOGIN_ATTEMPTS UNLIMITED
3 修改属性文件
alter profile default limit failed_login_attempts unlimited;
4 解锁
alter user username account unlock;
