Oracle 11g Error: ora-28002:the password would expire within 7 days solution

ERROR: ora-28002:the password'll expire within 7 days

The error is to prompt password to expire, there are two ways to solve the problem.

A. changes have been password The user's error

It's been reported. Password expiring account must be changed again password (DBA authority required)

Take system users as an example

/  as SYSDBA Alter User  by Root;

Re-connect the data will never appear password expired things.

If it is another user, then use other username.

Alter User  by Tiger;  

two.set Password to be a perpetual only period

1. View the profile settings for the user:

SELECT  from Dba_users;  

The profile settings for the general user are default.

2. Review the Password_life_time settings in the system profiles.

SELECT *  fromDba_profiles sWHERES.profile='DEFAULT'  andResource_name='Password_life_time';

Profile Resource_name RESOURCE LIMIT

------------------------------------------------------------------------------- -------------------------------
default                         password_life_time               PASSWORD                 180dys

==============================================================

3. Change the Password_life_tim setting in Dba_profiles to ulimited.

ALTER DEFAULT LIMIT Password_life_time UNLIMITED;  

After the change is set to take effect immediately, do not need to restart the database, at this time password never expire.