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.