Search code examples
oracle

ORA-28001: The password has expired

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?

Solution

  • I have fixed the problem, just need to check:

    open_mode from v$database

    and then check:

    check account_status to get mode information

    and then use:

    alter user myuser identified by mynewpassword account unlock;