Search notes:

ORA-28000: The account is locked.

Unlocking a locked users:
alter user peter_mayer account unlock;
Find locked users:
select
   username,
   account_status,
   lock_date
from
   dba_users
where
   account_status like '%LOCKED%' -- might also be 'EXPIRED & LOCKED'
;

See also

ORA-01017: invalid username/password; logon denied
ORA-01045: user ... lacks CREATE SESSION privilege; logon denied
Other Oracle error messages

Index