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 gt  connect   as SYSDBA Connected   SQL gt  SELECT username  account status FROM dba users WHERE ACCOUNT STATUS LIKE   EXPIRED     SQL gt  ALTER USER system IDENTIFIED BY system           User altered   SQL gt  ALTER USER system ACCOUNT UNLOCK  User altered   SQL gt  ALTER PROFILE DEFAULT LIMIT PASSWORD LIFE TIME UNLIMITED  Profile altered   SQL gt  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

User · Answer

Check  PASSWORD LIFE TIME  by   Sql   select   from dba profiles   Set to Never expire  Sql  ALTER PROFILE DEFAULT LIMIT PASSWORD LIFE TIME UNLIMITED   Then reset the password of locked user

User · Answer

Just go to the machine where your database resides  search windows - gt  search SqlPlus Type the user name  then type password  it will prompt you to give new password  On providing new password  it will say successfully changed the password

User · Answer

C   gt sqlplus  nolog SQL gt  connect   as SYSDBA SQL gt  select   from dba profiles  SQL gt  alter profile default limit password life time unlimited  SQL gt  alter user database name identified by new password  SQL gt  commit  SQL gt  exit

User · Answer

ALTER PROFILE DEFAULT LIMIT PASSWORD LIFE TIME UNLIMITED  alter user EPUSR100 identified by EPUSR100 account unlock  commit

User · Answer

you are in wrong cdb pdb so connect to right pdb

User · Answer

I had same problem  i am trying to login database it appear a message with   quot ORA-28001  The password has expired quot    I have fixed the problem simple steps 1 open command prompt 2 type sqlplus 3 It will ask Enter Password  you can give old password  it will show password has expired ORA-28001 4 It will ask new password and retype password 5 It will change with new password 6 Go to the sql database and try to connect with new password  it will connect

User · Answer

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

User · Answer

I had same problem even after changing the password  it wasn t getting reflected in SQLDEVELOPER   Atlast following solved my problem     Open Command Propmt Type sqlplus login as sysdba Run following command       alter user USERNAME identified by NEW PASSWORD

User · Answer

Try to connect with the users in SQL Plus  whose password has expired  it will prompt for the new password  Enter the new password and confirm password   It will work  SQL Plus output image

[oracle] ORA-28001: The password has expired

Examples related to oracle