You can changed failed login attempts to unlimited in your profile and you should be good.It would be better if the OP creates a new profile with failed login attempts to unlimited.Changing the default profile i think is not a good idea and also not recommended by oracle.So,create a new profile and assign that profile to the user.
to preserve formatting*. Regards Edited by: OrionNet on Mar 8, 2009 1:38 AM Edited by: OrionNet on Mar 8, 2009 1:38 AM
return? The COMMENT_TEXT field should tell you what machine the failed connection attempt is coming from.
SELECT * FROM dba_audit_trail WHERE return_code = 1017 AND username = <<user name that is getting locked>>
I'm guessing that you are on 11.1 since the default profile had a non-unlimited FAILED_LOGIN_ATTEMPTS setting. Prior versions did not have that default behavior.From 10.2.0.1 the FAILED_LOGIN_ATTEMPTS attribute in DEFAULT profile has been changed from UNLIMITED to 10.And the tnsping too shows 10.2.0.4 in his first post.Although, its a good recommendation to figure out the process and check for why is it happening.