alter user username account unlock;

alter user username identified by "password";

Password can also be changed, using the hashed value from “SYS.USER$';

alter user username identified by values "hash";