Locations of visitors to this page

Thursday, February 5, 2009

ora-7445 _intel_fast_memcpy

一种是,告警日志中报错 ora-7445 _inter_fast_memcpy.A()+10, 并有ora-7445 kgidmp 错误
Mon Feb  2 11:53:37 2009
Errors in file /home/oracle/app/oracle/admin/s3db/udump/s3db1_ora_16710.trc:
ORA-07445: exception encountered: core dump [_intel_fast_memcpy.A()+10] [SIGSEGV] [Invalid permissions for mapped object] [0x2ACC11C92000] [] []
Mon Feb  2 11:53:37 2009
Errors in file /home/oracle/app/oracle/admin/s3db/udump/s3db1_ora_16710.trc:
ORA-07445: exception encountered: core dump [kgidmp()+743] [SIGSEGV] [Address not mapped to object] [0x00008002C] [] []
ORA-07445: exception encountered: core dump [_intel_fast_memcpy.A()+10] [SIGSEGV] [Invalid permissions for mapped object] [0x2ACC11C92000] [] []
Mon Feb  2 11:53:38 2009
Errors in file /home/oracle/app/oracle/admin/s3db/udump/s3db1_ora_16710.trc:
ORA-07445: exception encountered: core dump [kgidmp()+743] [SIGSEGV] [Address not mapped to object] [0x00008002C] [] []
ORA-07445: exception encountered: core dump [kgidmp()+743] [SIGSEGV] [Address not mapped to object] [0x00008002C] [] []
ORA-07445: exception encountered: core dump [_intel_fast_memcpy.A()+10] [SIGSEGV] [Invalid permissions for mapped object] [0x2ACC11C92000] [] []

跟踪文件显示:
Exception signal: 11 (SIGSEGV), code: 2 (Invalid permissions for mapped object), addr: 0x2acc11c92000, PC: [0x2acc0f936608, _intel_fast_memcpy.A()+10]
*** 2009-02-02 11:53:37.421
ksedmp: internal or fatal error
ORA-07445: exception encountered: core dump [_intel_fast_memcpy.A()+10] [SIGSEGV] [Invalid permissions for mapped object] [0x2ACC11C92000] [] []
Current SQL statement for this session:
update SUBSCRIBERS set CHANNEL_HASH=:1, CHANNEL_HASH_TIMESTAMP =:2 WHERE ID=:3 and CHANNEL_HASH=:4
----- Call Stack Trace -----
calling              call     entry                argument values in hex
location             type     point                (? means dubious value)
-------------------- -------- -------------------- ----------------------------
ksedst()+31          call     ksedst1()            000000000 ? 000000001 ?
                                                   2ACC11614D50 ? 2ACC11614DB0 ?
                                                   2ACC11614CF0 ? 000000000 ?
ksedmp()+610         call     ksedst()             000000000 ? 000000001 ?
                                                   2ACC11614D50 ? 2ACC11614DB0 ?
                                                   2ACC11614CF0 ? 000000000 ?
ssexhd()+629         call     ksedmp()             000000003 ? 000000001 ?
                                                   2ACC11614D50 ? 2ACC11614DB0 ?
                                                   2ACC11614CF0 ? 000000000 ?
_L_mutex_unlock_15(  call     ssexhd()             00000000B ? 2ACC11615D70 ?
)+29                                               2ACC11615C40 ? 2ACC11614DB0 ?
                                                   2ACC11614CF0 ? 000000000 ?
_intel_fast_memcpy.  signal   _L_mutex_unlock_15(  2ACC11C91EF8 ? 2ACC11C92000 ?
A()+10                        )                    FFFFFFFFFFFFC108 ?
                                                   1FFFFFFFFFFB6C3D ?
                                                   000000040 ? 2ACC11A60C98 ?
upderh()+423         call     _intel_fast_memcpy.  2ACC11A4BFD8 ? 2ACC11C92000 ?
                              A()                  1FFFFFFFFFFB6C3D ?
                                                   1FFFFFFFFFFB6C3D ?
                                                   000000040 ? 2ACC11A60C98 ?
upduaw()+162         call     upderh()             2ACC11A4BFD8 ? 2ACC11C92000 ?
                                                   1FFFFFFFFFFB6C3D ?
                                                   1FFFFFFFFFFB6C3D ?
                                                   000000040 ? 2ACC11A60C98 ?
kdusru()+528         call     upduaw()             2ACC1194E388 ? 2ACC1194E4A0 ?
                                                   2ACC11A4D1E8 ? 090AA4EF0 ?
                                                   000000040 ? 2ACC11A60C98 ?
kauupd()+450         call     kdusru()             2ACC11A4BEE4 ? 090AA4E38 ?
                                                   2ACC11A4CF10 ? 000000000 ?
                                                   000000000 ? 2ACC11A60C98 ?
updrow()+1658        call     kauupd()             2ACC11A4BEE0 ? 090AA4E38 ?
                                                   2ACC11A4CF10 ? 000000000 ?
                                                   090AA73B0 ? 000000008 ?
qerupRowProcedure()  call     updrow()             090AA9D20 ? 000007FFF ?
+80                                                2ACC11A4CF10 ? 000000000 ?
                                                   090AA73B0 ? 000000008 ?
qerupFetch()+667     call     qerupRowProcedure()  090AA9D20 ? 000007FFF ?
                                                   2ACC11A4CF10 ? 000000000 ?
                                                   090AA73B0 ? 000000008 ?
updaul()+1065        call     qerupFetch()         000000008 ? 000000000 ?
                                                   090AA5C78 ? 000007FFF ?
                                                   090AA73B0 ? 090AA5EC0 ?
updThreePhaseExe()+  call     updaul()             090AA9D20 ? 7FFF9B18D160 ?
379                                                000000000 ? 2ACC1194E040 ?
                                                   090AA73B0 ? 090AA5EC0 ?
updexe()+600         call     updThreePhaseExe()   090AA9D20 ? 000000000 ?
                                                   2ACC11A4CF10 ? 7FFF9B18D280 ?
                                                   090AA73B0 ? 090AA5EC0 ?
opiexe()+4577        call     updexe()             090AA9D20 ? 000000000 ?
                                                   2ACC11A4CF10 ? 7FFF9B18D280 ?
                                                   000000000 ? 090AA5EC0 ?
