ORA-28001: the password has expired解決方法
參考文獻:http://www.zhetao.com/content259
後臺報ORA-28001: the password has expired 密碼超時
登入資料庫伺服器,使用 sqlplus / as sysdba命令,進入oracle資料庫
使用:select * from dba_profiles where profile='DEFAULT' and resource_name='PASSWORD_LIFE_TIME';
語句檢視密碼的有效天數為180天,也就是三個月
使用:alter profile default limit password_life_time unlimited; 命令改為永久生效
驗證
進行以上步驟之後需要改變密碼,否則還會出現password has expired異常
修改使用者密碼:
相關文章
- ORA-28001: the password has expired解決辦法
- EM無法登入,提示ORA-28001: the password has expired (DBD ERROR: OCISessionBegin)ErrorSession
- Your password has expired. To log in you must change it using a client that supports expired passworclient
- 專案使用guzzleHttp報錯:certificate has expiredHTTP
- electron專案npm i 報錯certificate has expiredNPM
- ORA-28002: the password will expire解決方法
- MySQL server has gone away 問題的解決方法MySqlServerGo
- WARNING: REMOTE HOST IDENTIFICATION HAS CHANGED解決方法REMIDE
- ORACLE賬戶提示EXPIRED(GRACE)問題解決Oracle
- memcache清除items和expired方法
- MySQL server has gone away 解決方案MySqlServerGo
- centos Vmware虛擬機器 Oh no,something has gone wrong! 解決方法CentOS虛擬機Go
- svn“Previous operation has not finished; run ‘cleanup‘ if it was interrupted“報錯的解決方法
- 解決MySQL server has gone away錯誤的解決方案MySqlServerGo
- To fix sql server 2008 r2 Evaluation period has expired by change the keySQLServer
- 錯誤:ORA-28002: the password will expire within 7 days 解決方法
- 解決The jar file has no source attachment問題JAR
- Password is required when adding a database to AG group if the database has a master keyUIDatabaseAST
- npm報錯:request to https://registry.npm.taobao.org failed, reason certificate has expiredNPMHTTPAI
- 解決 eclipse 上 Keystore was tampered with, or password was incorrectEclipse
- REMOTE HOST IDENTIFICATION HAS CHANGED 問題解決REMIDE
- 關於Support for password authentication 報錯的解決方案
- “ORA-28007: the password cannot be reused”解決
- idea使用svn “Previous operation has not finished; run 'cleanup' if it was interrupted“報錯的解決方法Idea
- Ubuntu16中vim安裝出錯–has no installation candidate的解決方法Ubuntu
- 解決pycharm問題:module 'pip' has no attribute 'main'PyCharmAI
- has been blocked by CORS policy跨域問題解決BloCCORS跨域
- Apache無法啟動解決 the requested operation has failedApacheAI
- MYSQL解決error: 'Access denied for user 'root'@'localhost' (using password:MySqlErrorlocalhost
- mac os x 安裝mysql遇到 Access denied for user ‘root‘@‘localhost‘ (using password: YES)的解決方法MacMySqllocalhost
- [轉]成功解決AttributeError: module ‘enum‘ has no attribute ‘IntFlag‘?Error
- This function has none of DETEMINISTIC,NO SQL錯誤解決辦法FunctionNoneSQL
- ssh登陸 “remote host identification has changed!“ 解決方案REMIDE
- Myeclipse 錯誤An internal error has occurred 解決辦法EclipseError
- “command-not-found has crashed” 解決辦法 (*unsolved)
- 解決 OCFS2 不能自動掛載 提示 o2net_connect_expired
- Navicat tnt版本提示“failed to save password error code”的解決辦法AIError
- PHP Warning: exec() has been disabled for security 問題解決辦法PHP