Solution ORA-28002: password expired 7 days later

This article to tell you about the solution of ORA-28002: password 7 days after the expiration method, you can look at the students who need to refer to Oh, good time not to say more let's see it.

This article to tell you about the solution of ORA-28002: password 7 days after the expiration method, you can look at the students who need to refer to Oh, good time not to say more let's see it.

This article to tell you about the solution of ORA-28002: password 7 days after the expiration method, you can look at the students who need to refer to Oh, good time not to say more let's see it.

Symptom description:
Log on to oracle 11g
ERROR: ORA-28002: the password will expire within 7 days

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

Cause analysis:

The code is as follows:
SELECT * FROM dba_profiles s WHERE s. profile = 'default' AND resource_name = 'password _ LIFE_TIME '; Oracle11g

By default, the"PASSWORD_LIFE_TIME = 180 days". And 10 GB? Oracle of earlier versions is still ??? NLIMITED

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

The code is as follows:
SQL> SELECT username, PROFILE FROM dba_users where username = 'infdb ';

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

The code is as follows:
SQL> 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 ":

The code is as follows:
SQL> 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 prompted user must change the password again, for example:

The code is as follows:
$ Sqlplus/as sysdba SQL> alter user wapgw identified <原来的密码>