Setting Oracle Database User Password Not to Expire
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.