本文介绍了ORA-28001:密码已过期的处理方法，对大家解决问题具有一定的参考价值，需要的朋友们下面随着小编来一起学习吧！
问题描述
我在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:密码已过期的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持！