unlock password oracle

alter user user_name identified by new_password account unlock;

ALTER PROFILE "DEFAULT" LIMIT PASSWORD_VERIFY_FUNCTION NULL;

SELECT profile
  FROM dba_users

alter user codd identified by ef account unlock;

alter user vivek identified by vivek account unlock;