Skip to main content

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,

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 RACCOUNT] IDENTIFIED BY YPASSWORD] ACCOUNT UNLOCK;

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

Best Regards,
Bhagya

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,

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 

 

 

@Ruchira thanks dear , will check.

Terms & ConditionsCookie settings