The password life of the applications as well as operating systems are limited. To enabling more security we are getting some alert in daily life that we need to chage our passwords regularly on fixed inerval.
If we don’t change before the applications limitation, it will expired.
The other day when I was opening SQL Developer, I got message popup “ORA-28001: The password has expired”.
To fix this issue we need to connect Oracle with SYSDBA OR SYSTEM user and do the following things.
STEP 1: Check the users status.
[sql]
SELECT USERNAME,ACCOUNT_STATUS FROM DBA_USERS;
USERNAME ACCOUNT_STATUS
———————————————–
ANONYMOUS OPEN
SYSTEM OPEN
SYS OPEN
LMENARIA EXPIRED & LOCKED
[/sql]
STEP 2: Set the password of locked user.
[sql]
ALTER USER LMENARIA IDENTIFIED BY pa55word;
[/sql]
STEP 3: Unlock the user account.
[sql]
ALTER USER LMENARIA ACCOUNT UNLOCK;
[/sql]
STEP 4: Check the user status again is not locked anymore.
[sql]
SELECT USERNAME,ACCOUNT_STATUS FROM DBA_USERS;
USERNAME ACCOUNT_STATUS
—————————————–
ANONYMOUS OPEN
SYSTEM OPEN
SYS OPEN
LMENARIA OPEN
[/sql]