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;