I raised a call with Oracle before I went home but there's been no updates on it as of yet, other than a note saying they will update it when they have some information (fair enough I suppose). This long silence is worrying, maybe it's something serious?
Here's the header of the trace file:
*** 2006-05-19 10:57:39.159
*** SESSION ID:(21.4255) 2006-05-19 10:57:39.158
Exception signal: 11 (SIGSEGV), code: 1 (Address not mapped to object), addr: 0x0, PC: [0x1009b0b04, 00000001009B0B04]
*** 2006-05-19 10:57:39.159
ksedmp: internal or fatal error
ORA-07445: exception encountered: core dump [00000001009B0B04] [SIGSEGV] [Address not mapped to object] [0x000000000] [] []
Current SQL statement for this session:
select all count(dm_type.r_object_id) "the_count" from dm_type_sp dm_type where (dm_type.name=:"SYS_B_0" and exists (select r_object_id from dm_type_r where dm_type.r_object_id = r_object_id and attr_name=:"SYS_B_1"))
----- Call Stack Trace -----
calling call entry argument values in hex
location type point (? means dubious value)
-------------------- -------- -------------------- ----------------------------
ksedmp()+328 CALL ksedst() 00000000B ? 000000000 ?
000000000 ? 00000004A ?
FFFFFFFF7FFF3C78 ?
102F5E0F8 ?
ssexhd()+676 CALL ksedmp() 000103348 ? 103348000 ?
103348CA8 ? 10334D000 ?
000102800 ? 000000000 ?
sigacthandler()+44 PTR_CALL 0000000000000000 000103350 ?
FFFFFFFF7FFFAD10 ?
103350000 ? 10334DE60 ?
000000000 ? 103350DB8 ?
evaopn2()+196 PTR_CALL 0000000000000000 00000000B ?
FFFFFFFF7FFFAD10 ?
FFFFFFFF7FFFAA30 ?
00010334B ? 000000000 ?
000000000 ?
qerixGetKey()+1420 CALL evaopn2() 3966E1C20 ? 000010000 ?
103350000 ? 000000001 ?
080000002 ?
FFFFFFFF7CB20288 ?
qerixStart()+956 CALL qerixGetKey() 000000000 ? 3966E1DE0 ?
FFFFFFFFFFFFFFFF ?
FFFFFFFF7CB31C98 ?
000103000 ?
FFFFFFFF7CB316C0 ?
qertbStart()+1044 PTR_CALL 0000000000000000 396780958 ? 0001A2C91 ?
000000000 ?
FFFFFFFF7CB325EC ?
FFFFFFFF7CB32528 ?
1033503A8 ?
qerjoFetch()+396 PTR_CALL 0000000000000000 102AE1000 ? 000000001 ?
10334B208 ? 000000018 ?
000103000 ? 3950B5A90 ?
qerstFetch()+212 PTR_CALL 0000000000000000 3966E24A8 ? 1016276A0 ?
FFFFFFFF7FFFB558 ?
000007FFF ? 0000005F8 ?
FFFFFFFF7CB31488 ?
qergsFetch()+2268 PTR_CALL 0000000000000000 3966E2440 ? 000000014 ?
000000005 ? 00000000F ?
0000000F0 ? 000007FFF ?
qerstFetch()+212 PTR_CALL 0000000000000000 000101400 ?
FFFFFFFF7CB31820 ?
000000000 ? 000000028 ?
1016276A0 ? 3966E23A8 ?
opifch2()+1724 PTR_CALL 0000000000000000 3966E2340 ? 00000010C ?
000000043 ? 0000000C9 ?
000000C90 ? 000000028 ?
opiall0()+3860 CALL opifch2() 100FD2000 ? 102AE1398 ?
100FA6640 ? 000000012 ?
FFFFFFFF7FFFBB20 ?
FFFFFFFF7FFFC14C ?
kpoal8()+1040 CALL opiall0() 000000000 ? 00000005E ?
FFFFFFFF7FFFC3D8 ?
103349048 ?
FFFFFFFF7CB206B0 ?
FFFFFFFF7FFFC768 ?
opiodr()+1688 PTR_CALL 0000000000000000 000000000 ? 000000028 ?
FFFFFFFF7FFFEC20 ?
000000024 ? 000000000 ?
0000022B0 ?
ttcpip()+1556 PTR_CALL 0000000000000000 000103000 ? 100F8D200 ?
103351048 ? 103349048 ?
10334B580 ?
FFFFFFFF7FFFCDC0 ?
opitsk()+984 CALL ttcpip() 103351040 ? 000000014 ?
FFFFFFFF7FFFEC20 ?
000000000 ? 000000000 ?
FFFFFFFF7FFFDF0C ?
opiino()+1572 CALL opitsk() 000000000 ? 000000000 ?
000000000 ? 000000000 ?
10334B568 ?
FFFFFFFF7FFFED74 ?
opiodr()+1688 PTR_CALL 0000000000000000 000380007 ? 10334FE98 ?
103411DE8 ?
FFFFFFFF7FFFFAB0 ?
000000000 ? 392ACB4C8 ?
opidrv()+736 CALL opiodr() 000103000 ? 100FDD5C0 ?
103351048 ? 103349048 ?
10334B580 ?
FFFFFFFF7FFFF5D0 ?
sou2o()+16 CALL opidrv() 000000000 ? 000000004 ?
103348A2C ? 00000003C ?
103348F08 ? 000103000 ?
main()+184 CALL sou2o() FFFFFFFF7FFFFAD0 ?
00000003C ? 000000004 ?
FFFFFFFF7FFFFAB0 ?
00002E708 ? 000000000 ?
_start()+380 CALL main() 000000002 ?
FFFFFFFF7FFFFC18 ?
FFFFFFFF7FFFFC30 ?
000000000 ? 000000000 ?
100000000 ?
Hope they get back to me soon!
[Edited to Add: See the solution to ORA-07445: exception encountered: core dump [00000001009B0B04] [SIGSEGV] [Address not mapped to object] [0x000000000] [] [].]
1 comment:
See Metalink note 4098853.8
Bug 4098853 - Dump (qerixGetKey->evaopn2) using COUNT(NOT_NULL_COLUMN) with a view.
There is a workaround documented
Cheers!
Post a Comment