ORA-09817: Write to audit file failed 的解決
今天在進行awr報表匯出時，用sys as sysdba 登入，不能connect，報ORA-09817: Write to audit file failed 錯誤，是系統空間不足的報警。df -lh 檢視空間使用，已經用到了100%，然後刪除trace檔案，tracle檔案路徑：/opt/oracle/admin/sid_name/udump。trace檔案為對後臺跟蹤資訊，在後臺生成的跟蹤檔案記錄，可以刪除。
1、su - oracle
cd $ORACLE_HOME/bin
./sqlplue /nolog
conn sys as coll
pass
2、df -lh
3. cd /opt/oracle/admin/sid_name/udump
rm -f *.trc
來自 “ ITPUB部落格 ” ，連結：http://blog.itpub.net/9521459/viewspace-684600/，如需轉載，請註明出處，否則將追究法律責任。
相關文章
- Oracle - ORA-09817: Write to audit file failedOracleAI
- 解決ssh的"Write failed: Broken pipe"問題AI
- socket write failed(24) _Netbackup的問題解決AI
- FN_AUDIT - Name of security audit file
- 【OSX】解決Terminal ssh連線"Write failed Broken pipe"問題AI
- VMware 啟動報錯 "Failed to lock the file"解決辦法AI
- db file parallel writeParallel
- remount of /system failed: Read-only file system原因及解決REMAI
- Oracle db file parallel write 和 log file parallel write 等待事件 說明OracleParallel事件
- log file sync 和 log file parallel writeParallel
- How to audit failed logon attemptsAIGo
- nodejs read/write fileNodeJS
- control file parallel writeParallel
- 【故障處理】Linux下匯入匯出“IMP-00030: failed to create file ... for write”LinuxAI
- data file int write和db file sequential read個人想法
- Failed to execute aapt的奇怪解決方法AIAPT
- control file parallel write等待事件Parallel事件
- pyenv BUILD FAILED解決方法UIAI
- redo的等待log file sync和log file parallel write和redo size設定Parallel
- imagick使用readImage報錯 Failed to read the file 或者沒有報錯內容的解決方法AI
- ORA-28056 Writing audit records to Windows Event Log failedWindowsAI
- ORA-28056: Writing audit records to Windows Event Log failedWindowsAI
- rsau/max_diskspace/local - Maximum space for security audit file
- rsau/max_diskspace/per_file - Maximum size of one single security audit file
- control file parallel write事件小記Parallel事件
- [轉載]Oracle等待事件Data file init writeOracle事件
- Android Gradle Build Error:Some file crunching failed, see logs for details解決辦法AndroidGradleUIErrorAI
- Stale NFS file handle的解決方法NFS
- Oracle之 等待事件log file sync + log file parallel write (awr優化)Oracle事件Parallel優化
- No input file specified 解決方法
- ftp 報錯 550 Failed to open fileFTPAI
- log file sync(日誌檔案同步) 與 Log file parallel write 等待事件Parallel事件
- Redhat 下 ASM oracleasm deletedisk -failed 的解決方法RedhatASMOracledeleteAI
- 關於Failed to resolve的問題解決AI
- ORA-31617 unable to open dump file for write
- 解決：Failed to load ApplicationContextAIAPPContext
- gitbook no such file or directory 怎麼解決Git
- flume file channel 異常解決