OS : windows vista
SQL*Plus: Release 10.2.0.3.0 - Production on Wed Aug 12 13:17:14 2009
Copyright (c) 1982, 2006, Oracle. All Rights Reserved.
ORA-01005: null password given; logon denied
Question: when oracle prompts for password, i just hit enter ie nothing. It gave ORA-01005 and prompted for next attempt. I expected increment in 'lcount' of user$ table. But it did not happend.
Since FAILED_LOGIN_ATTEMPTS is set 2, i expected account to get locked after 2 attempts, but it did not happend.
After 3 attempts, oracle stpped prompting for username and came back to os prompt. I called same command again and this time i gave wrong password , it incremented user$ and also account got locked after 2 attempts.
Any idea why oracle did not locked account with null password or if this is normal behaviour of oracle, is there any alternative to lock account even for null passowrd ?