ORA-28000: the Account is locked error appearing frequently

Asked

Viewed 175 times

0

I work at an institution where we use an application that connects to an ORACLE database.

Recently the BD user password has been changed, and the message Account is locked appears frequently...

I believe that some user’s computer is with the password outdated, then when it opens the application it tries to connect using the wrong password and locks the BD user... It is possible to identify the IP or name of the computer who is trying to make these accesses?

oracle

  • make an appointment at v$sessions and see who’s doing it

1 answer

0


Hello, You can try to identify this host in your database server’s log. Another alternative to prevent the user from being blocked until Voce can identify the origin of the attempts to connect to the old password, is to change the profile of this user not to block after attempts with the incorrect password.

Abs, Renato

Browser other questions tagged oracle

You are not signed in. Login or sign up in order to post.