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博客

ORA-28000导致的账户被锁