2012年12月6日 星期四

無解的錯誤訊息ORA-7445 [OPIXGUID()+13]?

我們的Oracle資料庫時有Core Dump, 錯誤訊息為ORA-7445 [OPIXGUID()+13],一直找不到真正的原因為何?有意思的是,在官方支援網站My Oracle Support上找相關文件,看到一篇文件Troubleshooting ORA-7445 [opixguid] [ID 1469649.1],它的內容:

Applies to:

Oracle Server - Enterprise Edition - Version 9.2.0.1 to 11.2.0.3 [Release 9.2 to 11.2]
Information in this document applies to any platform.

Symptoms

 Dumps in function opixguid can occur in 9i, 10g, 11g, caused by several bugs.

Cause

There are many bugs opened for ORA-7445 [opixguid], most of them being closed as Not a bug, Not reproducible, Suspended due to lack of information. Some examples:
11.2
Bug 12385064: ORA-7445 [OPIXGUID()+13]
11.1
Bug 9968142: ORA-7445 [OPIXGUID()+13] [SIGSEGV, ADDRESS NOT MAPPED TO OBJECT]
Bug 10225810: ORA-07445: EXCEPTION ENCOUNTERED: CORE DUMP [OPIXGUID()+000C]
9.2
Bug 2488563: ORA-07445: EXCEPTION ENCOUNTERED: CORE DUMP [OPIXGUID()+0]
...


簡單地說,客戶提了很多ORA-7445的錯誤,大部份他們以不是錯誤結案,或者是無法再現該錯誤,或因資訊不足而擱置。

這種錯誤,就是偶而出現,大部份時候都可以正常的跑SQL,也許10天,也許半個月,也許很久才會出現一次Core Dump, 是很難找的問題。也就是其再現性是隨機的,無規律的。目前看來,連官方也還沒找到真正的問題。

張貼留言