ORA-28001:密码已过期 [英] ORA-28001: The password has expired

问题描述

我在Oracle中遇到有关我的数据库的问题，当我打开数据库时，它显示一条消息，内容为:"ORA-28001:密码已过期"

I'm facing the problem about my database in Oracle, When I opened my database, it appear a message with: "ORA-28001: The password has expired"

我已经用一些帐户更新了我的帐户:

I have updated my account with somes:

sqlplus /nolog
SQL> connect / as SYSDBA
Connected.

SQL> SELECT username, account_status FROM dba_users WHERE ACCOUNT_STATUS LIKE '%EXPIRED%';

SQL> ALTER USER system IDENTIFIED BY system;         
User altered.

SQL> ALTER USER system ACCOUNT UNLOCK;
User altered.

SQL> ALTER PROFILE DEFAULT LIMIT PASSWORD_LIFE_TIME UNLIMITED;
Profile altered.

SQL> exit

我检查发现，我的帐户"system"具有OPEN，但是我在Oracle SQL Developer上打开了该帐户，但它仍具有警报:

I check and see that, my account: 'system' has OPEN, but I open it on Oracle SQL Developer, it still have alert:

ORA-28001: The password has expired

我已经引用了很多链接，但是仍然存在问题，如何解决?

I have refered very much links but it still same the problem, how to fix this?

推荐答案

我已经解决了这个问题，只需检查一下即可:

I have fixed the problem, just need to check:

open_mode from v$database

然后检查:

check account_status to get mode information

然后使用:

alter user myuser identified by mynewpassword account unlock;

这篇关于ORA-28001:密码已过期的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！