DEV Community

Cress
Cress

Posted on

ORA-28000: the account is locked

Who locked oracle database account?

If you have any idea, let me know right now!
But no one does, so we need to find out who locked it.

Survey method

For windows, you can find the error logs on Event Viewer. For Linux and others, on the Oracle alert logs. Its location is below:

$ORACLE_BASE/diag/rdbms/<SID>/<SID>/trace/alert_<SID>.log

First, find the line "ORA-28000: the account is locked". Then, find the line "ORA-01017: invalid username/password; logon denied" just before it. Because the most likely cause is wrong password.
You can find the source host name printed.

Shout the source host name

That is the culprit.

Corrective action

Make sure all members understand the above steps and that no one can escape from administrator.

Top comments (0)