oracle密码错误验证延迟
时间:2022-03-14 02:26
补充从10g升级到11g之后需要注意的几个密码方面问题:
1. 11g默认开始密码区分大小写,可以通过把参数设置为SEC_CASE_SENSITIVE_LOGON =FALSE 屏蔽
2. 11g密码默认有效期180天,可以通过修改ALTER PROFILE DEFAULT[根据实际的profile] LIMIT PASSWORD_LIFE_TIME UNLIMITED; 注意需要修改密码生效
3. 密码错误验证延迟,可以通过设置EVENT="28401 TRACE NAME CONTEXT FOREVER, LEVEL 1"屏蔽
alter system set events=‘28401 trace name context forever, level 1‘;
如果同时大量的连接采用错误的密码,基本上这个用户的登录就会被完全HANG住。
数据库出现大量library cache lock,而且username全部为空 SID USERNAME EVENT SCHEMANAME 1 DIAG idle wait SYS 2 ASM background timer SYS 3 class slave wait SYS 4 class slave wait SYS 7 library cache lock SYS 8 library cache lock SYS 9 library cache lock SYS 10 library cache lock SYS 11 Streams AQ: waiting for time management or cleanup tasks SYS 12 library cache lock SYS 16 library cache lock SYS 17 Space Manager: slave idle wait SYS 18 library cache lock SYS 19 library cache lock SYS 21 library cache lock SYS