java.sql.SQLException: ORA-28001: the password has expired（oracle密碼過期預設180天）

維護的網站網站登入後總是顯示404，日志顯示java.sql.SQLException: ORA-28001: the password has expired——oracle密碼過期了；

解決方法： 打開SQL Pluse 或者是登入sql用戶端工具（如sqlDeveloper/pLsql/navacate建立查詢）都行；

   一、

select * from dba_profiles where profile='DEFAULT' and resource_name='PASSWORD_LIFE_TIME';
           

PROFILE
------------------------------------------------------------
RESOURCE_NAME
------------------------------------------------------------
RESOURCE_TYPE
----------------
LIMIT
------------------------------------------------------------
 
DEFAULT
PASSWORD_LIFE_TIME
PASSWORD
180
 
------------------------------------------------------------
           

二、

alter profile default  limit password_life_time unlimited;
commit;
           

三、

再次執行：

select * from dba_profiles where profile='DEFAULT' and resource_name='PASSWORD_LIFE_TIME';
           

顯示：

PROFILE
------------------------------------------------------------
RESOURCE_NAME
------------------------------------------------------------
RESOURCE_TYPE
----------------
LIMIT
------------------------------------------------------------
 
DEFAULT
PASSWORD_LIFE_TIME
PASSWORD
UNLIMITED
------------------------------------------------------------
           

進行以上步驟之後需要改變密碼，否則還會出現password has expired異常

改變密碼的指令

alter user XXXUSER identified by Welcome1;
           

如果賬号被鎖住，則需要解鎖指令

alter user XXXUSER identified by oracle account unlock;
           

解決！