Oracle User Login Prompt: ORA-28000: Account Is Locked
Solution:
sqlplus / as sysdba
sql>alter user username account unlock;
User altered.
Generally, the database locks a user after 10 failed login attempts by default:
1. Check the value of FAILED_LOGIN_ATTEMPTS
select * from dba_profiles where RESOURCE_NAME = 'FAILED_LOGIN_ATTEMPTS';
2. Change it to 30 attempts
alter profile default limit FAILED_LOGIN_ATTEMPTS 30;
3. Change it to unlimited (not recommended for security reasons)
alter profile default limit FAILED_LOGIN_ATTEMPTS unlimited;