Resolved ORA-28002: the password will expire within 1 days symptom Description: Login oracle 11g ERROR: ORA-28002: the password will expire within 1 days alarm information: ERROR: ORA-28002: the password will expire within 1 days Cause Analysis: In oracle11g, "PASSWORD_LIFE_TIME = 180 days" is set in the default profile by default ". Solution:
1. Check the user's proifle, which is generally default: SQL code www.2cto.com SELECT username, PROFILE FROM dba_users; 2. view the password validity period settings of the specified PROFILE (such as default: SQL code SELECT * FROM dba_profiles s WHERE s. profile = 'default' AND resource_name = 'password _ LIFE_TIME ';
3. Change the password validity period from the DEFAULT 180 days to "UNLIMITED": SQL code ALTER PROFILE DEFAULT LIMIT PASSWORD_LIFE_TIME UNLIMITED;
4. After the modification, the user who has not been prompted the ORA-28002 warning will not encounter the same prompt again; the user who has been prompted must change the password again, log on with the dba user, then enter the modification statement, SQL code alter user wapgw identified by <original password> author raik25