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;