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.