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