oracle11g The default password expiration limit when creating a user is 180 days (that is, 6 months) and the user cannot log on if the user password has not been modified for more than 180 days. Oracle Corporation has introduced this default feature in 11G for database security by default, but this default feature is easily overlooked by DBAs or developers, which can occur if the password has not been modified for 180 days.
The workaround is to use the following SQL statement
SELECT * from Dba_profiles WHERE profile= ' DEFAULT ' and resource_name= ' Password_life_time '
The validity period of the password is set, and the Limit field is the valid number of days.
The limit for removing the 180-day password lifetime can be turned off by the following SQL statement
ALTER profile DEFAULT LIMIT password_life_time UNLIMITED
As on the SQL statement, the password validity period default value of 180 days is modified to "unlimited". However, for database security reasons, it is not recommended to set the Password_life_time value to unlimited
Oracle error, ORA-28001: password has expired