Solution to plsql Database Password Expiration: plsql expiration

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;