"kewastUnPackStats(): bad magic 1 (0xXXXXXXXXX, 0)" in Alert Logfile After Upgrading to 11.2.0.1 (文檔，

"kewastUnPackStats(): bad magic 1 (0xXXXXXXXXX, 0)" in Alert Logfile After Upgrading to 11.2.0.1 (文檔，


"kewastUnPackStats(): bad magic 1 (0xXXXXXXXXX, 0)" in Alert Logfile After Upgrading to 11.2.0.1 (文檔 ID 1227524.1)

轉到底部

In this Document Symptoms   Cause   Solution   References APPLIES TO:Oracle Database - Enterprise Edition - Version 9.2.0.8 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: (The hexadecimal string "0x1108f7b87" may be variable) 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 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. 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 or higher patchset. 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. REFERENCES BUG:8967729 - KEWASTUNPACKSTATS(): BAD MAGIC MESSAGE IN ALERT.LO