kpoal8()+2273        call     opiexe()             000000049 ? 000000003 ?
                                                   7FFF9B18E510 ? 000000003 ?
                                                   000000000 ? 090AA5EC0 ?
opiodr()+984         call     kpoal8()             00000005E ? 000000017 ?
                                                   7FFF9B1913F0 ? 000000003 ?
                                                   000000001 ? 090AA5EC0 ?
ttcpip()+1012        call     opiodr()             00000005E ? 000000017 ?
                                                   7FFF9B1913F0 ? 000000000 ?
                                                   0059C0A30 ? 090AA5EC0 ?
opitsk()+1322        call     ttcpip()             00689E3B0 ? 7FFF9B18F2F8 ?
                                                   7FFF9B1913F0 ? 000000000 ?
                                                   7FFF9B190EE8 ? 7FFF9B191558 ?
opiino()+1026        call     opitsk()             000000003 ? 000000000 ?
                                                   7FFF9B1913F0 ? 000000001 ?
                                                   000000000 ? 4E5885500000001 ?
opiodr()+984         call     opiino()             00000003C ? 000000004 ?
                                                   7FFF9B1925B8 ? 000000000 ?
                                                   000000000 ? 4E5885500000001 ?
opidrv()+547         call     opiodr()             00000003C ? 000000004 ?
                                                   7FFF9B1925B8 ? 000000000 ?
                                                   0059C04E0 ? 4E5885500000001 ?
sou2o()+114          call     opidrv()             00000003C ? 000000004 ?
                                                   7FFF9B1925B8 ? 000000000 ?
                                                   0059C04E0 ? 4E5885500000001 ?
opimai_real()+163    call     sou2o()              7FFF9B192590 ? 00000003C ?
                                                   000000004 ? 7FFF9B1925B8 ?
                                                   0059C04E0 ? 4E5885500000001 ?
main()+116           call     opimai_real()        000000002 ? 7FFF9B192620 ?
                                                   000000004 ? 7FFF9B1925B8 ?
                                                   0059C04E0 ? 4E5885500000001 ?
__libc_start_main()  call     main()               000000002 ? 7FFF9B192620 ?
+244                                               000000004 ? 7FFF9B1925B8 ?
                                                   0059C04E0 ? 4E5885500000001 ?
_start()+41          call     __libc_start_main()  000723098 ? 000000002 ?
                                                   7FFF9B192778 ? 000000000 ?
                                                   0059C04E0 ? 000000002 ?

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


Exception signal: 11 (SIGSEGV), code: 1 (Address not mapped to object), addr: 0x8002c, PC: [0x408a2ff, kgidmp()+743]
*** 2009-02-02 11:53:37.846
ksedmp: internal or fatal error
ORA-07445: exception encountered: core dump [kgidmp()+743] [SIGSEGV] [Address not mapped to object] [0x00008002C] [] []
ORA-07445: exception encountered: core dump [_intel_fast_memcpy.A()+10] [SIGSEGV] [Invalid permissions for mapped object] [0x2ACC11C92000] [] []
Current SQL statement for this session:
update SUBSCRIBERS set CHANNEL_HASH=:1, CHANNEL_HASH_TIMESTAMP =:2 WHERE ID=:3 and CHANNEL_HASH=:4
----- Call Stack Trace -----
calling              call     entry                argument values in hex
location             type     point                (? means dubious value)
-------------------- -------- -------------------- ----------------------------
ksedst()+31          call     ksedst1()            000000000 ? 000000001 ?
                                                   2ACC11614250 ? 2ACC116142B0 ?
                                                   2ACC116141F0 ? 000000000 ?
ksedmp()+610         call     ksedst()             000000000 ? 000000001 ?
                                                   2ACC11614250 ? 2ACC116142B0 ?
                                                   2ACC116141F0 ? 000000000 ?
ssexhd()+559         call     ksedmp()             000000002 ? 000000001 ?
                                                   2ACC11614250 ? 2ACC116142B0 ?
                                                   2ACC116141F0 ? 000000000 ?
_L_mutex_unlock_15(  call     ssexhd()             00000000B ? 2ACC11615270 ?
)+29                                               2ACC11615140 ? 2ACC116142B0 ?
                                                   2ACC116141F0 ? 000000000 ?
kgidmp()+743         signal   _L_mutex_unlock_15(  000000005 ? 0055FC0D4 ?
                              )                    000000000 ? 000000000 ?
                                                   000000000 ? 000080004 ?
kgisdp()+122         call     kgidmp()             0068966E0 ? 2ACC11AEA708 ?
                                                   000000002 ? 0B4AFC358 ?
                                                   000000000 ? 000000001 ?
kgisdm()+11          call     kgisdp()             0068966E0 ? 0BF3D19B0 ?
                                                   000000000 ? 2ACC11AEA708 ?
                                                   000000000 ? 000000001 ?
ksudis()+109         call     kgisdm()             0068966E0 ? 0BF3D19B0 ?
                                                   000000000 ? 2ACC11AEA708 ?
                                                   000000000 ? 000000001 ?
ksudps()+787         call     ksudis()             0068966E0 ? 0BF3D19B0 ?
                                                   000000000 ? 2ACC11AEA708 ?
                                                   000000000 ? 000000001 ?
ksedmp()+1404        call     ksudps()             000000002 ? 0BF3D19B0 ?
                                                   000000000 ? 2ACC11AEA708 ?
                                                   000000000 ? 000000001 ?
ssexhd()+629         call     ksedmp()             000000003 ? 0BF3D19B0 ?
                                                   000000000 ? 2ACC11AEA708 ?
                                                   000000000 ? 000000001 ?
_L_mutex_unlock_15(  call     ssexhd()             00000000B ? 2ACC11615D70 ?
)+29                                               2ACC11615C40 ? 2ACC11AEA708 ?
                                                   000000000 ? 000000001 ?
_intel_fast_memcpy.  signal   _L_mutex_unlock_15(  2ACC11C91EF8 ? 2ACC11C92000 ?
A()+10                        )                    FFFFFFFFFFFFC108 ?
                                                   1FFFFFFFFFFB6C3D ?
                                                   000000040 ? 2ACC11A60C98 ?
