今天想啟動一下自己之前做的項目,結果就報使用者密碼過期的錯誤了,沒辦法,隻能處理了。
調試Web項目的時候出現異常:
- java.sql.SQLException: ORA-28001: the password has expired
網上查了一下,是Oracle11g密碼過期的原因
連接配接Oracle,以Oracle使用者登陸,輸入以下指令
- 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
- ------------------------------------------------------------
結果顯示密碼有效期是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
- ------------------------------------------------------------
- alter user XXXUSER identified by Welcome1;
- alter user XXXUSER identified by oracle account unlock;