ora-28001:the Password has expired

Source: Internet
Author: User

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

Contact Us

The content source of this page is from Internet, which doesn't represent Alibaba Cloud's opinion; products and services mentioned on that page don't have any relationship with Alibaba Cloud. If the content of the page makes you feel confusing, please write us an email, we will handle the problem within 5 days after receiving your email.

If you find any instances of plagiarism from the community, please send an email to: info-contact@alibabacloud.com and provide relevant evidence. A staff member will contact you within 5 working days.

A Free Trial That Lets You Build Big!

Start building with 50+ products and up to 12 months usage for Elastic Compute Service

  • Sales Support

    1 on 1 presale consultation

  • After-Sales Support

    24/7 Technical Support 6 Free Tickets per Quarter Faster Response

  • Alibaba Cloud offers highly flexible support services tailored to meet your exact needs.