upderh()+423         call     _intel_fast_memcpy.  2ACC11A4BFD8 ? 2ACC11C92000 ?
                              A()                  1FFFFFFFFFFB6C3D ?
                                                   1FFFFFFFFFFB6C3D ?
                                                   000000040 ? 2ACC11A60C98 ?
upduaw()+162         call     upderh()             2ACC11A4BFD8 ? 2ACC11C92000 ?
                                                   1FFFFFFFFFFB6C3D ?
                                                   1FFFFFFFFFFB6C3D ?
                                                   000000040 ? 2ACC11A60C98 ?
kdusru()+528         call     upduaw()             2ACC1194E388 ? 2ACC1194E4A0 ?
                                                   2ACC11A4D1E8 ? 090AA4EF0 ?
                                                   000000040 ? 2ACC11A60C98 ?
kauupd()+450         call     kdusru()             2ACC11A4BEE4 ? 090AA4E38 ?
                                                   2ACC11A4CF10 ? 000000000 ?
                                                   000000000 ? 2ACC11A60C98 ?
updrow()+1658        call     kauupd()             2ACC11A4BEE0 ? 090AA4E38 ?
                                                   2ACC11A4CF10 ? 000000000 ?
                                                   090AA73B0 ? 000000008 ?
qerupRowProcedure()  call     updrow()             090AA9D20 ? 000007FFF ?
+80                                                2ACC11A4CF10 ? 000000000 ?
                                                   090AA73B0 ? 000000008 ?
qerupFetch()+667     call     qerupRowProcedure()  090AA9D20 ? 000007FFF ?
                                                   2ACC11A4CF10 ? 000000000 ?
                                                   090AA73B0 ? 000000008 ?
updaul()+1065        call     qerupFetch()         000000008 ? 000000000 ?
                                                   090AA5C78 ? 000007FFF ?
                                                   090AA73B0 ? 090AA5EC0 ?
updThreePhaseExe()+  call     updaul()             090AA9D20 ? 7FFF9B18D160 ?
379                                                000000000 ? 2ACC1194E040 ?
                                                   090AA73B0 ? 090AA5EC0 ?
updexe()+600         call     updThreePhaseExe()   090AA9D20 ? 000000000 ?
                                                   2ACC11A4CF10 ? 7FFF9B18D280 ?
                                                   090AA73B0 ? 090AA5EC0 ?
opiexe()+4577        call     updexe()             090AA9D20 ? 000000000 ?
                                                   2ACC11A4CF10 ? 7FFF9B18D280 ?
                                                   000000000 ? 090AA5EC0 ?
kpoal8()+2273        call     opiexe()             000000049 ? 000000003 ?
                                                   7FFF9B18E510 ? 000000003 ?
                                                   000000000 ? 090AA5EC0 ?
opiodr()+984         call     kpoal8()             00000005E ? 000000017 ?
                                                   7FFF9B1913F0 ? 000000003 ?
                                                   000000001 ? 090AA5EC0 ?
ttcpip()+1012        call     opiodr()             00000005E ? 000000017 ?
                                                   7FFF9B1913F0 ? 000000000 ?
                                                   0059C0A30 ? 090AA5EC0 ?
opitsk()+1322        call     ttcpip()             00689E3B0 ? 7FFF9B18F2F8 ?
                                                   7FFF9B1913F0 ? 000000000 ?
                                                   7FFF9B190EE8 ? 7FFF9B191558 ?
opiino()+1026        call     opitsk()             000000003 ? 000000000 ?
                                                   7FFF9B1913F0 ? 000000001 ?
                                                   000000000 ? 4E5885500000001 ?
opiodr()+984         call     opiino()             00000003C ? 000000004 ?
                                                   7FFF9B1925B8 ? 000000000 ?
                                                   000000000 ? 4E5885500000001 ?
opidrv()+547         call     opiodr()             00000003C ? 000000004 ?
                                                   7FFF9B1925B8 ? 000000000 ?
                                                   0059C04E0 ? 4E5885500000001 ?
sou2o()+114          call     opidrv()             00000003C ? 000000004 ?
                                                   7FFF9B1925B8 ? 000000000 ?
                                                   0059C04E0 ? 4E5885500000001 ?
opimai_real()+163    call     sou2o()              7FFF9B192590 ? 00000003C ?
                                                   000000004 ? 7FFF9B1925B8 ?
                                                   0059C04E0 ? 4E5885500000001 ?
main()+116           call     opimai_real()        000000002 ? 7FFF9B192620 ?
                                                   000000004 ? 7FFF9B1925B8 ?
                                                   0059C04E0 ? 4E5885500000001 ?
__libc_start_main()  call     main()               000000002 ? 7FFF9B192620 ?
+244                                               000000004 ? 7FFF9B1925B8 ?
                                                   0059C04E0 ? 4E5885500000001 ?
_start()+41          call     __libc_start_main()  000723098 ? 000000002 ?
                                                   7FFF9B192778 ? 000000000 ?
                                                   0059C04E0 ? 000000002 ?

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

Exception signal: 11 (SIGSEGV), code: 1 (Address not mapped to object), addr: 0x8002c, PC: [0x408a2ff, kgidmp()+743]
*** 2009-02-02 11:53:38.373
ksedmp: internal or fatal error
ORA-07445: exception encountered: core dump [kgidmp()+743] [SIGSEGV] [Address not mapped to object] [0x00008002C] [] []
ORA-07445: exception encountered: core dump [kgidmp()+743] [SIGSEGV] [Address not mapped to object] [0x00008002C] [] []
ORA-07445: exception encountered: core dump [_intel_fast_memcpy.A()+10] [SIGSEGV] [Invalid permissions for mapped object] [0x2ACC11C92000] [] []
Current SQL statement for this session:
update SUBSCRIBERS set CHANNEL_HASH=:1, CHANNEL_HASH_TIMESTAMP =:2 WHERE ID=:3 and CHANNEL_HASH=:4
----- Call Stack Trace -----
calling              call     entry                argument values in hex
location             type     point                (? means dubious value)
-------------------- -------- -------------------- ----------------------------
ksedst()+31          call     ksedst1()            000000000 ? 000000001 ?
                                                   2ACC11613750 ? 2ACC116137B0 ?
                                                   2ACC116136F0 ? 000000000 ?
