oracle出现错误提示：ORA-28000: the account is locked。
2021-11-01出现错误提示：ORA-28000: the account is locked。
1、select * from dba_profiles where RESOURCE_NAME='FAILED_LOGIN_ATTEMPTS';
PROFILE RESOURCE_NAME RESOURCE_TYPE LIMIT
-------------------- ------------------------------ ------------------------ --------------------
DEFAULT FAILED_LOGIN_ATTEMPTS PASSWORD 10
MONITORING_PROFILE FAILED_LOGIN_ATTEMPTS PASSWORD UNLIMITED
2、alter profile default limit failed_login_attempts unlimited;
3、alter user [username] account unlock;
分类：数据库 | 标签： |