Please visit for Videos, Free posts, Books, Webinar and Free forum … ALL about Oracle!

Find out who is locking my account

To find out who is locking your Oracle account, you can check your audit trail. If its too late and you did not set the audit trail on, then one solution can be to check listener log. Listener does show database connection requests. So if you know the time an account was locked (select lock_date from dba_users), you can see from the listener log what connected to the database at that time. (asuming that the connection request was from a remote client, not the DB server)

E.g if I found that the account was locked at 14:45:18 then I can tell from my listener log that it is probably due to a bad password passed by the portal application on host

23-AUG-2010 14:45:18 * (CONNECT_DATA=(SID=DB02)(CID=(PROGRAM=httpd)( * (ADDRESS=(PROTOCOL=tcp)(HOST= * establish * DB02 * 0

Listener logs are an important source of audit information (because many people forget to enable audit).


Leave a Comment »

No comments yet.

RSS feed for comments on this post. TrackBack URI

Leave a Reply

Fill in your details below or click an icon to log in: Logo

You are commenting using your account. Log Out /  Change )

Google+ photo

You are commenting using your Google+ account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s

Create a free website or blog at

%d bloggers like this: