ORA-28000: 帐户被锁定错误频繁出现

问题描述

我收到错误:

 ORA-28000: the account is locked

这是数据库问题吗?当我使用命令 ALTER USER username ACCOUNT UNLOCK 暂时解锁用户帐户时，它会正常.然后过了一段时间，同样的帐户锁定再次发生.

Is this a DB Issue? When I unlock user account using the command ALTER USER username ACCOUNT UNLOCK temporarily it will be OK. Then after some time the same account lock happens again.

使用的数据库是oracle XE

The database using is oracle XE

其他人有同样的问题吗?

推荐答案

问题的原因之一可能是您使用的密码策略.

One of the reasons of your problem could be the password policy you are using.

如果您没有这样的政策，请使用以下查询检查 DEFAULT 配置文件中密码属性的设置:

And if there is no such policy of yours then check your settings for the password properties in the DEFAULT profile with the following query:

SELECT resource_name, limit
FROM dba_profiles
WHERE profile = 'DEFAULT'
AND resource_type = 'PASSWORD';

如果需要，您只需使用以下查询将 PASSWORD_LIFE_TIME 更改为 unlimited:

And If required, you just need to change the PASSWORD_LIFE_TIME to unlimited with the following query:

ALTER PROFILE DEFAULT LIMIT PASSWORD_LIFE_TIME UNLIMITED;

这个链接可能会有所帮助为您解决问题.

And this Link might be helpful for your problem.

这篇关于ORA-28000: 帐户被锁定错误频繁出现的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持！