How to handle Oracle user password expiration

Affected version: Oracle11g or later. Causes the password to disappear: The default Password_life_time password validity period in Oracle 11g defaults to 180 days. When the client logs on to Oracle prompt ORA-28002, it is basic to determine that the login account has expired, use the DBA authority of the account to reset the account password. WORKAROUND: Follow the steps below to have DBA authority for user Action 1. View password Invalid profile file for user

SQL>SELECT from Dba_users;

EM: server > User, view the user's profile for password invalidation, this assumes default, same as below. 2. Check the password expiration settings for the corresponding profiles

SQL>SELECT*fromWHERE profile='DEFAULT  ' and resource_name='password_life_time';

EM: Server > Profile > select the profile you just found default> view, view the expiration value under password. 3. Change the password expiration value by 180 days to "unlimited"

SQL>ALTERDEFAULT LIMIT password_life_time UNLIMITED;

EM: Server > Profile > select the profile you just found default> edit > Password, enter in the expiration date or select the value you need to save. This parameter modification takes effect in real time. For database security reasons, it is not recommended to set the Password_life_time value to unlimited, which suggests that customers can periodically modify the database user password. Users who have failed before modifying the Password_life_time value, or need to re-modify the password to use.

SQL>alteruser  user_name by password;

How to handle Oracle user password expiration