Thursday, June 16, 2016

Find failed LOGON timestamp in ORACLE

"DBA_AUDIT_SESSION"

ex:
select
USERNAME, USERHOST, ACTION_NAME, RETURNCODE, TO_CHAR(TIMESTAMP,'MM/DD HH24:MI') TIMESTAMP
from
dba_audit_session
where
USERNAME like 'ORACLE_USERNAME'
and
RETURNCODE > 0

RETURNCODE:
1017        invalid username/password
28000        Account is Lock
0        Normal Login

No comments:

Post a Comment

Note: Only a member of this blog may post a comment.

ALCATEL 6900

write memory copy running certified reload from working no rollback-timeout