Run this from sqlplus to force Oracle user choose a new password when he/she logs in next time:
SQL> ALTER USER username PASSWORD EXPIRE;
Run this from sqlplus to force Oracle user choose a new password when he/she logs in next time:
SQL> ALTER USER username PASSWORD EXPIRE;