OracleHint error message ora-28001:the password has expired Cause of the problem: due to the new features of Oracle 11G, the default password expiration limit for Oracle 11G when creating a user is 180 days, and the user cannot log on if the user password has not been modified for more than 180 days.
Workaround: First, enter Sqlpuls as SYS DBA to open sqlpuls sql-> Please enter your username: sys as sysdbasql-> password: Sql->select username,account_status from Dba_users; see if the usual user status is expired or locked. locked<time> If the Sysman state is out of date, modify the password method: The statement queries the password's validity period setting, and the Limit field is the number of days the password is valid. When the password is about to expire or expires, it can be changed by the ALTER user username identified by password, and the user can connect to the database after the password is modified. Long-term correspondence can be modified by the ALTER profile default limit Password_life_time Unlimited statement to 180 days for the password validity period to "unlimited". For database security reasons, it is not recommended to set the Password_life_time value to unlimited, and it is recommended that customers periodically modify the database user password. |
ora-28001:the Password has expired