ORA-07445: Exception error: core dump

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

DUMP File

* ** Service name :( orcl) 2012-07-12 14:18:55. 016

* ** Session id: (258.58198) 14:18:55. 016

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

* ** 2012-07-12 14:18:55. 030

Ksedmp: internal or fatal error

ORA-07445: exception encountered: core dump [kghalkaline () + 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

Revoke 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) |

THEN 'garbage' WHEN REGEXP_SUBSTR (T. FLODER, '(broken down)') 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

Cannot find symbol

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 () limit B? 2B6124A48D70?

2B6124A48C40? 000000000?

000000000? 000000001?

<(Nil)> call _ restore_rt () limit B? 2B6124A48D70?

2B6124A48C40? 000000000?

000000000? 000000001?

Our ORA-07445, according to the DUMP file analysis, is mostly because of garbled issues, and then modified the server's character set. (Add export NLS_LANG = AMERICAN_AMERICA.ZHS16GBK ). Then follow up with our package MONITOR. PACKAGE_GARBAGEDISTRIBUTING. Everything is OK.

Summary: Garbled issues can also cause ora-07445 problems. If you encounter problems, you can solve them carefully.

Appendix:

The following are ORA-07445 issues collected online

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.

Oh, my God, it's really DEBUG!
This Oracle BUG is triggered by a DELETE-based TRIGGER in the DEBUG status!
......
Now you can either change the TRIGGER status or patch (9.2.0.6 ). The first option is wise, fast, and installed. Recompile and check whether the status is not DEBUG. The application starts and runs normally.