ORA-28000导致的账户被锁

oerr ora 28000

28000, 00000, "the account is locked"

// *Cause:   The user has entered wrong password consequently for maximum

//           number of times specified by the user's profile parameter

//           FAILED_LOGIN_ATTEMPTS, or the DBA has locked the account

// *Action:  Wait for PASSWORD_LOCK_TIME or contact DBA

从10GR2开始默认profile中的FAILED_LOGIN_ATTEMPTS，从而使得用户失败登陆10次后账户被锁，

奇怪的时今天一个系统crash后db重启阶段，账户也被锁，其实密码是对的，

SQL> select profile from dba_users where username='PERFSTAT';

PROFILE

------------------------------------------------------------------------------------------

DEFAULT

SQL> select resource_name,LIMIT from dba_profiles where profile='DEFAULT' and  resource_name='FAILED_LOGIN_ATTEMPTS';

RESOURCE_NAME           LIMIT

FAILED_LOGIN_ATTEMPTS     10

账户被锁后解锁即可

SQL> alter user perfstat account unlock;

需要的需要修改FAILED_LOGIN_ATTEMPTS，以防用户再次被锁

SQL> alter profile default limit FAILED_LOGIN_ATTEMPTS unlimited;

Profile altered.

SQL>  select resource_name,LIMIT from dba_profiles where profile='DEFAULT' and  resource_name='FAILED_LOGIN_ATTEMPTS';

RESOURCE_NAME             LIMIT

FAILED_LOGIN_ATTEMPTS      UNLIMITED

用户FAILED_LOGIN_ATTEMPTS可以通过user$获取

SQL> select NAME,LTIME,LCOUNT from user$ where name='PERFSTAT';

NAME             LTIME               LCOUNT

---------------- --------------- ----------

PERFSTAT         11-JUL-12                0

来自 “ ITPUB博客 ” ，链接：http://blog.itpub.net/22503721/viewspace-735273/，如需转载，请注明出处，否则将追究法律责任。

转载于:http://blog.itpub.net/22503721/viewspace-735273/