ksedmp()+610         call     ksedst()             000000000 ? 000000001 ?
                                                   2ACC11613750 ? 2ACC116137B0 ?
                                                   2ACC116136F0 ? 000000000 ?
ssexhd()+578         call     ksedmp()             000000001 ? 000000001 ?
                                                   2ACC11613750 ? 2ACC116137B0 ?
                                                   2ACC116136F0 ? 000000000 ?
_L_mutex_unlock_15(  call     ssexhd()             00000000B ? 2ACC11614770 ?
)+29                                               2ACC11614640 ? 2ACC116137B0 ?
                                                   2ACC116136F0 ? 000000000 ?
kgidmp()+743         signal   _L_mutex_unlock_15(  000000005 ? 0055FC0D4 ?
                              )                    000000000 ? 000000000 ?
                                                   000000000 ? 000080004 ?
kgisdp()+122         call     kgidmp()             0068966E0 ? 2ACC11AEA708 ?
                                                   000000002 ? 0B4AFC358 ?
                                                   000000000 ? 000000001 ?
kgisdm()+11          call     kgisdp()             0068966E0 ? 0BF3D19B0 ?
                                                   000000000 ? 2ACC11AEA708 ?
                                                   000000000 ? 000000001 ?
ksudis()+109         call     kgisdm()             0068966E0 ? 0BF3D19B0 ?
                                                   000000000 ? 2ACC11AEA708 ?
                                                   000000000 ? 000000001 ?
ksudps()+787         call     ksudis()             0068966E0 ? 0BF3D19B0 ?
                                                   000000000 ? 2ACC11AEA708 ?
                                                   000000000 ? 000000001 ?
ksedmp()+1404        call     ksudps()             000000002 ? 0BF3D19B0 ?
                                                   000000000 ? 2ACC11AEA708 ?
                                                   000000000 ? 000000001 ?
ssexhd()+559         call     ksedmp()             000000002 ? 0BF3D19B0 ?
                                                   000000000 ? 2ACC11AEA708 ?
                                                   000000000 ? 000000001 ?
_L_mutex_unlock_15(  call     ssexhd()             00000000B ? 2ACC11615270 ?
)+29                                               2ACC11615140 ? 2ACC11AEA708 ?
                                                   000000000 ? 000000001 ?
kgidmp()+743         signal   _L_mutex_unlock_15(  000000005 ? 0055FC0D4 ?
                              )                    000000000 ? 000000000 ?
                                                   000000000 ? 000080004 ?
kgisdp()+122         call     kgidmp()             0068966E0 ? 2ACC11AEA708 ?
                                                   000000002 ? 0B4AFC358 ?
                                                   000000000 ? 000000001 ?
kgisdm()+11          call     kgisdp()             0068966E0 ? 0BF3D19B0 ?
                                                   000000000 ? 2ACC11AEA708 ?
                                                   000000000 ? 000000001 ?
ksudis()+109         call     kgisdm()             0068966E0 ? 0BF3D19B0 ?
                                                   000000000 ? 2ACC11AEA708 ?
                                                   000000000 ? 000000001 ?
ksudps()+787         call     ksudis()             0068966E0 ? 0BF3D19B0 ?
                                                   000000000 ? 2ACC11AEA708 ?
                                                   000000000 ? 000000001 ?
ksedmp()+1404        call     ksudps()             000000002 ? 0BF3D19B0 ?
                                                   000000000 ? 2ACC11AEA708 ?
                                                   000000000 ? 000000001 ?
ssexhd()+629         call     ksedmp()             000000003 ? 0BF3D19B0 ?
                                                   000000000 ? 2ACC11AEA708 ?
                                                   000000000 ? 000000001 ?
_L_mutex_unlock_15(  call     ssexhd()             00000000B ? 2ACC11615D70 ?
)+29                                               2ACC11615C40 ? 2ACC11AEA708 ?
                                                   000000000 ? 000000001 ?
_intel_fast_memcpy.  signal   _L_mutex_unlock_15(  2ACC11C91EF8 ? 2ACC11C92000 ?
A()+10                        )                    FFFFFFFFFFFFC108 ?
                                                   1FFFFFFFFFFB6C3D ?
                                                   000000040 ? 2ACC11A60C98 ?
upderh()+423         call     _intel_fast_memcpy.  2ACC11A4BFD8 ? 2ACC11C92000 ?
                              A()                  1FFFFFFFFFFB6C3D ?
                                                   1FFFFFFFFFFB6C3D ?
                                                   000000040 ? 2ACC11A60C98 ?
upduaw()+162         call     upderh()             2ACC11A4BFD8 ? 2ACC11C92000 ?
                                                   1FFFFFFFFFFB6C3D ?
                                                   1FFFFFFFFFFB6C3D ?
                                                   000000040 ? 2ACC11A60C98 ?
kdusru()+528         call     upduaw()             2ACC1194E388 ? 2ACC1194E4A0 ?
                                                   2ACC11A4D1E8 ? 090AA4EF0 ?
                                                   000000040 ? 2ACC11A60C98 ?
kauupd()+450         call     kdusru()             2ACC11A4BEE4 ? 090AA4E38 ?
                                                   2ACC11A4CF10 ? 000000000 ?
                                                   000000000 ? 2ACC11A60C98 ?
updrow()+1658        call     kauupd()             2ACC11A4BEE0 ? 090AA4E38 ?
                                                   2ACC11A4CF10 ? 000000000 ?
                                                   090AA73B0 ? 000000008 ?
qerupRowProcedure()  call     updrow()             090AA9D20 ? 000007FFF ?
+80                                                2ACC11A4CF10 ? 000000000 ?
                                                   090AA73B0 ? 000000008 ?
qerupFetch()+667     call     qerupRowProcedure()  090AA9D20 ? 000007FFF ?
                                                   2ACC11A4CF10 ? 000000000 ?
                                                   090AA73B0 ? 000000008 ?
updaul()+1065        call     qerupFetch()         000000008 ? 000000000 ?
                                                   090AA5C78 ? 000007FFF ?
                                                   090AA73B0 ? 090AA5EC0 ?
updThreePhaseExe()+  call     updaul()             090AA9D20 ? 7FFF9B18D160 ?
379                                                000000000 ? 2ACC1194E040 ?
                                                   090AA73B0 ? 090AA5EC0 ?
