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;
SQL> alter user scott identified by tiger;
Caution: This is not recommended for production environment. You should check with corporate security policy before altering any profile changes related to passwords.