ORA-07445:出現異常錯誤:核心轉儲[kkqfppDrv1()+101]Address not mapped to object
Exception [type: SIGSEGV, Address not mapped to object] [ADDR:0x118] [PC:0x1CE6BEB, kkqfppDrv1()+101] [flags: 0x0, count: 1]
Errors in file *_ora_31425.trc (incident=37965):
ORA-07445: 出現異常錯誤: 核心轉儲 [kkqfppDrv1()+101] [SIGSEGV] [ADDR:0x118] [PC:0x1CE6BEB] [Address not mapped to object] []
Incident details in: *_ora_31425_i37965.trc
檢視日誌發現是with與distinct同時使用,類似於如下
with a as(
select * from testa
),b as (
select ip,count(distinct cust_id) cust_num
from a
group by ip
)
select * from b;
在王、趙總的幫助下,確認為oracle的bug,解決方法有兩種:
打補丁:If you are installing using Oracle Database 11g Release 2 (11.2.0.1.0), then ensure that you apply the patch for bug# 9002336 and 9067282
修改sql:with與distinct不能同時使用。
此次為修改sql解決
Description
Dump in kkqfppDrv1 of a query containing WITH clause and distinct aggregates.
It is possible to dump or spin in other functions too.
來自 “ ITPUB部落格 ” ,連結:http://blog.itpub.net/28258625/viewspace-1654896/,如需轉載,請註明出處,否則將追究法律責任。
相關文章
- ORA-07445 : 出現異常錯誤: 核心轉儲
- ORA-07445 : 出現異常錯誤: 核心轉儲(一)
- ORA-07445: 出現異常錯誤: 核心轉儲 [kkqstcrf()+1355]CRF
- ORA-07445: 出現異常錯誤: 核心轉儲 [plcurClose()+40] [SIGSEGV]Gse
- ORA-07445: 出現異常錯誤: 核心轉儲 [ldxsnf()+625] [SIGSEGVGse
- ORA-07445: 出現異常錯誤: 核心轉儲 [kcbs_simulate()+5112]
- ORA-07445 [kkoipt()+3881] [SIGSEGV] [Address not mapped to object]GseAPPObject
- ORA-07445:oracle_[type: SIGSEGV, Address not mapped to object]OracleGseAPPObject
- ORA-07445 [opidsa()+386] [SIGSEGV] [Address not mapped to object]GseAPPObject
- ORA-07445: [opitca()+4618] [SIGSEGV] [Address not mapped to object]GseAPPObject
- Oracle 10g RAC (10.2.0.3) : ORA-07445:[opidsa()+386] [SIGSEGV] [Address not mapped to object]Oracle 10gGseAPPObject
- ORA-07445: exception encountered: core dump [kksIsNLSEqual()+72] [SIGSEGV] [Address not mapped to obExceptionGseAPP
- ORA-07445異常報錯opixguid()+13GUI
- Ubuntu20.04出現段錯誤核心已轉儲問題解決方案Ubuntu
- ORACLE 異常錯誤 錯誤號大全Oracle
- PHP錯誤和異常PHP
- PHP 核心知識點(一)異常和錯誤處理PHP
- 10.2.0.1資料庫exp出現Ora-07445錯誤資料庫
- 訪問資料庫出現Object reference not set to an instance of an object錯誤資料庫Object
- 異常錯誤資訊處理
- python錯誤與異常Python
- Flutter之異常和錯誤Flutter
- Oracle異常錯誤處理Oracle
- ORACLE 異常錯誤處理Oracle
- php錯誤及異常捕捉PHP
- 經常出現 HTTP Status 500 -錯誤HTTP
- 錯誤和異常 (一):錯誤基礎知識
- Struts+Hibernate+Spring出現異常錯誤,高手指點,謝謝!Spring
- Swift 中的錯誤與異常Swift
- ORA-07445錯誤分析
- web前端之異常/錯誤監控Web前端
- php錯誤與異常處理方法PHP
- goang 錯誤&異常處理機制Go
- C++錯誤和異常處理C++
- Laravel Exceptions——異常與錯誤處理LaravelException
- PHP基礎之錯誤與異常PHP
- web前端小白經常出現“四”個錯誤Web前端
- postfix時常提示出現關於set-uid的錯誤(轉)UI