ITPub博客

首页 > 数据库 > Oracle > BUG Kewastunpackstats(): Bad Magic 1 (xxx,0)

BUG Kewastunpackstats(): Bad Magic 1 (xxx,0)

翻译 Oracle 作者:monkeybron 时间:2015-04-02 10:14:48 0 删除 编辑

ALERT日志出现:


kewastUnPackStats(): bad magic 1 (0x7f3521c489a0, 0)
kewastUnPackStats(): bad magic 1 (0x7f3521c489a0, 0)
kewastUnPackStats(): bad magic 1 (0x7f3521c458e0, 0)
kewastUnPackStats(): bad magic 1 (0x7f3521c458e0, 0)
kewastUnPackStats(): bad magic 1 (0x7f3521c458e0, 0)
kewastUnPackStats(): bad magic 1 (0x7f3521c458e0, 0)
kewastUnPackStats(): bad magic 1 (0x7f3521c458e0, 0)
kewastUnPackStats(): bad magic 1 (0x7f3521c458e0, 0)
kewastUnPackStats(): bad magic 1 (0x7f3521c458e0, 0)
kewastUnPackStats(): bad magic 1 (0x7f3521c458e0, 0)
kewastUnPackStats(): bad magic 1 (0x7f3521c48ad0, 0)
kewastUnPackStats(): bad magic 1 (0x7f3521c48ad0, 0)
kewastUnPackStats(): bad magic 1 (0x7f3521c48ad0, 0)
kewastUnPackStats(): bad magic 1 (0x7f3521c48ad0, 0)



SQL> select * from v$version;    

BANNER
--------------------------------------------------------------------------------
Oracle Database 11g Enterprise Edition Release 11.2.0.1.0 - 64bit Production
PL/SQL Release 11.2.0.1.0 - Production
CORE    11.2.0.1.0      Production
TNS for Linux: Version 11.2.0.1.0 - Production
NLSRTL Version 11.2.0.1.0 - Production

SQL> show parameter comp

NAME                                 TYPE        VALUE
------------------------------------ ----------- ------------------------------
cell_offload_compaction              string      ADAPTIVE
compatible                           string      11.2.0.0.0
nls_comp                             string      BINARY
plsql_v2_compatibility               boolean     FALSE



这是一个已知BUG导致的,主要是由于升级到11g后的一些变更导致的,以下是MOS的相关文档:
Kewastunpackstats(): Bad Magic 1 (0x1108f7b87, 0) In Alert Logfile After Upgrading to 11.2.0.1 (Doc ID 1227524.1)



文档提示,这是由于ASH信息读取出错导致的:


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.

11.2.0.2之后的补丁集中被修正。

来自 “ ITPUB博客 ” ,链接:https://blog.itpub.net/30182853/viewspace-1482637/ ,如需转载,请注明出处,否则将追究法律责任。

请登录后发表评论 登录
全部评论

注册时间:2015-03-30

  • 博文量
    70
  • 访问量
    94588