kewastUnPackStats(): bad magic 1 (0x0000000036407DFA, 0)

联系:手机(13429648788)  QQ(107644445)

链接:https://www.orasos.com/kewastunpackstats-bad-magic-1-0x0000000036407dfa-0.html

标题:kewastUnPackStats(): bad magic 1 (0x0000000036407DFA, 0)

作者:惜分飞©版权所有[文章允许转载,但必须以链接方式注明源地址,否则追究法律责任.]

alert日志错误kewastUnPackStats(): bad magic 1 (0x0000000036407DFA, 0)
该错误是出现在win 2008 + 11.2.0.1的数据库中

Sun Jun 03 01:00:05 2012
kewastUnPackStats(): bad magic 1 (0x0000000036407DFA, 0)
kewastUnPackStats(): bad magic 1 (0x0000000036407DFA, 0)
kewastUnPackStats(): bad magic 1 (0x0000000036407DD8, 0)
kewastUnPackStats(): bad magic 1 (0x0000000036407DD8, 0)
kewastUnPackStats(): bad magic 1 (0x0000000036407DD8, 0)
kewastUnPackStats(): bad magic 1 (0x0000000036407DD8, 0)
kewastUnPackStats(): bad magic 1 (0x0000000036407DF0, 0)
kewastUnPackStats(): bad magic 1 (0x0000000036407DF0, 0)
kewastUnPackStats(): bad magic 1 (0x0000000036407DD8, 0)
kewastUnPackStats(): bad magic 1 (0x0000000036407DD8, 0)
Sun Jun 03 02:00:18 2012
kewastUnPackStats(): bad magic 1 (0x0000000035387DD4, 0)
kewastUnPackStats(): bad magic 1 (0x0000000035387DD4, 0)
kewastUnPackStats(): bad magic 1 (0x0000000035387DDC, 0)
kewastUnPackStats(): bad magic 1 (0x0000000035387DDC, 0)
kewastUnPackStats(): bad magic 1 (0x0000000035387DDC, 0)
kewastUnPackStats(): bad magic 1 (0x0000000035387DDC, 0)
kewastUnPackStats(): bad magic 1 (0x0000000035387DDC, 0)
kewastUnPackStats(): bad magic 1 (0x0000000035387DDC, 0)
kewastUnPackStats(): bad magic 1 (0x0000000035387DDC, 0)
kewastUnPackStats(): bad magic 1 (0x0000000035387DDC, 0)
Sun Jun 03 03:00:32 2012
kewastUnPackStats(): bad magic 1 (0x000000001D8F7DD4, 0)
kewastUnPackStats(): bad magic 1 (0x000000001D8F7DD4, 0)
kewastUnPackStats(): bad magic 1 (0x000000001D8F7DDC, 0)
kewastUnPackStats(): bad magic 1 (0x000000001D8F7DDC, 0)
kewastUnPackStats(): bad magic 1 (0x000000001D8F7DDC, 0)
kewastUnPackStats(): bad magic 1 (0x000000001D8F7DDC, 0)
kewastUnPackStats(): bad magic 1 (0x000000001D8F7DD4, 0)
kewastUnPackStats(): bad magic 1 (0x000000001D8F7DD4, 0)
kewastUnPackStats(): bad magic 1 (0x000000001D8F7DD4, 0)
kewastUnPackStats(): bad magic 1 (0x000000001D8F7DD4, 0)
kewastUnPackStats(): bad magic 1 (0x000000001D8F7DDC, 0)

错误原因:
出现该问题是 Bug:8967729/unpublished bug 8730312
Active Session History中某些数据(the moduile, action program, etc. information)未被正确存储,然后awr程序在整点(默认配置)的时候访问V$ACTIVE_SESSION_HISTORY 视图失败,从而出现了该错误.出现该问题可能导致ash和awr使用异常或不准确

问题解决:
1.在Oracle12c release and the 11.2.0.2 and higher patchsets中被修复
2.打上one-off Patch:8730312(one-off补丁没有经过oracle的严格测试,在打该补丁前可能需要进行测试)

One thought on “kewastUnPackStats(): bad magic 1 (0x0000000036407DFA, 0)

  1. Kewastunpackstats(): Bad Magic 1 (0x1108f7b87, 0) In Alert Logfile After Upgrading to 11.2.0.1

    Applies to:
    Oracle Server - Enterprise Edition - Version: 9.2.0.8 and later [Release: 9.2 and later ]
    Information in this document applies to any platform.
    Kewastunpackstats(): Bad Magic 1 (0x1108f7b87, 0) in Alert Logfile After Upgrading to 11.2.0.1
    
    Symptoms
    The following message is reported in the instance alert file:
    
    kewastUnPackStats(): bad magic 1 (0x1108f7b87, 0)
    
    Cause
    The cause of this problem has been identified in Bug:8967729 which has been closed 
    as duplicate of unpublished bug 8730312.It is caused by the variable part of 
    the Active Session History rows (the moduile, action program, etc. information) 
    not being stored properly, causing any read-back of this data through views like 
    (G)V$ACTIVE_SESSION_HISTORY to fail.
    
    Solution
    The issue has been fixed in the upcoming Oracle12c release and the 11.2.0.2 and higher patchsets. 
    The solution is to install the 11.2.0.3 patchset 
    (which is the current patchset at time of publishing this Note (MAR-2012).
    
    Apply Patch:8730312 for any other environments.
    As one-off patches are not subjected to the same rigorous level of testing as done 
    for Oracle Server patch sets, you are encouraged to install and test this patch 
    in a test environment prior to full production implementation.
    

Comments are closed.