The ORA-28002 password will expire in 7 days

Description: Login Oracle11g ERROR: ORA-28002: thepasswordwillexpirewithin7days alarm information: ERROR: ORA-28002: thepa

Description: Login Oracle11g ERROR: ORA-28002: the password will expirewithin 7 days alarm information: ERROR: ORA-28002: the pa

Symptom description:

Log on to Oracle11g

ERROR: ORA-28002: the password will expirewithin 7 days

Alarm information:

ERROR: ORA-28002: the password will expire within 7 days

Cause analysis:

SELECT * FROM dba_profiles s WHERE s. profile = 'default' ANDresource_name = 'password _ LIFE_TIME ';

In oracle11g, "PASSWORD_LIFE_TIME = 180 days" is set in the default profile by default ". Oracle of 10 GB and earlier versions still defaults to UNLIMITED.

Problem solving process:

1. Check the user's proifle, which is generally default:

SQL> SELECTusername, PROFILE FROM dba_users where username = 'infdb ';

2. view the password validity period settings of the specified profile (such as default:

SQL> SELECT * FROM dba_profiles s WHERE s. profile = 'default' ANDresource_name = 'password _ LIFE_TIME ';

3. Change the password validity period from the default 180 days to "unlimited ":

SQL> ALTERPROFILE 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 prompted user must change the password again, for example:

$ Sqlplus/assysdba

SQL> alter user wapgw identified <原来的密码>