雨恩的生活日誌

我們的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天，也許半個月，也許很久才會出現一次

今天看郵件閘道主機的日誌時，一直看到freshclam有如下錯誤訊息： Dec  5 13:43:12 mail1 freshclam[15030]: daily.cld is up to date (version: 15680, sigs: 290708, f-level: 63, builder: guitar) Dec  5 13:43:14 mail1 freshclam[15030]: getfile: safebrowsing-40061.cdiff not found on remote server (IP: 120.119.118.1) Dec  5 13:43:14 mail1 freshclam[15030]: getpatch: Can't download safebrowsing-40061.cdiff from database.clamav.net Dec  5 13:43:15 mail1 last message repeated 4 times Dec  5 13:43:15 mail1 freshclam[15030]: Incremental update failed, trying to download safebrowsing.cvd Dec  5 13:43:27 mail1 freshclam[15030]: Downloading safebrowsing.cvd [100%] Dec  5 13:43:28 mail1 freshclam[15030]: Mirror 120.119.118.1 is not synchronized. Dec  5 13:43:28 mail1 freshclam[15030]: Trying again in 5 secs... Dec  5 13:43:31 mail1 freshclam[15030]: Update process terminated 想說為什麼會不能更新safebrowsing-xxxxx.cdiff, 難道是我們網路有問題，還是防火牆設定有問題。於是直接下指令freshclam查看，發現它一直吐出以下訊息，而且看來一直跑不完的樣子。 # freshclam ClamAV update