How Oracle Database Password never expires (ORA-28002)
Landing oracle11g
Tip error:ora-28002:the Password would expire within 1 days
Alarm information:
error:ora-28002:the password would expire within 1 days
Reason Analysis:
SELECT * from Dba_profiles s WHERE s.profile= ' DEFAULT ' and resource_name= ' password_life_time ';
The default profile "Password_life_time=180 days" is set in oracle11g.
Programme I
Processing process:
1, view the user's proifle is that, is generally default:
Sql>select username,profile from Dba_users;
2. View 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, the password will expire from the default 180 days to modify to "unrestricted":
ALTER profile DEFAULT LIMIT Password_life_time Unlimited;
4, after the modification, has not been prompted to ORA-28002 warning users will not encounter the same hint;
The user who has been prompted must change the password again, for example:
$sqlplus/as SYSDBA
sql> alter user WAPGW identified by < original password >
Programme II
Oracle Passwords never expire 1. After successfully installing ORACLE11G, the default password is valid for 180 days, the following statement can query:
sql> SELECT * from Dba_profiles s WHERE s.profile= ' default ' and Resource_name= ' Password_life_time ';
2. Password expiration by default of 18 0 days modified to "unrestricted":
sql>alter profile DEFAULT LIMIT password_life_time unlimited;
3. If you do not perform a second step after installation, the password expires:
A. Once the business process restarts, it prompts for a connection failure;
B. Business processes connect database exceptions, affecting business usage.
4. Resolution:
perform 1, 2 steps; Change the password to the original password:
sql> alter user SMSC Iden Tified by < original password >----No need to change the new password