Knowing if Oracle account has been locked

oracleoracle-11g

We have an Oracle that locks up randomly; we get error ORA-28000: the account is locked.

Is there some log that will tell me if an oracle account was locked throughout the day? Right now the Oracle account works fine.

I don't have admin rights in this database. We have Oracle Database 11g Enterprise Edition Release 11.2.0.4.0 - 64bit Production.

Thanks.

Best Answer

If you don't have admin rights you probably won't be able to troubleshoot the issue without your DBAs. Some hints for troubleshooting (again, with your DBAs)

  • If the user is locked after some time (and not multiple times a day) the PASSWORD_LIFE_TIME in the (default) profile for your user might be the culprit.
  • If the user is locked randomly and you don't have something fancy like auditing enabled, you can look at your listener.log and check if there are connections from hosts you aren't aware of. Often some web service or workstation with old credentials caused user locking at my place.

If you don't have any access to the server's log files and/or the admin views this issue is hard to resolve. Team up with your DBAs

Related Question