ORA-28000: the account is locked

找出被锁的用户然后，解锁。

SELECT DISTINCT(NAME) FROM sys.user$ WHERE astatus != 0;

xxxx;

alter user xxx account unlock;

简化下用以下SQL可以完成。

SELECT 'alter user '|| name || ' account unlock;' from ( SELECT DISTINCT(NAME) FROM sys.user$ WHERE astatus != 0);