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)