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用戶就可以正常連接了