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.

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:	Copy code
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:	Copy code
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:	Copy code
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:	Copy code
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:	Copy code
$ Sqlplus/as sysdba SQL> alter user wapgw identified by <original password>