updexe()+600         call     updThreePhaseExe()   090AA9D20 ? 000000000 ?
                                                   2ACC11A4CF10 ? 7FFF9B18D280 ?
                                                   090AA73B0 ? 090AA5EC0 ?
opiexe()+4577        call     updexe()             090AA9D20 ? 000000000 ?
                                                   2ACC11A4CF10 ? 7FFF9B18D280 ?
                                                   000000000 ? 090AA5EC0 ?
kpoal8()+2273        call     opiexe()             000000049 ? 000000003 ?
                                                   7FFF9B18E510 ? 000000003 ?
                                                   000000000 ? 090AA5EC0 ?
opiodr()+984         call     kpoal8()             00000005E ? 000000017 ?
                                                   7FFF9B1913F0 ? 000000003 ?
                                                   000000001 ? 090AA5EC0 ?
ttcpip()+1012        call     opiodr()             00000005E ? 000000017 ?
                                                   7FFF9B1913F0 ? 000000000 ?
                                                   0059C0A30 ? 090AA5EC0 ?
opitsk()+1322        call     ttcpip()             00689E3B0 ? 7FFF9B18F2F8 ?
                                                   7FFF9B1913F0 ? 000000000 ?
                                                   7FFF9B190EE8 ? 7FFF9B191558 ?
opiino()+1026        call     opitsk()             000000003 ? 000000000 ?
                                                   7FFF9B1913F0 ? 000000001 ?
                                                   000000000 ? 4E5885500000001 ?
opiodr()+984         call     opiino()             00000003C ? 000000004 ?
                                                   7FFF9B1925B8 ? 000000000 ?
                                                   000000000 ? 4E5885500000001 ?
opidrv()+547         call     opiodr()             00000003C ? 000000004 ?
                                                   7FFF9B1925B8 ? 000000000 ?
                                                   0059C04E0 ? 4E5885500000001 ?
sou2o()+114          call     opidrv()             00000003C ? 000000004 ?
                                                   7FFF9B1925B8 ? 000000000 ?
                                                   0059C04E0 ? 4E5885500000001 ?
opimai_real()+163    call     sou2o()              7FFF9B192590 ? 00000003C ?
                                                   000000004 ? 7FFF9B1925B8 ?
                                                   0059C04E0 ? 4E5885500000001 ?
main()+116           call     opimai_real()        000000002 ? 7FFF9B192620 ?
                                                   000000004 ? 7FFF9B1925B8 ?
                                                   0059C04E0 ? 4E5885500000001 ?
__libc_start_main()  call     main()               000000002 ? 7FFF9B192620 ?
+244                                               000000004 ? 7FFF9B1925B8 ?
                                                   0059C04E0 ? 4E5885500000001 ?
_start()+41          call     __libc_start_main()  000723098 ? 000000002 ?
                                                   7FFF9B192778 ? 000000000 ?
                                                   0059C04E0 ? 000000002 ?

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


