I have installed oracle11g couple of months back and set up users, after some days users were complaining about
ORA-28001: the password has expired
the users password were expired and in their grace period.
Here is what it looked like:
SQL> select username,account_status,expiry_date from dba_users;
USERNAME ACCOUNT_STATUS EXPIRY_DATE
—————————— ———————— ————
SELFLOAD OPEN
PROD OPEN
TECHNO EXPIRED(GRACE) 11-JAN-11
SCOTT EXPIRED & LOCKED 08-JUL-10
I tried to unlock the accounts but that didnít work. So here is what i did:
SQL> select password from sys.user$ where name=’TECHNO’;
PASSWORD
7A0F2B316C212D67
This gave me the hashed password for the user TECHNO
Then again set the same password for user TECHNO:
SYS> alter user TECHNO identified by values ‘7A0F2B316C212D67’;
Now the account is open again and not expired or in grace period:
SQL> select username,account_status,expiry_date from dba_users;
USERNAME ACCOUNT_STATUS EXPIRY_DATE
———————- ——————- ————–
SELFLOAD OPEN
PROD OPEN
TECHNO OPEN
SCOTT EXPIRED & LOCKED 08-JUL-10
SQL> ALTER PROFILE DEFAULT LIMIT PASSWORD_LIFE_TIME UNLIMITED;
Profile altered.
