ORA-28000: the account is locked

Resolve Oracle error — ORA-28000: the account is locked

You might come across the error “ORA-28000: the account is locked“. To unlock the account, run below SQL query in Oracle using admin (system) user.

If your locked user account name is “katepratik”

NOTE : Replace “katepratik” with your locked username.

alter user katepratik account unlock;
grant connect, resource to katepratik;