oracle 11g 新特性密碼延遲驗證引發的 血案

ref:

High 'library cache lock' Wait Time Due to Invalid Login Attempts (Doc ID 1309738.1)

SQL>

 

--To disable the wait between login failures

alter system set event ="28401 TRACE NAME CONTEXT FOREVER, LEVEL 1" scope=spfile sid='*';

 

--To enable the wait between login failures

SQL>

alter system set event ="28401 TRACE NAME CONTEXT OFF" scope=spfile sid='*';

 

ref:

http://www.cddba.com/2013/04/07/oracle11g-%E5%AF%86%E7%A0%81%E5%BB%B6%E8%BF%9F%E9%AA%8C%E8%AF%81%E6%B5%8B%E8%AF%95%E4%B8%89/

 

ref:

http://blog.csdn.net/mchdba/article/details/51794443

oracle 11g 新特性密碼延遲驗證引發的 血案

PS：據說在oracle 11g的最後一個版本 11.2.0.4已經徹底修復了這個bug