ORA-7445(opipls)錯誤

客戶的9206資料庫出現ORA-7445錯誤。

[@more@]

錯誤資訊：

Fri Apr 17 09:11:24 2009
Errors in file /opt/app/admin/orcl/udump/orcl1_ora_15039.trc:
ORA-07445: exception encountered: core dump [000000010102BD1C] [SIGSEGV] [Address not mapped to object] [0x000000004] [] []
Fri Apr 17 09:11:25 2009
Trace dumping is performing id=[cdmp_20090417091125]

導致該錯誤詳細資訊：

*** 2009-04-17 09:11:24.746
*** SESSION ID:(107.25) 2009-04-17 09:11:24.738
Exception signal: 11 (SIGSEGV), code: 1 (Address not mapped to object), addr: 0x4, PC: [0x10102bd1c, 000000010102BD1C]
*** 2009-04-17 09:11:24.746
ksedmp: internal or fatal error
ORA-07445: exception encountered: core dump [000000010102BD1C] [SIGSEGV] [Address not mapped to object] [0x000000004] [] []
Current SQL statement for this session:
SELECT /*+ USE_NL(store) USE_NL(dn) INDEX(store EI_ATTRSTORE) ORDERED */ store.eid,AttrName,NVL(AttrVal,),attrkind,NVL(attrstype, ),NVL(AttrVer,) FROM C_D dn, ds_attr store WHERE (dn.rdn = :szName AND dn.parentdn = :szDomain) AND store.eid = dn.eid
----- PL/SQL Call Stack -----
object line object
handle number name
5dbc4a990 244 package body ODS.OLADD
5df8530c0 1 anonymous block
----- Call Stack Trace -----
calling call entry argument values in hex
location type point (? means dubious value)
-------------------- -------- -------------------- ----------------------------
ksedmp()+328 CALL ksedst() 00000000B ? 000000000 ?
000000000 ? 00000004A ?
FFFFFFFF7FFF00F8 ?
1032E18E8 ?
ssexhd()+676 CALL ksedmp() 000103705 ? 103705000 ?
103705468 ? 10370A000 ?
000102C00 ? 000000000 ?
sigacthandler()+44 PTR_CALL 0000000000000000 00010370D ?
FFFFFFFF7FFF7190 ?
10370D000 ? 10370A620 ?
000000000 ? 10370D578 ?
opipls()+1180 PTR_CALL 0000000000000000 00000000B ?
FFFFFFFF7FFF7190 ?
FFFFFFFF7FFF6EB0 ?
10382B700 ? 000000000 ?
FFFFFFFFFFFFFF4A ?
opiodr()+1688 PTR_CALL 0000000000000000 000000000 ? 000000001 ?
FFFFFFFF7C94EE98 ?
000000005 ? 000000002 ?
103705808 ?
rpidrus()+144 CALL opiodr() 000103400 ? 10102B880 ?
102EB849A ? 103705808 ?
103707D40 ?
FFFFFFFF7FFF7FA0 ?
skgmstack()+156 PTR_CALL 0000000000000000 00000000B ? 000000066 ?
103705808 ?
FFFFFFFF7CA6A7E0 ?
FFFFFFFF7FFF81B0 ?
000103400 ?
rpidru()+160 CALL skgmstack() FFFFFFFF7FFF83D8 ?
1037051F0 ? 00000F618 ?
10022A300 ?
FFFFFFFF7FFF8400 ?
00193EAA4 ?
rpiswu2()+384 PTR_CALL 0000000000000000 FFFFFFFF7FFF8AD8 ?
FFFFFFFF7FFF8D70 ?
00000000C ? 000000410 ?
000103705 ? 00010022A ?
rpidrv()+1432 CALL rpiswu2() 5C42DBC48 ? 000103705 ?
103705690 ? 1037056C8 ?
000000000 ? 10329F000 ?
psddr0()+156 CALL rpidrv() 000100000 ? 000110424 ?
FFFFFFFF7FFF89DC ?
00000003A ? 5C42DBC48 ?
000100000 ?
psdnal()+344 CALL psddr0() 103705468 ? 102EBA518 ?
FFFFFFFF7FFF8D70 ?
1037056C8 ? 000000140 ?
103705808 ?
pevm_EXECC()+324 PTR_CALL 0000000000000000 FFFFFFFF7FFFB100 ?
FFFFFFFF7FFFB278 ?
000001B58 ?
FFFFFFFF7C94EE98 ?
5DBC4A990 ? 000000001 ?
pfrrun()+3244 CALL pevm_EXECC() 000000000 ? 103814EC8 ?
000000000 ?
FFFFFFFF7CA6A778 ?
000000000 ?
FFFFFFFF7C94EE98 ?
peicnt()+268 CALL pfrrun() 00000122C ?
FFFFFFFF7FFFB100 ?
FFFFFFFF7CA6A778 ?
FFFFFFFF7CA6A7E0 ?
5C42DC6A8 ? 103705808 ?
kkxexe()+524 CALL peicnt() FFFFFFFF7FFFB100 ?
FFFFFFFF7CA6A778 ?
000000009 ? 103829160 ?
000102C00 ?
FFFFFFFF7FFFAF78 ?
opiexe()+9256 CALL kkxexe() 000103400 ? 000000000 ?
00000FFFB ?
FFFFFFFF7CA6A778 ?
000000000 ? 103705468 ?
opiall0()+1776 CALL opiexe() 00000002E ? 10370D808 ?
FFFFFFFF7CA60680 ?
10370D800 ?
FFFFFFFF7C953850 ?
103705808 ?
kpoal8()+1040 CALL opiall0() 000000000 ? 00000005E ?
FFFFFFFF7FFFC218 ?
103705808 ?
FFFFFFFF7C953850 ?
FFFFFFFF7FFFC5A8 ?
opiodr()+1688 PTR_CALL 0000000000000000 000000000 ? 000000000 ?
FFFFFFFF7FFFEA60 ?
000000024 ? 000000000 ?
0000022B0 ?
ttcpip()+1556 PTR_CALL 0000000000000000 000103400 ? 100FBBFC0 ?
10370D808 ? 103705808 ?
103707D40 ?
FFFFFFFF7FFFCC00 ?
opitsk()+984 CALL ttcpip() 10370D800 ? 000000014 ?
FFFFFFFF7FFFEA60 ?
000000000 ? 000000000 ?
FFFFFFFF7FFFDD4C ?
opiino()+1572 CALL opitsk() 000000000 ? 000000000 ?
000000000 ? 000000000 ?
103707D28 ?
FFFFFFFF7FFFEBB4 ?
opiodr()+1688 PTR_CALL 0000000000000000 000380007 ? 10370C658 ?
1037F9458 ?
FFFFFFFF7FFFF8F0 ?
000000000 ? 5C1447BA0 ?
opidrv()+736 CALL opiodr() 000103400 ? 10100C380 ?
10370D808 ? 103705808 ?
103707D40 ?
FFFFFFFF7FFFF410 ?
sou2o()+16 CALL opidrv() 000000000 ? 000000004 ?
1037051EC ? 00000003C ?
1037056C8 ? 000103400 ?
main()+184 CALL sou2o() FFFFFFFF7FFFF910 ?
00000003C ? 000000004 ?
FFFFFFFF7FFFF8F0 ?
000039E70 ? 000000000 ?
_start()+380 CALL main() 000000002 ?
FFFFFFFF7FFFFA58 ?
FFFFFFFF7FFFFA70 ?
000000000 ? 000000000 ?
100000000 ?

