Oracle用户解锁lockd

Oracle用户解锁lockd

用户doiido连接oracle的时候报如下错误：

ORA-28000: the account is locked

查看用户状态

sql> conn / as sysdba
sql> SELECT username,account_status FROM dba_users;

USERNAME                       ACCOUNT_STATUS
------------------------------ --------------------------------
doiido                         EXPIRED & LOCKED

##可以看到doiido的状态是expired&locked，表示账户是密码过期的而且用户帐号状态是锁定的
将用户doiido解锁，并设置密码为123456
sql> alter user doiido IDENTIFIED by 123456 account unlock;

再次查看用户状态

sql> SELECT username,account_status FROM dba_users;

USERNAME                       ACCOUNT_STATUS
------------------------------ --------------------------------
doiido                         OPEN

此时doiido用户就可以正常连接了