Please visit www.oracle-class.com for Videos, Free posts, Books, Webinar and Free forum … ALL about Oracle!

August 24, 2010

Find out who is locking my account

Filed under: Uncategorized — orawiss @ 3:45 pm

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 portal.es6.orawiss.net:

23-AUG-2010 14:45:18 * (CONNECT_DATA=(SID=DB02)(CID=(PROGRAM=httpd)(HOST=portal.es6.orawiss.net)(USER=apache))) * (ADDRESS=(PROTOCOL=tcp)(HOST=192.168.44.30)(PORT=60618)) * establish * DB02 * 0

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

Advertisements

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:

WordPress.com Logo

You are commenting using your WordPress.com 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 )

Google+ photo

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

Connecting to %s

Create a free website or blog at WordPress.com.

%d bloggers like this: