Follow the steps below:
1, check the user's proifle is which, is generally default:
Sql>SELECT username,profile from Dba_users;
2. View the 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. Change the password validity period from the default of 180 days to "unlimited":
Sql>ALTER profile DEFAULT LIMIT password_life_time UNLIMITED;
You do not need to restart the database after you modify it, it takes effect immediately.
4, after the modification, has not been prompted ORA-28000 warning users will not encounter the same prompt;
an account that has been locked must be unlocked, for example:
$sqlplus/as SYSDBA
Sql>alter user SMSC identified by Oracle account unlock;
5. After the modified 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
You do not need to restart the database after you modify it, it takes effect immediately.
If the ORA-28000 the account is locked. Error
Alter user username account unlock;
Oracle 11 password is set to never expire