Oracle & amp; #160; 11 & amp; #160; password is set to never expire

Oracle & #160; 11 & #160; password set to never expire
Follow these steps:
1. Check the user's proifle, which is generally default:
SQL> SELECT username, PROFILE FROM dba_users;
2. view the password validity period settings of 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 180 days to "unlimited ":
SQL> ALTER PROFILE DEFAULT LIMIT PASSWORD_LIFE_TIME UNLIMITED;
After modification, the database does not need to be restarted and takes effect immediately.
4. After the modification, the user who has not been prompted the ORA-28000 warning will not encounter the same prompt again;
The locked account must be unlocked, for example:
$ Sqlplus/as sysdba
SQL> alter user smsc identified by oracle account unlock;
5. After modification, the default profile should be as follows:
SQL> select * from dba_profiles WHERE dba_profiles.profile = 'default ';
PROFILE RESOURCE_NAME RESOURCE_TYPE LIMIT
-------------------------------------------------------------------------------------------------
DEFAULT FAILED_LOGIN_ATTEMPTS PASSWORD UNLIMITED
DEFAULT PASSWORD_LIFE_TIME PASSWORD UNLIMITED
After modification, the database does not need to be restarted and takes effect immediately.
If the ORA-28000 the account is locked. error occurs
Alter user Username account unlock;