Skip to main content
Solved

Oracle User account locked(timed) frequently after few minutes


ascheeka12
Sidekick (Customer)
Forum|alt.badge.img+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,

Best answer by Ruchira

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 

 

 

View original
Did this topic help you find an answer to your question?
This topic has been closed for replies.

4 replies

Forum|alt.badge.img+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


ascheeka12
Sidekick (Customer)
Forum|alt.badge.img+6
  • Author
  • Sidekick (Customer)
  • 29 replies
  • August 9, 2021

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,


Forum|alt.badge.img+13
  • Hero (Partner)
  • 132 replies
  • Answer
  • August 9, 2021

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 

 

 


ascheeka12
Sidekick (Customer)
Forum|alt.badge.img+6
  • Author
  • Sidekick (Customer)
  • 29 replies
  • August 9, 2021

@Ruchira thanks dear , will check.


Cookie policy

We use cookies to enhance and personalize your experience. If you accept you agree to our full cookie policy. Learn more about our cookies.

 
Cookie settings