ora-28002 the password would expire solution

Source: Internet
Author: User

ORACLE11G R2 database hint ora-28002:the password will expire within 5 days, is that the password expires, the Oracle password is set to never expire, but it is not recommended to do so, It is best to set the date password validity period longer.

Tools/Materials
    • oracle11g R2
    • Sqlplus
Method/Step
    1. Sqldeveloper Connection Database Hints

      Ora-28002:the password'll expire within 5 days

    2. Log in to Sqlplus

      Sqlplus/as SYSDBA

    3. To see how long your password is valid

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

    4. Set the password to never expire

      Sql> ALTER profile DEFAULT LIMIT password_life_time UNLIMITED;

    5. Modify User Password

      sql> alter user joffice identified by Joffice;

    6. After you modify the user password and log in again, you will find that the hint is gone. But small series again remind, this is just a solution, generate database best or regular change password, security first AH.

ora-28002 the password would expire solution

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.