出處 http://yangtingkun.net/?p=1429
又是一個11g新特性導(dǎo)致的問題。
這個新特性很早之前就研究過,也在其他客戶處碰到過類似的問題。從11g開始,如果一個用戶使用不正確的密碼嘗試登錄數(shù)據(jù)庫,那么隨著登錄失敗次數(shù)的增加,每次登錄驗證前延遲等待的時間也會增加:
SQL> SET TIME ON 18:30:54 SQL> 18:30:58 SQL> conn test/test Connected. 18:31:25 SQL> 18:31:25 SQL> conn test/a conn test/a conn test/a conn test/a conn test/a conn test/a conn test/a conn test/test conn test/a ERROR: ORA-01017: invalid username/password; logon denied Warning: You are no longer connected TO ORACLE. 18:31:26 SQL> ERROR: ORA-01017: invalid username/password; logon denied 18:31:26 SQL> ERROR: ORA-01017: invalid username/password; logon denied 18:31:26 SQL> ERROR: ORA-01017: invalid username/password; logon denied 18:31:27 SQL> ERROR: ORA-01017: invalid username/password; logon denied 18:31:29 SQL> ERROR: ORA-01017: invalid username/password; logon denied 18:31:32 SQL> ERROR: ORA-01017: invalid username/password; logon denied 18:31:36 SQL> Connected. 18:31:36 SQL> ERROR: ORA-01017: invalid username/password; logon denied Warning: You are no longer connected TO ORACLE. 18:31:36 SQL>