補充從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