ORA-28000: the account is locked !!

This error message will display when an User Account is locked.You have to unlock the account to before reusing that user again.


You can also set FAILED_LOGIN_ATTEMPTS Parameter to Unlimited to disable account locking  due to failed login attempts in future.



select * from dba_users where USERNAME = 'user_name'

ALTER USER <user_name> ACCOUNT UNLOCK;

View Account Status of a User:

SELECT USERNAME,ACCOUNT_STATUS FROM DBA_USERS WHERE USERNAME='SCOTT';

View Profile Assigned to a User:

SELECT PROFILE FROM DBA_USERS WHERE USERNAME='SCOTT';

View Limits Set for the Profile: 

SELECT RESOURCE_NAME, LIMIT FROM DBA_PROFILES WHERE PROFILE='DEFAULT';

 Alter FAILED_LOGIN_ATTEMPTS Parameter: 
ALTER PROFILE DEFAULT LIMIT FAILED_LOGIN_ATTEMPTS UNLIMITED;



Alter PASSWORD_LIFE_TIME Parameter: 
ALTER PROFILE DEFAULT LIMIT PASSWORD_LIFE_TIME UNLIMITED;