JavaMadeSoEasy.com (JMSE): Solved : ORA-28001: the password has expired

Contents of page >

1) First connect to sqlplus >
2) See list of all users and their account_status (open, locked or expired), lock and expiry date in oracle >
3) Change password of user in oracle>
4) Set profile password for lifetime in oracle>
5) Unlock user account in oracle >

In this tutorial we will solve : ORA-28001: the password has expired.

1) First connect to sqlplus >

Step 1 : type sqlplus

Step 2 : type user-name as connect /as sysdba

Step 3 : password not needed in this case.

C:\Users\ankitmittal01>sqlplus

SQL*Plus: Release 11.2.0.1.0 Production on Sun Jan 29 02

Enter user-name: connect /as sysdba

Enter password:

Connected to:

Oracle Database 11g Enterprise Edition Release 11.2.0.1.

2) See list of all users and their account_status (open, locked or expired), lock and expiry date in oracle >

SQL> select USERNAME,ACCOUNT_STATUS, LOCK_DATE, EXPIRY_DATE from DBA_USERS;

3) Change password of user in oracle>

SQL> alter user ANKIT IDENTIFIED BY ora123;

User altered.

Where -

ANKIT is the user_name and

ora123 is the new password.

4) Set profile password for lifetime in oracle>

SQL> ALTER PROFILE DEFAULT LIMIT PASSWORD_LIFE_TIME UNLIMITED;

Profile altered.

5) Unlock user account in oracle >

SQL> alter user ANKIT ACCOUNT UNLOCK;

User altered.

Where -

ANKIT is the user_name.

So, In this tutorial we solved : ORA-28001: the password has expired.

Having any doubt? or you liked the tutorial! Please comment in below section.

Please express your love by liking JavaMadeSoEasy.com (JMSE) on facebook, following on google+ or Twitter.