How to solve Oracle Database Error 28001 (ora-28001)

Oracle Error Code
   ora-28001

Description
   the password has expired

Cause
   The user's account has expired and the password needs to be changed
How to Solve
   change the password or contact the DBA
Posts About Oracle Database Error ORA-28004
ORA User:
To mark a user's account as expired, use the following query.

SQL>alter user aUser identified by qwerty password expire;
User altered.

Then, try to connect. You will see ora-28001 error.

SQL> conn aUser/qwerty
ERROR:
ORA-28001: the password has expired

Finally, it will prompt you a change password dialog.

Changing password for aUser
New password:
Retype new password:
Password changed
Connected.

buggedcoder:
Is there any way to reset the expired Oracle password at login time i.e. 
without having Oracle connection beforehand?


Do you have question or do you know about solution ?

Share with us. (No registration required)
  
Your Name
Question, comment or solution
Similar Errors
  ORA-28000    ORA-28001    ORA-28002    ORA-28003    ORA-28004  Others

Main Page      Contact Us      Tools & Softwares      Server Monitoring Softwares