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;

分类:数据库 | 标签: |

相关日志

评论被关闭!