Connecting Oracle times Error: ora-28001:the Password has expired

An exception occurred while debugging a Web project:

1. java.sql.sqlexception:ora-28001:the Password has expired

Check online, is the reason why the oracle11g password expires

Connect Oracle, log in as Oracle user, enter the following command

1. SELECT * from dba_profiles where profile=' DEFAULT ' and resource_name=' password_life_time ';

The results show:

1. Profile
2. ------------------------------------------------------------
3. Resource_name
4. ------------------------------------------------------------
5. Resource_type
6. ----------------
7. LIMIT
8. ------------------------------------------------------------
10. DEFAULT
11. Password_life_time
12. PASSWORD
13. 180
15. ------------------------------------------------------------

The result shows that the password is valid for 180 days

Enter the command:

1. Alter profile default limit password_life_time unlimited;
2. Commit

Execute again:

1. SELECT * from dba_profiles where profile=' DEFAULT ' and resource_name=' password_life_time ';

The results are shown as:

1. Profile
2. ------------------------------------------------------------
3. Resource_name
4. ------------------------------------------------------------
5. Resource_type
6. ----------------
7. LIMIT
8. ------------------------------------------------------------
10. DEFAULT
11. Password_life_time
12. PASSWORD
13. UNLIMITED
14. ------------------------------------------------------------

You need to change the password after doing the above steps, or else the password has expired exception will appear

command to change Password

1. Alter user Xxxuser identified by Welcome1;

If the account is locked, you need to unlock the command

1. Alter user Xxxuser identified by Oracle account unlock;

Connecting Oracle times Error: ora-28001:the Password has expired