ORA-28001: the password has expired, ora-28001expired

Source: Internet
Author: User

ORA-28001: the password has expired, ora-28001expired

Oracle prompt error message ORA-28001: the password has expired
Cause: due to the new features of Oracle 11G, the default password expiration limit for Oracle 11G users is 180 days. If the user password is not modified for more than 180 days, the user cannot log on.

Solution:
First, enter sqlpuls as sys dba to open sqlpuls
SQL-> enter the User name: sys as sysdbaSQL-> password:
SQL-> select username, account_status from dba_users; check whether the common user statuses are EXPIRED or LOCKED. Some of them are LOCKED <TIME>
If the sysman status is expired, change the password: The statement queries the password's validity period settings, and the LIMIT field indicates the password validity period. When the password is about to expire or has expired, you can use the alter user Username identified by password statement to modify the password. After the password is changed, the USER can connect to the database normally.
You can use the alter profile default limit PASSWORD_LIFE_TIME UNLIMITED statement to change the password validity period from 180 days to "UNLIMITED ". For database security considerations, it is not recommended to set the PASSWORD_LIFE_TIME value to UNLIMITED. We recommend that you modify the database user password periodically.

Related Article

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.