--------------------- Binary Stack Dump ---------------------

分析錯誤資訊，這個錯誤與Bug 2662683 - Heap corruption from schema name overwriting memory in PLSQL [ID 2662683.8]描述的問題比較類似，尤其是會話DUMP部分，似乎也存在問題描述的名稱覆蓋的問題：

Argument/Register addr=0x0000000103824760.
Dump of memory from 0x0000000103824720 to 0x0000000103824860
103824720 00000000 000028D1 00000000 00000000 [......(.........]
103824730 000028D0 00000000 00000001 03705470 [..(..........pTp]
103824740 00000001 03820698 10B38F00 000028B9 [..............(.]
103824750 00000000 00000000 00000001 032FF0B0 [............./..]
103824760 0000ABAB 00000000 00000001 03824770 [..............Gp]
103824770 00000001 03708CF0 0000FF80 00000000 [.....p..........]
103824780 00000005 C42DBC48 FFFFFFFF 7C950080 [.....-.H....|...]
103824790 FFFFFFFF 7C952E68 00000000 00000000 [....|..h........]
1038247A0 00000000 00000000 00021203 00000000 [................]
1038247B0 00000000 00000000 0000FF80 73657373 [............sess]
1038247C0 696F6E20 68656170 00000000 7FFF7FFF [ion heap........]
1038247D0 7FFF0098 00000000 00000000 00000000 [................]
1038247E0 00000000 00000038 FFFFFFFF 7C93EBD0 [.......8....|...]
1038247F0 FFFFFFFF 7CA6A368 00000000 00000058 [....|..h.......X]
103824800 FFFFFFFF 7C953648 FFFFFFFF 7C953648 [....|.6H....|.6H]
103824810 00000000 00000098 00000001 03824818 [..............H.]
103824820 00000001 03824818 00000000 000000A8 [......H.........]
103824830 00000001 03824830 00000001 03824830 [......H0......H0]
103824840 00000000 00000118 00000001 03824848 [..............HH]
103824850 00000001 03824848 00000000 000001B0 [......HH........]
Argument/Register addr=0x00000005DBC4AAB0.
Dump of memory from 0x00000005DBC4AA70 to 0x00000005DBC4ABB0
5DBC4AA70 00000001 00000000 0000000A 00000000 [................]
5DBC4AA80 00000005 DBC4AA80 00000005 DBC4AA80 [................]
5DBC4AA90 00000024 00000000 00000005 DBC4AA98 [...$............]
5DBC4AAA0 00000005 DBC4AA98 00000000 00000000 [................]
5DBC4AAB0 F61D1590 4C434E43 3839494F EC7F614B [....LCNC89IO..aK]
5DBC4AAC0 01000000 00000000 00786806 1013312A [.........xh...1*]
5DBC4AAD0 00000000 00000000 00000000 00000005 [................]
5DBC4AAE0 03000000 00000000 00000000 00000000 [................]
5DBC4AAF0 4F4C4144 444F4453 00000000 00000000 [OLADDODS........]
5DBC4AB00 00000000 00000000 00000000 00000000 [................]

這個BUG在9.2.0.3中被FIXED，但是不排除在9206中重新引入，低於10.1.0.2版本都可能碰到這個錯誤。Oracle在個別平臺和版本上提供了單獨的補丁，此外只能透過升級到10.1.0.2以上才能避免這個錯誤。