How to modify the Oracle 11G password after it expires

Due to the new features of Oracle11G, often encounter the use of sqlplus login oracle Database prompts "ORA-28002: 7 days after the password will expire" and so on. The default password expiration limit when creating a user in Oracle 11G is 180 days, if the user password is not modified more than 180 days, the user cannot log on, the prompt "ORA-28001: the password has expired ". After the password expires, an exception occurs when the business process connects to the database, which will inevitably affect the use and login. Liberation method: **************************************** * *************** 1. check the user PASSWORD's validity period settings (generally the DEFAULT configuration file is DEFAULT) SQL> SELECT * FROM dba_profiles WHERE profile = 'default' AND resource_name = 'password _ LIFE_TIME 'www.2cto.com 2. change the password validity period from the DEFAULT 180 days to "UNLIMITED". After the change, the database does not need to be restarted, and the SQL> Alter PROFILE DEFAULT LIMIT PASSWORD_LIFE_TIME UNLIMITED; 3. SQL> alter user ink identified by <original password> ---- No new password is required. log On with the modified user. If "ORA-28000: user locked" is reported, unlock SQL> alter user db_user account unlock; SQL> commit; author ontherd