始創(chuàng)于2000年股票代碼：831685

咨詢(xún)熱線(xiàn)：0371-60135900 注冊(cè)有禮登錄

掛牌上市企業(yè)
60秒人工響應(yīng)
99.99%連通率
7*24h人工
故障100倍補(bǔ)償

服務(wù)器租用

服務(wù)器托管

幫助中心

新手上路

代理登陸

投訴建議

加盟合作

常用文檔

ORA-07445 : 出現(xiàn)異常錯(cuò)誤: 核心轉(zhuǎn)儲(chǔ)

發(fā)布時(shí)間: 2012/9/5 17:00:39

ORA-07445: exception encountered: core dump [kghalp()+58] [SIGSEGV] [Address not mapped to object] [0x000000068] [] []

DUMP文件

*** SERVICE NAME:(orcl) 2012-07-12 14:18:55.016-

*** SESSION ID:(258.58198) 2012-07-12 14:18:55.016

Exception signal: 11 (SIGSEGV), code: 1 (Address not mapped to object), addr: 0x68, PC: [0x3c175e2, kghalp()+58]

*** 2012-07-12 14:18:55.030

ksedmp: internal or fatal error

ORA-07445: exception encountered: core dump [kghalp()+58] [SIGSEGV] [Address not mapped to object] [0x000000068] [] []

Current SQL statement for this session:

INSERT INTO MAILSENDER.GARBAGEDISTRIBUTING SELECT :B6 ,DOMAIN,MAX(CASE WHEN FLODER='ad' THEN COUNTNUM ELSE 0 END ) AS AD, MAX(CASE W

HEN FLODER='Garbage' THEN COUNTNUM ELSE 0 END) AS GARBAGE,:B3 ,:B5 ,:B4 FROM ( SELECT DOMAIN, FLODER, COUNT(MESSAGEINFOID) AS COUNTN

UM FROM( SELECT MBL.DOMAIN,T.MESSAGEINFOID,CASE WHEN REGEXP_SUBSTR(T.FLODER,'(Junk)|(QQ閭歡璁㈤槄)|(鍨冨溇閭歡)|(璁㈤槄閭歡)') IS NOT NULL

THEN 'Garbage' WHEN REGEXP_SUBSTR(T.FLODER,'(騫垮憡閭歡)') IS NOT NULL THEN 'ad' ELSE '' END AS FLODER FROM MESSAGEINFO T,MAILBOXLIST

MBL,TABLE(SPLITSTR(:B1 ,',')) TBEMAIL WHERE MBL.MAILBOXID=T.MAILBOXID AND TBEMAIL.COLUMN_VALUE=MBL.EMAIL AND T.ADDDATE BETWEEN :B3

AND :B2 AND (SELECT COUNT(*) FROM MESSAGEINFO M WHERE T.MAILID=M.MAILID AND T.MESSAGEINFOID<M.MESSAGEINFOID)<1) GROUP BY DOMAIN,FLOD

ER ) GROUP BY DOMAIN

----- PL/SQL Call Stack -----

object line object

handle number name

0x25b104658 23 package body MONITOR.PACKAGE_GARBAGEDISTRIBUTING

0x238b77b30 1 anonymous block

----- Call Stack Trace -----

calling call entry argument values in hex

location type point (? means dubious value)

-------------------- -------- -------------------- ----------------------------

Cannot find symbol

ksedst()+31 call ksedst1() 000000001 ? 000000001 ?

000000000 ? 000000000 ?

000000000 ? 000000001 ?

ksedmp()+610 call ksedst() 000000001 ? 000000001 ?

000000000 ? 000000000 ?

000000000 ? 000000001 ?

ssexhd()+630 call ksedmp() 000000003 ? 000000001 ?

000000000 ? 000000000 ?

000000000 ? 000000001 ?

__restore_rt()+0 call ssexhd() 00000000B ? 2B6124A48D70 ?

2B6124A48C40 ? 000000000 ?

000000000 ? 000000001 ?

<(nil)> call __restore_rt() 00000000B ? 2B6124A48D70 ?

2B6124A48C40 ? 000000000 ?

000000000 ? 000000001 ?

我們的ORA-07445，根據(jù)DUMP文件分析，多半是因?yàn)閬y碼問(wèn)題照成的，然后修改了服務(wù)器的字符集。（即添加export NLS_LANG=AMERICAN_AMERICA.ZHS16GBK）。然后跟進(jìn)我們這個(gè)包MONITOR.PACKAGE_GARBAGEDISTRIBUTING。一切OK了。

總結(jié)：亂碼問(wèn)題也可以導(dǎo)致ora-07445問(wèn)題。遇到問(wèn)題沉著冷靜，細(xì)心才可以把問(wèn)題解決好。

附表：

以下為網(wǎng)上收集的ORA-07445問(wèn)題

select owner,object_name,object_type,debuginfo
rom all_probe_objects
where object_name='TRI_XXX' and object_type like 'TRIGGER';

OWNER        OBJECT_NAME    OBJECT_TYPE     D
------------ -------------- ---------------     -
COPERATOR    TRI_XXX        TRIGGER             T

1 rows selected.

天哪，真是DEBUG狀態(tài)！
   一個(gè)因?yàn)樵贒EBUG狀態(tài)，且是基于DELETE的TRIGGER觸發(fā)了這個(gè)Oracle的BUG！
    ......
   現(xiàn)在要么改這個(gè)TRIGGER的狀態(tài)，要么打補(bǔ)�。�9.2.0.6）。第一種選擇是明智而快捷且安裝的。重新編譯，檢查不是DEBUG狀態(tài)。應(yīng)用啟動(dòng)，正常運(yùn)行

本文出自：億恩科技【www.riomediacenter.com】

服務(wù)器租用/服務(wù)器托管中國(guó)五強(qiáng)！虛擬主機(jī)域名注冊(cè)頂級(jí)提供商！15年品質(zhì)保障！--億恩科技[ENKJ.COM]