Processing process:
1, the View user's proifle is that, generally is the default:
Sql>select username,profile from Dba_users;
2. View the password expiration settings for the specified profile (such as default):
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 of 180 days to "unlimited":
ALTER profile DEFAULT LIMIT password_life_time UNLIMITED;
(The first three steps have been resolved fourth step not necessary)
4, after the modification, has not been prompted ORA-28002 warning users will not encounter the same prompt;
Users who have already been prompted must change their password again, for example:
$sqlplus/as SYSDBA
sql> alter user WAPGW identified by < original password >
Set an Oracle account password to be permanently out of date