还有一种, 报有ora-600 kgh_heap_sizes:ds 的错
Mon Dec 22 14:21:41 2008
Errors in file /home/oracle/app/oracle/admin/s3db/udump/s3db2_ora_13467.trc:
ORA-07445: exception encountered: core dump [_intel_fast_memcpy.A()+10] [SIGSEGV] [Address not mapped to object] [0x2B83A26E1000] [] []
Mon Dec 22 14:21:41 2008
Errors in file /home/oracle/app/oracle/admin/s3db/udump/s3db2_ora_13467.trc:
ORA-00600: internal error code, arguments: [kgh_heap_sizes:ds], [0x2B83A26DDBE8], [], [], [], [], [], []
ORA-07445: exception encountered: core dump [_intel_fast_memcpy.A()+10] [SIGSEGV] [Address not mapped to object] [0x2B83A26E1000] [] []
Mon Dec 22 14:21:42 2008
Errors in file /home/oracle/app/oracle/admin/s3db/udump/s3db2_ora_13467.trc:
ORA-00600: internal error code, arguments: [kgh_heap_sizes:ds], [0x2B83A26DD0E8], [], [], [], [], [], []
ORA-00600: internal error code, arguments: [kgh_heap_sizes:ds], [0x2B83A26DDBE8], [], [], [], [], [], []
ORA-07445: exception encountered: core dump [_intel_fast_memcpy.A()+10] [SIGSEGV] [Address not mapped to object] [0x2B83A26E1000] [] []
Mon Dec 22 14:21:43 2008
Errors in file /home/oracle/app/oracle/admin/s3db/udump/s3db2_ora_13467.trc:
ORA-00600: internal error code, arguments: [kgh_heap_sizes:ds], [0x2B83A26DD0E8], [], [], [], [], [], []
ORA-00600: internal error code, arguments: [kgh_heap_sizes:ds], [0x2B83A26DD0E8], [], [], [], [], [], []
ORA-00600: internal error code, arguments: [kgh_heap_sizes:ds], [0x2B83A26DDBE8], [], [], [], [], [], []
ORA-07445: exception encountered: core dump [_intel_fast_memcpy.A()+10] [SIGSEGV] [Address not mapped to object] [0x2B83A26E1000] [] []
Mon Dec 22 14:21:44 2008
Errors in file /home/oracle/app/oracle/admin/s3db/udump/s3db2_ora_13467.trc:
ORA-00600: internal error code, arguments: [kgh_heap_sizes:ds], [0x2B83A26DD0E8], [], [], [], [], [], []
ORA-00600: internal error code, arguments: [kgh_heap_sizes:ds], [0x2B83A26DD0E8], [], [], [], [], [], []
ORA-00600: internal error code, arguments: [kgh_heap_sizes:ds], [0x2B83A26DD0E8], [], [], [], [], [], []
ORA-00600: internal error code, arguments: [kgh_heap_sizes:ds], [0x2B83A26DDBE8], [], [], [], [], [], []
ORA-07445: exception encountered: core dump [_intel_fast_memcpy.A()+10] [SIGSEGV] [Address not mapped to object] [0x2B83A26E1000] [] []
Mon Dec 22 14:21:45 2008
Errors in file /home/oracle/app/oracle/admin/s3db/udump/s3db2_ora_13467.trc:
ORA-00600: internal error code, arguments: [kgh_heap_sizes:ds], [0x2B83A26DD0E8], [], [], [], [], [], []
ORA-00600: internal error code, arguments: [kgh_heap_sizes:ds], [0x2B83A26DD0E8], [], [], [], [], [], []
ORA-00600: internal error code, arguments: [kgh_heap_sizes:ds], [0x2B83A26DD0E8], [], [], [], [], [], []
ORA-00600: internal error code, arguments: [kgh_heap_sizes:ds], [0x2B83A26DD0E8], [], [], [], [], [], []
ORA-00600: internal error code, arguments: [kgh_heap_sizes:ds], [0x2B83A26DDBE8], [], [], [], [], [], []
ORA-07445: exception encountered: core dump [_intel_fast_memcpy.A()+10] [SIGSEGV] [Address not mapped to object] [0x2B83A26E1000] [] []
Mon Dec 22 14:21:46 2008
Errors in file /home/oracle/app/oracle/admin/s3db/udump/s3db2_ora_13467.trc:
ORA-00600: internal error code, arguments: [kgh_heap_sizes:ds], [0x2B83A26DD0E8], [], [], [], [], [], []
ORA-00600: internal error code, arguments: [kgh_heap_sizes:ds], [0x2B83A26DD0E8], [], [], [], [], [], []
ORA-00600: internal error code, arguments: [kgh_heap_sizes:ds], [0x2B83A26DD0E8], [], [], [], [], [], []
ORA-00600: internal error code, arguments: [kgh_heap_sizes:ds], [0x2B83A26DD0E8], [], [], [], [], [], []
ORA-00600: internal error code, arguments: [kgh_heap_sizes:ds], [0x2B83A26DD0E8], [], [], [], [], [], []
ORA-00600: internal error code, arguments: [kgh_heap_sizes:ds], [0x2B83A26DDBE8], [], [], [], [], [], []
ORA-07445: exception encountered: core dump [_intel_fast_memcpy.A()+10] [SIGSEGV] [Address not mapped to object] [0x2B83A26E1000] [] []
Mon Dec 22 14:21:48 2008
Errors in file /home/oracle/app/oracle/admin/s3db/udump/s3db2_ora_13467.trc:
ORA-00600: internal error code, arguments: [kgh_heap_sizes:ds], [0x2B83A26DD0E8], [], [], [], [], [], []
ORA-00600: internal error code, arguments: [kgh_heap_sizes:ds], [0x2B83A26DD0E8], [], [], [], [], [], []
ORA-00600: internal error code, arguments: [kgh_heap_sizes:ds], [0x2B83A26DD0E8], [], [], [], [], [], []
ORA-00600: internal error code, arguments: [kgh_heap_sizes:ds], [0x2B83A26DD0E8], [], [], [], [], [], []
ORA-00600: internal error code, arguments: [kgh_heap_sizes:ds], [0x2B83A26DD0E8], [], [], [], [], [], []
ORA-00600: internal error code, arguments: [kgh_heap_sizes:ds], [0x2B83A26DD0E8], [], [], [], [], [], []
ORA-00600: internal error code, arguments: [kgh_heap_sizes:ds], [0x2B83A26DDBE8], [], [], [], [], [], []
ORA-07445: exception encountered: core dump [_intel_fast_memcpy.A()+10] [SIGSEGV] [Address not mapped to object] [0x2B83A26E1000] [] []
Mon Dec 22 14:21:49 2008
Errors in file /home/oracle/app/oracle/admin/s3db/udump/s3db2_ora_13467.trc:
ORA-00600: internal error code, arguments: [kgh_heap_sizes:ds], [0x2B83A26DD0E8], [], [], [], [], [], []
ORA-00600: internal error code, arguments: [kgh_heap_sizes:ds], [0x2B83A26DD0E8], [], [], [], [], [], []
ORA-00600: internal error code, arguments: [kgh_heap_sizes:ds], [0x2B83A26DD0E8], [], [], [], [], [], []
ORA-00600: internal error code, arguments: [kgh_heap_sizes:ds], [0x2B83A26DD0E8], [], [], [], [], [], []
ORA-00600: internal error code, arguments: [kgh_heap_sizes:ds], [0x2B83A26DD0E8], [], [], [], [], [], []
ORA-00600: internal error code, arguments: [kgh_heap_sizes:ds], [0x2B83A26DD0E8], [], [], [], [], [], []
ORA-00600: internal error code, arguments: [kgh_heap_sizes:ds], [0x2B83A26DD0E8], [], [], [], [], [], []
ORA-00600: internal error code, arguments: [kgh_heap_sizes:ds], [0x2B83A26DDBE8], [], [], [], [], [], []
ORA-07445: exception encountered: core dump [_intel_fast_memcpy.A()+10] [SIGSEGV] [Address not mapped to object] [0x2B83A26E1000] [] []

跟踪文件显示:
*** 2008-12-22 14:21:42.309
ksedmp: internal or fatal error
ORA-00600: internal error code, arguments: [kgh_heap_sizes:ds], [0x2B83A26DD0E8], [], [], [], [], [], []
ORA-00600: internal error code, arguments: [kgh_heap_sizes:ds], [0x2B83A26DDBE8], [], [], [], [], [], []
ORA-07445: exception encountered: core dump [_intel_fast_memcpy.A()+10] [SIGSEGV] [Address not mapped to object] [0x2B83A26E1000] [] []
Current SQL statement for this session:
update SUBSCRIBERS set CHANNEL_HASH=:1, CHANNEL_HASH_TIMESTAMP =:2 WHERE ID=:3 and CHANNEL_HASH=:4
----- Call Stack Trace -----
calling              call     entry                argument values in hex
location             type     point                (? means dubious value)
-------------------- -------- -------------------- ----------------------------
ksedst()+31          call     ksedst1()            000000000 ? 000000001 ?
                                                   2B83A25EB150 ? 2B83A25EB1B0 ?
                                                   2B83A25EB0F0 ? 000000000 ?
ksedmp()+610         call     ksedst()             000000000 ? 000000001 ?
                                                   2B83A25EB150 ? 2B83A25EB1B0 ?
                                                   2B83A25EB0F0 ? 000000000 ?
ksfdmp()+21          call     ksedmp()             000000003 ? 000000001 ?
                                                   2B83A25EB150 ? 2B83A25EB1B0 ?
                                                   2B83A25EB0F0 ? 000000000 ?
