Locked or expired Accounts
-- to unlock an account
alter user xxx account unlock;

-- expired account
alter user xxx indentified by xxx;

-- change the password expiry for a profile, in this case the default profile:
alter profile default limit password_life_time unlimited;