标题: kewastUnPackStats():bad magic in Alert Logfile After Upgrading to 11.2.0.1 [打印本页] 作者: 刘泽宇 时间: 2024-5-17 18:08 标题: kewastUnPackStats():bad magic in Alert Logfile After Upgrading to 11.2.0.1 现象：
The following message is reported in the instance alert file: (The hexadecimal string "0x1108f7b87" may be variable)
kewastUnPackStats(): bad magic 1 (0x1108f7b87, 0)
原因：
The cause of this problem has been identified in Bug:8967729 which has been closed as duplicate of un-published bug 8730312.
It is caused by the variable part of the Active Session History rows (the module, 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.
处理方法：
The issue has been fixed in the upcoming Oracle12c release and the 11.2.0.2 or higher patchsets.
For any environments where this is not available, apply Patch:8730312
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.