Wednesday, September 23, 2009

Expired and Locked DB account

SQL> select username,ACCOUNT_STATUS from dba_users where USERNAME='ABCD';
    
    USERNAME                       ACCOUNT_STATUS
    ------------------------------ --------------------------------
    ABCD                          EXPIRED & LOCKED
    

To resolve i gave following command

1. Check the current password :

SQL>  select username,password from dba_users where username='ABCD';

USERNAME                       PASSWORD
------------------------------ ------------------------------
ABCD                          8B0354E43FEE9F31




2. alter user  abcd account unlock;
3. alter user identified by user abcd ;


4. Reverted the password :

SQL> alter user ABCD identified by values '8B0354E43FEE9F31';
SQL> select username,ACCOUNT_STATUS from dba_users where USERNAME='ABCD';
    
    USERNAME                       ACCOUNT_STATUS
    ------------------------------ --------------------------------
    ABCD                            OPEN
    
    

No comments: