/*
Source: Network
Collection and collation: Chenj
Date Created: 13:21 2010-3-3
Modified time:
*/
/*
Phenomenon:
ora-28001:the Password has expired
Reason:
Due to "password_life_time=180 Day" set in default profile in oracle11g
Effect:
Once the database password expires, the business process will prompt the connection failure once it restarts, affecting business use
Processing steps:
Following action
*/
---1. In the CMD command window, enter:
Sqlplus username/Password @ database Local service name as SYSDBA;
---2. View the user's proifle, which is generally default
Sql>select Username,profile
From Dba_users;
---3. View password expiration settings for the corresponding profile (such as default):
Sql>select * from Dba_profiles s
WHERE s.profile= ' DEFAULT ' and resource_name= ' password_life_time ';
---4. Change the password validity period for a profile (such as default) from the default of 180 days to unrestricted:
Sql>alter profile DEFAULT LIMIT Password_life_time Unlimited; The database does not need to be restarted after---modification, and takes effect immediately.
---5. The user account that has not been prompted to ORA-28002 warning will not be prompted by the change, and the user account that has been prompted must be changed again, for example as follows:
$sqlplus/as SYSDBA
Sql>alter user username identified by < original password > account unlock; ----don't have to change the new password.
---6. Note: The oracle11g startup parameter Resource_limit whether set to False or true, the password validity period is valid, so you must modify it in the above way