Shulou(Shulou.com)05/31 Report--

This article mainly introduces "how to solve oracle password error verification delay". In daily operation, I believe many people have doubts about how to solve the problem of oracle password error verification delay. Xiaobian consulted all kinds of data and sorted out simple and easy-to-use operation methods. I hope it will be helpful to answer the doubt of "how to solve oracle password error verification delay". Next, please follow the editor to study!

Add several password issues to pay attention to after upgrading from 10g to 11g:

11g features, such as user A login is getting slower and slower due to incorrectly entered passwords, starting with the third login with the wrong password, the delay time begins to change to 2 seconds, 3 seconds and an increment. Even if the correct password is provided at this time, the session will be delayed for N seconds and then authenticated. However, once the verification is successful, the failure count will be cleared to zero and subsequent error logins will be re-counted.

1. 11g default starting password is case-sensitive. You can set the parameter to SEC_CASE_SENSITIVE_LOGON = FALSE mask

2. 11g password is valid for 180 days by default. You can take effect by modifying ALTER PROFILE DEFAULT [according to actual profile] LIMIT PASSWORD_LIFE_TIME UNLIMITED;.

3. Password error verification delay can be achieved by setting EVENT= "28401 TRACE NAME CONTEXT FOREVER, LEVEL 1" mask

Alter system set events='28401 trace name context forever, level 1'

If a large number of connections at the same time use the wrong password, basically the user's login will be completely HANG.

There are a lot of library cache lock in the database, and the username is all empty.

At this point, the study on "how to solve the delay of oracle password error verification" is over. I hope to be able to solve your doubts. The collocation of theory and practice can better help you learn, go and try it! If you want to continue to learn more related knowledge, please continue to follow the website, the editor will continue to work hard to bring you more practical articles!

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.