1.查看用户状态
select username,account_status from dba_users where username='test';

2.解锁：

ALTER USER YS_ADM ACCOUNT UNLOCK;