Solved

Oracle User account locked(timed) frequently after few minutes

  • 9 August 2021
  • 4 replies
  • 2202 views

Userlevel 3
Badge +6

Dear Team,

I need your help OR suggestion for the subjected topic. since yesterday one IFS user account frequently getting locked(timed) in oracle user management. 

user is already active but don’t know the exact problem with user account.

really appreciate for quick support on this. 

 

Regards,

icon

Best answer by Ruchira 9 August 2021, 13:53

View original

This topic has been closed for comments

4 replies

Userlevel 5
Badge +13

Hi @ascheeka12,
 

Did you try to unlock the user account by logging into the DB as sys user, connecting as SYSDBA?

You can use the following command to unlock the user account,

ALTER USER [ACCOUNT] IDENTIFIED BY [PASSWORD] ACCOUNT UNLOCK;

Did you get an error while trying to unlock the user account using the above command?

Best Regards,
Bhagya

Userlevel 3
Badge +6

Dear @Bhagya Wickramasinghe as we discussed, there is not any problem to unlock and login with reset password but after few minutes while login it getting locked again.

 

 

Regards,

Userlevel 5
Badge +12

Hi @ascheeka12 

Locked(TIMED) account status of a user means times of the wrong password entered to login has been exceeded the number of times allowed in the oracle profile

First check what’s the profile assigned to your user from below window and navigate to the page shown in latter screen to see the value defined for ‘Failed Login Attempts’ 

You may change the values accordingly but I suspect the real problem can be

  1. Someone actually trying to guess this user’s password
  2. Some other 3rd part app is configured with this user credentials which will repetitively trying to connect to the database from some old credentials, you need to find that and update the credentials 

 

 

Userlevel 3
Badge +6

@Ruchira thanks dear , will check.