Oracle Password expires ora-28001:the password has expired

Oracle 11g default password expiration time is 180 days,

After the password expires, the following exception occurs when you access the database:

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

Query Password expiration settings:

SELECT * from Dba_profiles where profile= ' DEFAULT ' and resource_name= ' password_life_time ';

Change password expires as: Unlimited

Alter profile default limit Password_life_time unlimited;

After you change the password setting to unlimited, you may continue to report the password has expired exception

At this point, you need to change your password:

Alter user user_name identified by password;

If you want to continue to use the original password, you can modify the password to another value, and then modify it back.

If the user is locked out: java.sql.sqlexception:ora-28000:the account is locked

Execute the following statement to unlock the user:

Alter user user_name account unlock;

This article is from the "Dream Escape" blog, please be sure to keep this source http://pinmei.blog.51cto.com/7012784/1621623

Oracle Password expires ora-28001:the password has expired