oracle - ORA-28001 : The password has expired

Question

我在 Oracle 中遇到了有关数据库的问题，当我打开数据库时，出现一条消息:“ORA-28001:密码已过期”

我已经更新了我的帐户:

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”已打开，但我在 Oracle SQL Developer 上打开它，它仍然有警报:

ORA-28001: The password has expired

我引用了很多链接，但问题仍然存在，如何解决这个问题？

Answer 1

ALTER PROFILE DEFAULT LIMIT PASSWORD_LIFE_TIME UNLIMITED;
alter user EPUSR100 identified by EPUSR100 account unlock;
commit;