请教 ORA-07445: exception encountered: core dump 问题

mcar

刘大好！
我现有一生产库，环境如下：
系统:Redhat 5.4 64Bit
数据库：oracle 10.0.2.0.4 64Bit 2节点RAC

在巡检alert日志中发现如下错误，2个节点都出现相同的问题，目前业务正常运行

截部分alert日志：
Thu Jul 11 11:04:50 2013
Errors in file /opt/ora10/admin/ayydb/udump/ayydb1_ora_16645.trc:
ORA-07445: exception encountered: core dump [_intel_fast_memcpy.A()+10] [SIGSEGV] [Address not mapped to object] [0x2B416962D000] [] []
Thu Jul 11 11:04:51 2013
Errors in file /opt/ora10/admin/ayydb/udump/ayydb1_ora_16645.trc:
ORA-00600: internal error code, arguments: [kgh_heap_sizes:ds], [0x2B4169CD1958], [], [], [], [], [], []
ORA-07445: exception encountered: core dump [_intel_fast_memcpy.A()+10] [SIGSEGV] [Address not mapped to object] [0x2B416962D000] [] []
Thu Jul 11 11:04:52 2013
Errors in file /opt/ora10/admin/ayydb/udump/ayydb1_ora_16645.trc:
ORA-00600: internal error code, arguments: [kgh_heap_sizes:ds], [0x2B4169CD1958], [], [], [], [], [], []
ORA-00600: internal error code, arguments: [kgh_heap_sizes:ds], [0x2B4169CD1958], [], [], [], [], [], []
ORA-07445: exception encountered: core dump [_intel_fast_memcpy.A()+10] [SIGSEGV] [Address not mapped to object] [0x2B416962D000] [] []
Thu Jul 11 11:04:53 2013
Errors in file /opt/ora10/admin/ayydb/udump/ayydb1_ora_16645.trc:
ORA-00600: internal error code, arguments: [kgh_heap_sizes:ds], [0x2B4169CD1958], [], [], [], [], [], []
ORA-00600: internal error code, arguments: [kgh_heap_sizes:ds], [0x2B4169CD1958], [], [], [], [], [], []
ORA-00600: internal error code, arguments: [kgh_heap_sizes:ds], [0x2B4169CD1958], [], [], [], [], [], []
ORA-07445: exception encountered: core dump [_intel_fast_memcpy.A()+10] [SIGSEGV] [Address not mapped to object] [0x2B416962D000] [] []
Thu Jul 11 11:04:54 2013
Errors in file /opt/ora10/admin/ayydb/udump/ayydb1_ora_16645.trc:
ORA-00600: internal error code, arguments: [kgh_heap_sizes:ds], [0x2B4169CD1958], [], [], [], [], [], []
ORA-00600: internal error code, arguments: [kgh_heap_sizes:ds], [0x2B4169CD1958], [], [], [], [], [], []
ORA-00600: internal error code, arguments: [kgh_heap_sizes:ds], [0x2B4169CD1958], [], [], [], [], [], []
ORA-00600: internal error code, arguments: [kgh_heap_sizes:ds], [0x2B4169CD1958], [], [], [], [], [], []
ORA-07445: exception encountered: core dump [_intel_fast_memcpy.A()+10] [SIGSEGV] [Address not mapped to object] [0x2B416962D000] [] []

