Why Oracle user get locked(timed) ? I had change profile : PASSWORD_LIFE_TIME, PASSWORD_LOCK_TIME, PASSWORD_GRACE_TIME to UNLIMITED, but it doesn’t work.
Then I run audit trail :
- alter system set audit_trail=db scope=spfile; (then restart db)
- audit connect whenever not successful;
- monitoring via this query :
SELECT *
FROM dba_audit_session
WHERE action_name = ‘LOGON’ AND returncode > 0
ORDER BY timestamp DESC; - then login fail and then locked because the user password case-sensitive, so I run : alter system set sec_case_sensitive_logon=false;
- done ^_^
Filed under: Oracle | Tagged: Oracle | Leave a comment »