kgerinv()+161        call     ksfdmp()             000000003 ? 000000001 ?
                                                   2B83A25EB150 ? 2B83A25EB1B0 ?
                                                   2B83A25EB0F0 ? 000000000 ?
kgesinv()+33         call     kgerinv()            0068966E0 ? 00AAB9CC0 ?
                                                   2B83A25EB1B0 ? 2B83A25EB0F0 ?
                                                   000000000 ? 000000000 ?
kgesin()+143         call     kgesinv()            0068966E0 ? 00AAB9CC0 ?
                                                   2B83A25EB1B0 ? 2B83A25EB0F0 ?
                                                   000000000 ? 000000000 ?
kghnerror()+342      call     kgesin()             0068966E0 ? 00AAB9CC0 ?
                                                   2B83A25EB1B0 ? 2B83A25EB0F0 ?
                                                   000000002 ? 2B83A26DD0E8 ?
kgh_heap_sizes()+11  call     kghnerror()          0068966E0 ? 2B83A26AA128 ?
58                                                 005AE1EE8 ? 2B83A26DD0E8 ?
                                                   000000002 ? 2B83A26DD0E8 ?
kxsDump1()+1209      call     kgh_heap_sizes()     000000002 ? 2B83A26AA128 ?
                                                   2B83A25EC050 ? 000000001 ?
                                                   2B8300000001 ? 000000002 ?
kxsDump()+538        call     kxsDump1()           2B83A26C1420 ? 000000071 ?
                                                   2B83A25EC050 ? 000000001 ?
                                                   2B8300000001 ? 000000002 ?
kxsDumpCursor()+165  call     kxsDump()            2B83A26C1420 ? 000000071 ?
                                                   006896860 ? 000000001 ?
                                                   2B8300000001 ? 000000002 ?
kxsDumpCursors()+12  call     kxsDumpCursor()      2B83A26A1BF0 ? 000000071 ?
05                                                 006896860 ? 000000001 ?
                                                   2B8300000001 ? 000000002 ?
curdmp()+19          call     kxsDumpCursors()     000000071 ? 000000001 ?
                                                   006896860 ? 000000001 ?
                                                   2B83A269E5C8 ? 0A0000000 ?
ksudps()+794         call     curdmp()             000000071 ? 000000001 ?
                                                   006896860 ? 000000001 ?
                                                   2B83A269E5C8 ? 0A0000000 ?
ksedmp()+1404        call     ksudps()             000000002 ? 000000001 ?
                                                   006896860 ? 000000001 ?
                                                   2B83A269E5C8 ? 0A0000000 ?
ksfdmp()+21          call     ksedmp()             000000003 ? 000000001 ?
                                                   006896860 ? 000000001 ?
                                                   2B83A269E5C8 ? 0A0000000 ?
kgerinv()+161        call     ksfdmp()             000000003 ? 000000001 ?
                                                   006896860 ? 000000001 ?
                                                   2B83A269E5C8 ? 0A0000000 ?
kgesinv()+33         call     kgerinv()            0068966E0 ? 00AAB9CC0 ?
                                                   000000001 ? 2B83A269E5C8 ?
                                                   0A0000000 ? 0A0000000 ?
kgesin()+143         call     kgesinv()            0068966E0 ? 00AAB9CC0 ?
                                                   000000001 ? 2B83A269E5C8 ?
                                                   0A0000000 ? 0A0000000 ?
kghnerror()+342      call     kgesin()             0068966E0 ? 00AAB9CC0 ?
                                                   000000001 ? 2B83A269E5C8 ?
                                                   000000002 ? 2B83A26DDBE8 ?
kgh_heap_sizes()+11  call     kghnerror()          0068966E0 ? 2B83A26B0978 ?
58                                                 005AE1EE8 ? 2B83A26DDBE8 ?
                                                   000000002 ? 2B83A26DDBE8 ?
kxsDump1()+1381      call     kgh_heap_sizes()     000000002 ? 2B83A26B0978 ?
                                                   2B83A25ECE50 ? 000000001 ?
                                                   2B8300000001 ? 000000002 ?
kxsDump()+538        call     kxsDump1()           2B83A26D7060 ? 000000071 ?
                                                   2B83A25ECE50 ? 000000001 ?
                                                   2B8300000001 ? 000000002 ?
kxsDumpCursor()+165  call     kxsDump()            2B83A26D7060 ? 000000071 ?
                                                   006896860 ? 000000001 ?
                                                   2B8300000001 ? 000000002 ?
kxsDumpCursors()+12  call     kxsDumpCursor()      2B83A26A1F30 ? 000000071 ?
05                                                 006896860 ? 000000001 ?
                                                   2B8300000001 ? 000000002 ?
curdmp()+19          call     kxsDumpCursors()     000000071 ? 000000001 ?
                                                   006896860 ? 000000001 ?
                                                   2B83A269E5C8 ? 000000000 ?
ksudps()+794         call     curdmp()             000000071 ? 000000001 ?
                                                   006896860 ? 000000001 ?
                                                   2B83A269E5C8 ? 000000000 ?
ksedmp()+1404        call     ksudps()             000000002 ? 000000001 ?
                                                   006896860 ? 000000001 ?
                                                   2B83A269E5C8 ? 000000000 ?
ssexhd()+629         call     ksedmp()             000000003 ? 000000001 ?
                                                   006896860 ? 000000001 ?
                                                   2B83A269E5C8 ? 000000000 ?
_L_mutex_unlock_15(  call     ssexhd()             00000000B ? 2B83A25EDD70 ?
)+29                                               2B83A25EDC40 ? 000000001 ?
                                                   2B83A269E5C8 ? 000000000 ?
_intel_fast_memcpy.  signal   _L_mutex_unlock_15(  2B83A26E0EF8 ? 2B83A26E1000 ?
A()+10                        )                    FFFFFFFFFFFFCAC9 ?
                                                   1FFFFFFFFFFFEB7B ?
                                                   000000040 ? 2B83A29224C8 ?
upderh()+423         call     _intel_fast_memcpy.  2B83A26DA008 ? 2B83A26E1000 ?
                              A()                  1FFFFFFFFFFFEB7B ?
                                                   1FFFFFFFFFFFEB7B ?
                                                   000000040 ? 2B83A29224C8 ?
