Are failed login attempts logged anywhere?
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?