Now with oracle11g, but over a period of time the user was locked depressed for a long, later on-line query know, the original Oracle has the number of login failures failed_login_attempts limit, more than the specified number of times will be automatically locked
Workaround:
Modify parameter failed_login_attempts=unlimited;
Sql>sqlplus/nolog
Sql>conn Sys/sys as SYSDBA;
First, Unlock:
Sql>alter user username account unlock;
sql>commit;
Second, modify the number of login failures limit:
1. Query the default value of the Failed_login_attempts parameter: (Note: The value of this parameter is unlimited in a 9i environment)
Sql>conn/as SYSDBA
Connected.
sql> desc dba_profiles;
Whether the name is a null type
----------------------------------------- -------- --------------
Profile is not NULL VARCHAR2 (30)
Resource_name not NULL VARCHAR2 (32)
Resource_type VARCHAR2 (8)
LIMIT VARCHAR2 (40)
Sql> Select Resource_name,limit from dba_profiles where resource_name= ' failed_login_attempts ';
Resource_name LIMIT
-------------------------------- ----------------------------------------
Failed_login_attempts 10
The query failed_login_attempts value is 10, which is the number of consecutive login failures that are calculated from the first logon failure. Rather than the number of cumulative failures
2. Modify the value of the failed_login_attempts
sql> alter profile default limit Failed_login_attempts unlimited;
Configuration file has changed
Sql> Select Resource_name,limit from dba_profiles where Resource_name= ' Failed_lo
Gin_attempts ';
Resource_name LIMIT
-------------------------------- ----------------------------------------
Failed_login_attempts UNLIMITED
You can use the Select Name,lcount from user$ statement to query the current number of failures. user$ is the base table for view dba_users, and you can usually query the base table for the view, and Oracle may hide some parameters.
ORA-28000 account is locked and unlocked