Oracle Database Discussions

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

How to find the login attempts related information from trace files?

672680Sep 5 2011 — edited Sep 5 2011

Hi All,

my database version is 10gR2.

Currently, auditing is not enabled for my database. audit_trail=NONE.
And today, I found that someone tried to login the account BIUSER using the wrong password for 10 times, and make the account BIUSER locked.
So, I wonder if it is possible to mine into the background trace files to find out who is trying to login and when?

Any help or suggestion would be highly appreciated.

Thanks

Locked Post

New comments cannot be posted to this locked post.

Locked on Oct 3 2011

Added on Sep 5 2011

#general-database-discussions

4 comments

335 views