ORA-28001: The password has expired

Question

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 

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?

Answer 1

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