Skip to Main Content

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!

Are failed login attempts logged anywhere?

flying_penguinJun 25 2008 — edited Jun 25 2008
DB version:10gR2
We had an issue where an User account was locked for an hour. Is there a way i could find the machine(ip address/terminal) from where the login was attempted?

It is not in alert log. I just checked it. Queries on v$session will only give the sessions which are connected(like the query below)

SELECT SID,SERIAL#,osuser,TERMINAL FROM V$SESSION WHERE schemaname='SCOTT';

Is there a way to find this out?
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Jul 23 2008
Added on Jun 25 2008
7 comments
4,926 views