How to unlock account on Oracle
Sometimes we input password wrong many times cause oracle locked the account, then we couldn’t continue to work. how to unlock account on oracle?
check account status
using the sql check the account_status
select USERNAME,ACCOUNT_STATUS from dba_users where username='test';
unlock the account
for example: unlock user test
alter user test account unlock;