ORA-28001: the password has expired

| By Webner

That’s the error you get for oracle user for whom password is expired.

One Solution – Connect using sqlplus to set new password, you can even use the same password you had earlier.

$ sqlplus

SQL*Plus: Release Production on Mon Dec 13 01:12:07 2010

Copyright (c) 1982, 2009, Oracle. All rights reserved.

Enter user-name: myuser
Enter password:
ORA-28001: the password has expired

Changing password for myuser
New password:
Retype new password:
Password changed

Connected to:
Oracle Database 11g Release – 64bit Production

Leave a Reply

Your email address will not be published. Required fields are marked *