Ext: Oracle password expires, 180 days limit on password cancellation

Original: https://www.cnblogs.com/soar-gh/p/5949158.html

1. Enter Sqlplus mode

Sqlplus/as Sysdba;

2. Check the validity period of the user password (the default configuration file is defaulted)

SELECT * from Dba_profiles WHERE profile= ' DEFAULT ' and resource_name= ' password_life_time ';

3. Change the password validity period from the default of 180 days to "unlimited", after the modification does not need to restart the database, will take effect immediately

ALTER profile DEFAULT LIMIT password_life_time UNLIMITED;

4. Change your account password again
Alter user username identified by original password;

5, use the modified user login, if the "ORA-28000: The user has been locked", unlock

Alter user Db_user account unlock;

Commit

Ext: Oracle password expires, 180 days limit on password cancellation