Oracle Password Expiration processing ____oracle

/*

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