kewastUnPackStats(): bad magic 1 (0x7f92ce11cbab, 0)
平臺：Linux-x86_64 +oracle 11.2.0.1
1,在檢查中發現alert日誌中報以下錯誤：
Wed Sep 25 13:00:08 2012
kewastUnPackStats(): bad magic 1 (0x7f92ce11cbab, 0)
kewastUnPackStats(): bad magic 1 (0x7f92ce11cbab, 0)
kewastUnPackStats(): bad magic 1 (0x7f92ce11ccc3, 0)
kewastUnPackStats(): bad magic 1 (0x7f92ce11ccc3, 0)
kewastUnPackStats(): bad magic 1 (0x7f92ce11ccc3, 0)
kewastUnPackStats(): bad magic 1 (0x7f92ce11ccc3, 0)
kewastUnPackStats(): bad magic 1 (0x7f92ce11ccbb, 0)
kewastUnPackStats(): bad magic 1 (0x7f92ce11ccbb, 0)
kewastUnPackStats(): bad magic 1 (0x7f92ce11ccc3, 0)
kewastUnPackStats(): bad magic 1 (0x7f92ce11ccc3, 0)
kewastUnPackStats(): bad magic 1 (0x7f92ce11ccbb, 0)
kewastUnPackStats(): bad magic 1 (0x7f92ce11ccbb, 0)
kewastUnPackStats(): bad magic 1 (0x7f92ce11ccbb, 0)
kewastUnPackStats(): bad magic 1 (0x7f92ce11ccbb, 0)
kewastUnPackStats(): bad magic 1 (0x7f92ce11ccc3, 0)
kewastUnPackStats(): bad magic 1 (0x7f92ce11ccc3, 0)
kewastUnPackStats(): bad magic 1 (0x7f92ce11ccc3, 0)
kewastUnPackStats(): bad magic 1 (0x7f92ce11ccc3, 0)
kewastUnPackStats(): bad magic 1 (0x7f92ce11ca72, 0)
kewastUnPackStats(): bad magic 1 (0x7f92ce11ca72, 0)
kewastUnPackStats(): bad magic 1 (0x7f92ce11ccbb, 0)
kewastUnPackStats(): bad magic 1 (0x7f92ce11ccbb, 0)
kewastUnPackStats(): bad magic 1 (0x7f92ce11ca6a, 0)
kewastUnPackStats(): bad magic 1 (0x7f92ce11ca6a, 0)
kewastUnPackStats(): bad magic 1 (0x7f92ce11ccc3, 0)
2，問題分析：
這是oracle的已知bug,Bug:8967729/ un-published bug 8730312
該報錯可能出現在oracle9.2.0.8-11.2.0.1任何平臺上資料庫的alert日誌中
該Bug觸發的原因是，Active Session History中的可變部分(the moduile, action program, etc. information)未被正確儲存，導致
訪問V$ACTIVE_SESSION_HISTORY 檢視失敗。
3，解決方案：
1，升級資料庫，在12C和 11.2.0.2以後的版本中已修改該Bug.
2, 打Patch:8730312修改該Bug（用這種方法修復時，需要在測試系統測試後再實施）
參考：MOS文章（Doc ID 1227524.1）
1,在檢查中發現alert日誌中報以下錯誤：
Wed Sep 25 13:00:08 2012
kewastUnPackStats(): bad magic 1 (0x7f92ce11cbab, 0)
kewastUnPackStats(): bad magic 1 (0x7f92ce11cbab, 0)
kewastUnPackStats(): bad magic 1 (0x7f92ce11ccc3, 0)
kewastUnPackStats(): bad magic 1 (0x7f92ce11ccc3, 0)
kewastUnPackStats(): bad magic 1 (0x7f92ce11ccc3, 0)
kewastUnPackStats(): bad magic 1 (0x7f92ce11ccc3, 0)
kewastUnPackStats(): bad magic 1 (0x7f92ce11ccbb, 0)
kewastUnPackStats(): bad magic 1 (0x7f92ce11ccbb, 0)
kewastUnPackStats(): bad magic 1 (0x7f92ce11ccc3, 0)
kewastUnPackStats(): bad magic 1 (0x7f92ce11ccc3, 0)
kewastUnPackStats(): bad magic 1 (0x7f92ce11ccbb, 0)
kewastUnPackStats(): bad magic 1 (0x7f92ce11ccbb, 0)
kewastUnPackStats(): bad magic 1 (0x7f92ce11ccbb, 0)
kewastUnPackStats(): bad magic 1 (0x7f92ce11ccbb, 0)
kewastUnPackStats(): bad magic 1 (0x7f92ce11ccc3, 0)
kewastUnPackStats(): bad magic 1 (0x7f92ce11ccc3, 0)
kewastUnPackStats(): bad magic 1 (0x7f92ce11ccc3, 0)
kewastUnPackStats(): bad magic 1 (0x7f92ce11ccc3, 0)
kewastUnPackStats(): bad magic 1 (0x7f92ce11ca72, 0)
kewastUnPackStats(): bad magic 1 (0x7f92ce11ca72, 0)
kewastUnPackStats(): bad magic 1 (0x7f92ce11ccbb, 0)
kewastUnPackStats(): bad magic 1 (0x7f92ce11ccbb, 0)
kewastUnPackStats(): bad magic 1 (0x7f92ce11ca6a, 0)
kewastUnPackStats(): bad magic 1 (0x7f92ce11ca6a, 0)
kewastUnPackStats(): bad magic 1 (0x7f92ce11ccc3, 0)
2，問題分析：
這是oracle的已知bug,Bug:8967729/ un-published bug 8730312
該報錯可能出現在oracle9.2.0.8-11.2.0.1任何平臺上資料庫的alert日誌中
該Bug觸發的原因是，Active Session History中的可變部分(the moduile, action program, etc. information)未被正確儲存，導致
訪問V$ACTIVE_SESSION_HISTORY 檢視失敗。
3，解決方案：
1，升級資料庫，在12C和 11.2.0.2以後的版本中已修改該Bug.
2, 打Patch:8730312修改該Bug（用這種方法修復時，需要在測試系統測試後再實施）
參考：MOS文章（Doc ID 1227524.1）
來自 “ ITPUB部落格 ” ，連結：http://blog.itpub.net/25373498/viewspace-1071960/，如需轉載，請註明出處，否則將追究法律責任。
相關文章
- 日誌資訊:kewastUnPackStats(): bad magic 1AST
- kewastUnPackStats(): bad magic 1資訊說明AST
- kewastUnPackStats(): bad magic 1 (0x0000000022607DF0, 0)AST
- Oracle11g bug - kewastUnPackStats(),bad magic 1OracleAST
- oracle11.2 BUG kewastUnPackStats(): bad magic 1OracleAST
- Kewastunpackstats(): Bad Magic 1 (0x1108f7b87, 0) In Alert LogfileAST
- Bad magic number for central directory
- 錯誤收集:thread 1:exc_bad_access(code=1,address=0x70000008)thread
- Linux resize2fs: Bad magic number in super-block錯誤的解決方法LinuxBloC
- LVM XFS增加硬碟分割槽容量(resize2fs: Bad magic number in super-block while)LVM硬碟BloCWhile
- 告警日誌出現kewastUnPackStats資訊AST
- raid1+0 and raid0+1AI
- ORACLE ORA-00600之[kkoipt:incorrect pwj], [0], [0], [0], [2], [1], [1]Oracle
- kewastUnPackStats(): oracle 11.2.0.1的bug解決方法ASTOracle
- Bad Habits
- Xlib: Invalid MIT-MAGIC-COOKIE-1 key 解決方法MITCookie
- Opening socket connection to server localhost/0:0:0:0:0:0:0:1:2181. Will not attempt to authenticateServerlocalhost
- 搞定request.getRemoteAddr()獲取的值為0:0:0:0:0:0:0:1REM
- RAID 1+0和RAID 0+1的區別AI
- HttpServletRequest呼叫getRemoteAddr獲取IP返回0:0:0:0:0:0:0:1的問題HTTPServletREM
- Raid Raid0 Raid1 Raid5 Raid0+1 Raid1+0AI
- Magic Firewall 簡介
- Magic Bullet Suite for Mac最新資源 附 啟用工具 支援m1UIMac
- 查詢bad sqlSQL
- [譯] Flutter 從 0 到 1Flutter
- takes 0 positional arguments but 1 was given
- 淺談0/1切換
- raid 0 1 5 概述AI
- 榮耀Magic未來手機正式釋出 榮耀Magic真機圖賞
- SpringMVC 404:Bad requestSpringMVC
- 從 0 到 1 認識 TypescriptTypeScript
- 從0到1實現PromisePromise
- vue 由0到1實現Vue
- MQTT QoS 0, 1, 2 介紹MQQT
- Android Router 從 0 到 1Android
- DiscuzX1-1.5Sql0day!!SQL
- main() takes 0 positional arguments but 1 was givenAI
- Opiino: Attach Failed! Error=-1 Ifvp=0AIError