Oracle 11g 報錯 ORA-28000 the account is locked
Oracle 11g 報錯 ORA-28000 the account is locked
一、觸發這個錯誤的原因及相關因素
是由於oracle11g中預設在default概要檔案中設定了“PASSWORD_LIFE_TIME=180天”所導致,在Oracle 11g中是
存在密碼過期問題的。
二、錯誤現象:
使用者被鎖定之後會報ORA-28000的錯誤,並提示無法登入到資料庫
SQL> conn system/oracle
ERROR:
ORA-28000: the account is locked
Warning: You are no longer connected to ORACLE.
SQL>
三、解決方法:
按照如下步驟進行操作:
1、檢視使用者的proifle是哪個,一般是default:
SQL> select username,profile from dba_users where username='SYSTEM';
USERNAME PROFILE
------------------------------ ------------------------------
SYSTEM DEFAULT
SQL>
2、檢視指定概要檔案(如default)的密碼有效期設定:
SQL> SELECT * FROM dba_profiles s WHERE s.profile='DEFAULT' AND resource_name='PASSWORD_LIFE_TIME';
PROFILE RESOURCE_NAME RESOURCE LIMIT
------------------------------ -------------------------------- -------- ----------------------------------------
DEFAULT PASSWORD_LIFE_TIME PASSWORD 180DAY
3、將密碼有效期由預設的180天修改成“無限制”:
SQL>ALTER PROFILE DEFAULT LIMITPASSWORD_LIFE_TIME UNLIMITED;
修改之後不需要重啟動資料庫,會立即生效。
4、修改後,還沒有被提示ORA-28002警告的帳戶不會再碰到同樣的提示;
已經被提示的帳戶只需解鎖即可。
$sqlplus / as sysdba
SQL> alter user system account unlock;
User altered.
如果還無法登入,執行再配置一次密碼就OK了。(跟原密碼一樣就好)
SQL> alter user system identified by oracle;
User altered.
oracle11g啟動引數resource_limit無論設定為false還是true,密碼有效期都是生效的,所以必須透過以上方式進行修改。以上的帳戶名請根據實際使用的帳戶名更改。
來自 “ ITPUB部落格 ” ,連結:http://blog.itpub.net/20674423/viewspace-722515/,如需轉載,請註明出處,否則將追究法律責任。
相關文章
- Oracle 11g 密碼過期被鎖報 ORA-28000 the account is lockedOracle密碼
- Oracle案例07——ORA-28000: the account is lockedOracle
- ORA-28000: the account is locked 解決方式
- 【DG】DG備庫報ORA-28000: the account is locked的解決辦法
- 處理賬號頻繁鎖定 ORA-28000: the account is locked
- solaris oracle vault 登入錯誤 the account is locked [28000].Oracle
- [重慶思莊每日技術分享]-DG備庫使用者被鎖報ora-28000:the account is locked
- oracle 11g安裝報錯Oracle
- 【ERROR】su user報'This account is currently not available'錯誤 for linuxErrorAILinux
- ORA-28000錯誤解決方案
- 我的oracle mos accountOracle
- oracle account 外部認證Oracle
- Vbox安裝oracle-linux報錯:VT-x features locked or unavailable in MOracleLinuxAI
- Your account has been locked out. Please contact the system administrator for further assistance.
- oracle 11g 錯誤收集Oracle
- Oracle 11g報錯"ORA-00845: MEMORY_TARGET not supported on this system"Oracle
- oracle 11g報錯ORA-00845: MEMORY_TARGET not supported on this systemOracle
- Oracle 11G靜默安裝報錯Oracle recommends that if you want to keep this log...Oracle
- oracle dg報錯Oracle
- oracle emctl 報錯Oracle
- Solr報錯Index locked for write for core '***'. Solr now longer supports forceful unlocking via 'unlockOnStartup'SolrIndex
- 使用oracle 11g bbed dump undo header block報錯之系列六OracleHeaderBloC
- Oracle 11g啟動報ORA-28056、OS 1502錯誤Oracle
- Oracle 11g RAC操作DBCA期間報ORA-04031錯誤Oracle
- ORACLE資料庫刪除表中記錄報record is locked by another userOracle資料庫
- 1120 11g select for update skip locked
- ORACLE 11G生成AWR報告Oracle
- Oracle 11G安裝報錯"ORA-00401: the value for parameter compatible"Oracle
- 一次oracle 11g 資料泵 報錯 的解決過程Oracle
- Oracle TNS報錯大全Oracle
- 連線oracle報錯Oracle
- 轉:Oracle 解鎖Record is locked by another useOracle
- Oracle 11g 手工跑AWR報告Oracle
- Oracle 11g 手工跑ASH報告Oracle
- 11g ASM 重啟 HAC 報錯 CRS-4124: Oracle High AvailabilityASMOracleAI
- Oracle 11g 報錯ORA-01102: cannot mount database in EXCLUSIVE modeOracleDatabase
- AIX 6.1 安裝 Oracle 11g R1 報Java錯誤解決方法AIOracleJava
- Oracle 11g下TNS連線報錯ora-12532故障解決Oracle