Solution to plsql Database Password Expiration: plsql expiration

Source: Internet
Author: User

Solution to plsql Database Password Expiration: plsql expiration

Recently, when logging on to plsql, the system prompts your password has experied, asking you to change the Database password. The solution is as follows:


1. When logging on to plsql, use sys,


Note: Modify the connection to sysdba.

2. Find users



3. Find your username,

Right-click, edit,

In the pop-up window, enter the password in the password field. The original password is also acceptable,


4. After entering the information, click application.




How can I fix oracle Database Password Expiration?

Open cmd, enter sqlplus/nolog, and press Enter. (2) Enter "conn/as sysdba"; (3) Enter "alter user sys identified by new password". Note: it is best to start the new password with a letter, otherwise an incorrect Ora-00988 may occur. With this method, you can change the password as long as you have administrator permissions on the oracle server and do not remember the password.

Oracle 11g Database Password expired

The password has expired. You can use the sys as sysdba user, and use alter user username identified by passwd. Modify the password.
The password expires several days and other policies depend on the user's Profile.

For details about how to create a profile, refer:
Create profile app_users2 limit
Failed_login_attempts 5
Password_life_time 60
Password_reuse_time 60
Password_reuse_max 5
Password_verify_function verify_function
Pass word_lock_time 1/24
Password_grace_time 10;

How to modify a user's profile
Alter user username profile profilename;

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.