oracle 用户进行解锁

SELECT USERNAME,ACCOUNT_STATUS FROM DBA_USERS;解锁前查看用户的状态

ALTER USER hr ACCOUNT UNLOCK;  对hr这个用户进行解锁

ALTER USER hr IDENTIFIED BY hr; 对hr用户进行密码设置

SELECT USERNAME ,ACCOUNT_STATUS FROM DBA_USERS WHERE USERNAME='HR'; 

USERNAME                       ACCOUNT_STATUS
------------------------------ --------------------------------
HR                             OPEN

ACCOUNT_STATUS该列是OPEN 说明正常了。