Oracle Database Password validity period parameter 1. view the profile corresponding to the database user. SQL> select username, profile from dba_users; check the profile of the historical database user sersv IN THE displayed information. Generally, they are all DEFAULT, as shown below. Username profile ------------------------------ system default sys default ...... Sersrv DEFAULT 2. Check the password validity period settings in the profile (default. SQL> select * from dba_profiles s where s. profile = 'default' and resource_name = 'password _ LIFE_TIME '; − if the following information is displayed, the PASSWORD validity period is not limited. PROFILE RESOURCE_NAME resource limit ------------------------------ -------- DEFAULT PASSWORD_LIFE_TIME password unlimited − if the following information is displayed, the PASSWORD has set the validity period. PROFILE RESOURCE_NAME resource limit ------------------------------ -------- DEFAULT PASSWORD_LIFE_TIME PASSWORD 180 run the following command to change the PASSWORD validity period to unlimited. SQL> alter profile default limit password_life_time unlimited; − if Profile altered. is displayed, the password validity period has been changed. Run the following statement to confirm that the password validity period is not limited. SQL> select * from dba_profiles s where s. profile = 'default' and resource_name = 'password _ LIFE_TIME '; 3. Check whether "RESOURCE_LIMIT" is configured as "FLASE ". SQL> show parameter resource_limit − if the displayed result is as follows, it indicates that it has been set to FALSE. Name type value ---------------------------------------------------------------- resource_limit boolean FALSE − if not, run the following command to modify the parameter. SQL> alter system set resource_limit = false scope = both; 4. for users who have prompt that the password is about to expire, you must change the password again. The following describes how to change the password of A sersrv user. Oracle @ msgbox101: ~> Sqlplus "/as sysdba" SQL> alter user msgbox identified by msgbox; Author: wangliya110