upduaw()+162         call     upderh()             2B83A26DA008 ? 2B83A26E1000 ?
                                                   1FFFFFFFFFFFEB7B ?
                                                   1FFFFFFFFFFFEB7B ?
                                                   000000040 ? 2B83A29224C8 ?
kdusru()+528         call     upduaw()             2B83A26B6FE0 ? 2B83A26B70F8 ?
                                                   2B83A26BAF50 ? 0AEB67530 ?
                                                   000000040 ? 2B83A29224C8 ?
kauupd()+450         call     kdusru()             2B83A26D9F14 ? 0AEB67478 ?
                                                   2B83A26BAC78 ? 000000000 ?
                                                   000000000 ? 2B83A29224C8 ?
updrow()+1658        call     kauupd()             2B83A26D9F10 ? 0AEB67478 ?
                                                   2B83A26BAC78 ? 000000000 ?
                                                   0AD84BA18 ? 000000008 ?
qerupRowProcedure()  call     updrow()             0B2108F80 ? 000007FFF ?
+80                                                2B83A26BAC78 ? 000000000 ?
                                                   0AD84BA18 ? 000000008 ?
qerupFetch()+667     call     qerupRowProcedure()  0B2108F80 ? 000007FFF ?
                                                   2B83A26BAC78 ? 000000000 ?
                                                   0AD84BA18 ? 000000008 ?
updaul()+1065        call     qerupFetch()         000000008 ? 000000000 ?
                                                   0AEB682C0 ? 000007FFF ?
                                                   0AD84BA18 ? 0AEB68500 ?
updThreePhaseExe()+  call     updaul()             0B2108F80 ? 7FFF0A1B3180 ?
379                                                000000000 ? 2B83A26B6C98 ?
                                                   0AD84BA18 ? 0AEB68500 ?
updexe()+600         call     updThreePhaseExe()   0B2108F80 ? 000000000 ?
                                                   2B83A26BAC78 ? 7FFF0A1B32A0 ?
                                                   0AD84BA18 ? 0AEB68500 ?
opiexe()+4577        call     updexe()             0B2108F80 ? 000000000 ?
                                                   2B83A26BAC78 ? 7FFF0A1B32A0 ?
                                                   000000000 ? 0AEB68500 ?
kpoal8()+2273        call     opiexe()             000000049 ? 000000003 ?
                                                   7FFF0A1B4530 ? 000000007 ?
                                                   000000000 ? 0AEB68500 ?
opiodr()+984         call     kpoal8()             00000005E ? 000000017 ?
                                                   7FFF0A1B7410 ? 000000007 ?
                                                   000000001 ? 0AEB68500 ?
ttcpip()+1012        call     opiodr()             00000005E ? 000000017 ?
                                                   7FFF0A1B7410 ? 000000000 ?
                                                   0059C0A30 ? 0AEB68500 ?
opitsk()+1322        call     ttcpip()             00689E3B0 ? 7FFF0A1B5318 ?
                                                   7FFF0A1B7410 ? 000000000 ?
                                                   7FFF0A1B6F08 ? 7FFF0A1B7578 ?
opiino()+1026        call     opitsk()             000000003 ? 000000000 ?
                                                   7FFF0A1B7410 ? 000000001 ?
                                                   000000000 ? 4E5345200000001 ?
opiodr()+984         call     opiino()             00000003C ? 000000004 ?
                                                   7FFF0A1B85D8 ? 000000000 ?
                                                   000000000 ? 4E5345200000001 ?
opidrv()+547         call     opiodr()             00000003C ? 000000004 ?
                                                   7FFF0A1B85D8 ? 000000000 ?
                                                   0059C04E0 ? 4E5345200000001 ?
sou2o()+114          call     opidrv()             00000003C ? 000000004 ?
                                                   7FFF0A1B85D8 ? 000000000 ?
                                                   0059C04E0 ? 4E5345200000001 ?
opimai_real()+163    call     sou2o()              7FFF0A1B85B0 ? 00000003C ?
                                                   000000004 ? 7FFF0A1B85D8 ?
                                                   0059C04E0 ? 4E5345200000001 ?
main()+116           call     opimai_real()        000000002 ? 7FFF0A1B8640 ?
                                                   000000004 ? 7FFF0A1B85D8 ?
                                                   0059C04E0 ? 4E5345200000001 ?
__libc_start_main()  call     main()               000000002 ? 7FFF0A1B8640 ?
+244                                               000000004 ? 7FFF0A1B85D8 ?
                                                   0059C04E0 ? 4E5345200000001 ?
_start()+41          call     __libc_start_main()  000723098 ? 000000002 ?
                                                   7FFF0A1B8798 ? 000000000 ?
                                                   0059C04E0 ? 000000002 ?

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



经查询, 好像是这个BUG, Bug 7138239 - ORA-07445[_INTEL_FAST_MEMCPY.A()+10] FOR UPDATE


Details:
There is a problem with the fix from bug 4549673 which is included in 9.2.0.8 and 10.2.0.4 in that with that fix it is possible to get a dump under updgrh and/or private memory corruption. This issue can also cause malformed RCI information in the redo stream causing problems for log miner and Streams.
eg:
Corruption / dumps can occur when updating a migrated row where one of the columns is to be updated to NULL and an internal 1551 error occurs during the DML.(1551 errors are not visible to customers and are caught and handled internally)

Ora-07445 [INTEL_FAST_MEMCPY] Dump Under Updgrh From Update Statement

Bug 5868257 - Dump / memory corruption from UPDATE DML


Solution
To resolve this issue, you may choose any of these options:
1. Apply the 11.1.0.6 patchset which includes the bug fix.
2. Check for the availability of Patch 5868257 on MetaLink corresponding to your platform and database version.
3. If no patch is available, request a patch by creating a service request with Oracle Support.

打补丁 Patch 5868257 MALFORMED RCI MARKER REDO DUE TO ORA-1551 IN UPDATE DRIVER
或打最新的建议补丁集 10.2.0.4 GENERIC RECOMMENDED BUNDLE# 3., 包含了上面的5868257



也可能不是这个BUG,不管它了



-fin-

No comments:

Website Analytics

Followers