ORA-28000 错误的原因是什么？

1. 登录失败次数过多（超过 FAILED_LOGIN_ATTEMPTS 配置文件限制） 2. DBA 手动锁定了账户：ALTER USER username ACCOUNT LOCK; 3. 密码过期策略触发了账户锁定

ORA 28000｜Oracle 错误码速查

用户账户已被锁定，可能是 DBA 手动锁定或超过 FAILED_LOGIN_ATTEMPTS 后自动锁定。

1解锁账户：ALTER USER username ACCOUNT UNLOCK;
2检查并调整配置文件：SELECT resource_name, limit FROM dba_profiles WHERE profile = 'DEFAULT' AND resource_name = 'FAILED_LOGIN_ATTEMPTS';
3调查失败登录尝试的来源

SELECT username, account_status, lock_date FROM dba_users WHERE username = UPPER('USER');

SELECT resource_name, limit FROM dba_profiles WHERE profile = (SELECT profile FROM dba_users WHERE username = UPPER('USER'));

#account-locked#security#login#profile