Here are the steps to set the password not to expire for the Oracle database user. Here we are assuming that the user has been assigned with the default profile:
SQL> alter profile default limit password_life_time unlimited;
Profile altered.
SQL> alter user scott identified by tiger;
User altered.
Caution: This is not recommended for production environment. You should check with corporate security policy before altering any profile changes related to passwords.