截部分ayydb1_ora_16645.trc
*** 2013-07-11 11:04:50.940
*** ACTION NAME:() 2013-07-11 11:04:50.940
*** MODULE NAME:(JDBC Thin Client) 2013-07-11 11:04:50.940
*** SERVICE NAME:(ayydb) 2013-07-11 11:04:50.940
*** SESSION ID:(820.1318) 2013-07-11 11:04:50.940
Exception signal: 11 (SIGSEGV), code: 1 (Address not mapped to object), addr: 0x2b416962d000, PC: [0x2b4167857608, _intel_fast_memcpy.A()+10]
*** 2013-07-11 11:04:50.940
ksedmp: internal or fatal error
ORA-07445: exception encountered: core dump [_intel_fast_memcpy.A()+10] [SIGSEGV] [Address not mapped to object] [0x2B416962D000] [] []
Current SQL statement for this session:
update t_register set respresent = respresent + 1 where id = :1
----- Call Stack Trace -----
calling              call     entry                argument values in hex      
location             type     point                (? means dubious value)     
-------------------- -------- -------------------- ----------------------------
ksedst()+31          call     ksedst1()            000000000 ? 000000001 ?
                                                   2B4169538D50 ? 2B4169538DB0 ?
                                                   2B4169538CF0 ? 000000000 ?
ksedmp()+610         call     ksedst()             000000000 ? 000000001 ?
                                                   2B4169538D50 ? 2B4169538DB0 ?
                                                   2B4169538CF0 ? 000000000 ?
ssexhd()+629         call     ksedmp()             000000003 ? 000000001 ?
                                                   2B4169538D50 ? 2B4169538DB0 ?
                                                   2B4169538CF0 ? 000000000 ?
__restore_rt()+0     call     ssexhd()             00000000B ? 2B4169539D70 ?
                                                   2B4169539C40 ? 2B4169538DB0 ?
                                                   2B4169538CF0 ? 000000000 ?
_intel_fast_memcpy.  signal   __restore_rt()       2B4169CDEDE8 ? 2B416962D000 ?
A()+10                                             FFFFFFFFFFFFC305 ?
                                                   1FFFFFFFFFFF9F6A ?
                                                   000000040 ? 2B4169A660D0 ?
upderh()+423         call     _intel_fast_memcpy.  2B4169CB2638 ? 2B416962D000 ?
                              A()                  1FFFFFFFFFFF9F6A ?
                                                   1FFFFFFFFFFF9F6A ?
                                                   000000040 ? 2B4169A660D0 ?

经过查询资料，可能是由于表 t_register行迁移问题引起的BUG，由于生产库不能停机，补丁升级风险较大，这个表的数据接近1亿行（有分区），请指导解决这个问题的最好办法，感谢！

附上alert.log和16645.trc

Maclean Liu(刘相兵

我觉得更像这个 BUG 吧
Hdr: 12310892 10.2.0.4 RDBMS 10.2.0.4 SQL EXECUTION PRODID-5 PORTID-197
Abstract: ORA-7445 AT _MEMCPY THEN ORA-600 [KGH_HEAP_SIZES:DS]

Maclean Liu(刘相兵

10.2.0.4 + LINUX + RAC

Exception signal: 11 (SIGSEGV), code: 1 (Address not mapped to object), addr: 0x2b416962d000, PC: [0x2b4167857608, _intel_fast_memcpy.A()+10]
*** 2013-07-11 11:04:50.940
ksedmp: internal or fatal error
ORA-07445: exception encountered: core dump [_intel_fast_memcpy.A()+10] [SIGSEGV] [Address not mapped to object] [0x2B416962D000] [] []
Current SQL statement for this session:
update t_register set respresent = respresent + 1 where id = :1


upduaw=>upderh=>_intel_fast_memcpy.A

    last wait for 'enq: TT - contention' blocking sess=0x(nil) seq=33548 wait_time=1112 seconds since wait started=1
                name|mode=54540004, tablespace ID=12, operation=10


ORA-00600: internal error code, arguments: [kgh_heap_sizes:ds], [0x2B4169CD1958], [], [], [], [], [], []
ORA-07445: exception encountered: core dump [_intel_fast_memcpy.A()+10] [SIGSEGV] [Address not mapped to object] [0x2B416962D000] [] []
Current SQL statement for this session:
update t_register set respresent = respresent + 1 where id = :1


kxsDumpCursor=>kxsDump=>kxsDump1=>kgh_heap_sizes=>kghnerror