replicat中断同时数据库报ora-600和ora-07445

倒数第九 · 发表于 2014-6-13 16:45:12

replicat进程中断，发现进程是在同步一条update语句时，触发了数据库的bug，数据库日志报ora-600和ora-07445的错误，我的相关日志和trace文件在附件里，请大家帮我看看吧，我搞不定了。

xifenfei · 发表于 2014-6-13 23:48:57

alert 日志信息

Thu Jun 12 11:04:41 2014
Errors in file /u01/app/oracle/admin/qhdlyx/udump/qhdlyx_ora_9140.trc:
ORA-00600: internal error code, arguments: [kgh_heap_sizes:ds], [0x9FFFFFFFBF068D18], [], [], [], [], [], []
ORA-00600: internal error code, arguments: [kgh_heap_sizes:ds], [0x9FFFFFFFBF068D18], [], [], [], [], [], []
ORA-00600: internal error code, arguments: [kgh_heap_sizes:ds], [0x9FFFFFFFBF068D18], [], [], [], [], [], []
ORA-00600: internal error code, arguments: [kgh_heap_sizes:ds], [0x9FFFFFFFBF068D18], [], [], [], [], [], []
ORA-00600: internal error code, arguments: [kgh_heap_sizes:ds], [0x9FFFFFFFBF068D18], [], [], [], [], [], []
ORA-00600: internal error code, arguments: [kghGetHpSz1], [0x9FFFFFFFBF068F58], [], [], [], [], [], []
ORA-00600: internal error code, arguments: [kgh_heap_sizes:ds], [0x9FFFFFFFBF068D18], [], [], [], [], [], []
ORA-07445: exception encountered: core dump [_memcpy()+2448] [SIGSEGV] [Address not mapped to object] [0x9FFFFFFFBF200000] [] []
Thu Jun 12 11:04:43 2014
Errors in file /u01/app/oracle/admin/qhdlyx/udump/qhdlyx_ora_9140.trc:
ORA-00600: internal error code, arguments: [kgh_heap_sizes:ds], [0x9FFFFFFFBF068D18], [], [], [], [], [], []
ORA-00600: internal error code, arguments: [kgh_heap_sizes:ds], [0x9FFFFFFFBF068D18], [], [], [], [], [], []
ORA-00600: internal error code, arguments: [kgh_heap_sizes:ds], [0x9FFFFFFFBF068D18], [], [], [], [], [], []
ORA-00600: internal error code, arguments: [kgh_heap_sizes:ds], [0x9FFFFFFFBF068D18], [], [], [], [], [], []
ORA-00600: internal error code, arguments: [kgh_heap_sizes:ds], [0x9FFFFFFFBF068D18], [], [], [], [], [], []
ORA-00600: internal error code, arguments: [kgh_heap_sizes:ds], [0x9FFFFFFFBF068D18], [], [], [], [], [], []
ORA-00600: internal error code, arguments: [kghGetHpSz1], [0x9FFFFFFFBF068F58], [], [], [], [], [], []
ORA-00600: internal error code, arguments: [kgh_heap_sizes:ds], [0x9FFFFFFFBF068D18], [], [], [], [], [], []
ORA-07445: exception encountered: core dump [_memcpy()+2448] [SIGSEGV] [Address not mapped to object] [0x9FFFFFFFBF200000] [] []
Thu Jun 12 13:02:07 2014

复制代码

trace文件记录

*** 2014-06-12 11:04:28.049
ksedmp: internal or fatal error
ORA-07445: exception encountered: core dump [_memcpy()+2448] [SIGSEGV] [Address not mapped to object] [0x9FFFFFFFBF200000] [] []
Current SQL statement for this session:
UPDATE /*+ RESTRICT_ALL_REF_CONS */ "SGPM"."S_95598_WKST" SET "ATTACH" = :a1 WHERE "APP_NO" = :b0
----- Call Stack Trace -----
calling call entry argument values in hex
location type point (? means dubious value)
-------------------- -------- -------------------- ----------------------------
ksedst()+64 call ksedst1() 000000001 ? 000000001 ?
ksedmp()+2176 call ksedst() 000000001 ?
C050000000000C9F ?
4000000003FED9A0 ?
000000000 ? 000000000 ?
000000000 ?
ssexhd()+1264 call ksedmp() 000000003 ?
9FFFFFFFFFFDDFA0 ?
60000000000B5D60 ?
9FFFFFFFFFFDE570 ?
C050000000000B9F ?
40000000068C6C00 ?
FFFFFFFFFFFF96DD ?
60000000000C2E10 ?
<kernel> call ssexhd() C0000000B0276418 ?
60000000000C4D00 ?
C0000000400077C0 ?
60000000000B5D60 ?
_memcpy()+2448 call <kernel>
updgrh()+9616 call _memcpy() 000000000 ? 000000000 ?
000000000 ? 000000000 ?
000000000 ? 000000000 ?
000000000 ? 000000000 ?
upduaw()+208 call updgrh() C000000097AB3510 ?
9FFFFFFFBF3C6EC0 ?
60000000000B5D60 ?
4000000002C41A90 ?
00002E99D ? 000000000 ?
C000000000001BBE ?
kdusru()+880 call upduaw() 9FFFFFFFBF3F9218 ?
000000000 ?
9FFFFFFFBF3C7198 ?
kauupd()+704 call kdusru() 9FFFFFFFBF3F0DC4 ?
000000000 ?
9FFFFFFFBF3C6EC0 ?
000000000 ?
60000000000B5D60 ?
C00000000000122C ?
4000000002C44680 ?
00002E855 ?
updrow()+2592 call kauupd() 9FFFFFFFBF3F0DC0 ?
000000000 ?
9FFFFFFFBF3C6EC0 ?
000000000 ?
C000000097AB4490 ?
000000003 ? 0000CEF34 ?
C000000097AB3450 ?
qerupRowProcedure() call updrow() 9FFFFFFFFFFF3D60 ?
+176 4000000002C54480 ?
qerupFetch()+1328 call qerupRowProcedure() C000000097AB31F4 ?
000000000 ?
C0000000000013AD ?
4000000002C54A10 ?
000028499 ? 000000000 ?
updaul()+4544 call qerupFetch() C000000097AB3748 ?
000000000 ?
9FFFFFFFFFFF3D78 ?
000007FFF ?
9FFFFFFFFFFF3D70 ?
60000000000B5D60 ?
9FFFFFFFFFFF4500 ?
C0000000000018B9 ?
updThreePhaseExe()+ call updaul() 9FFFFFFFFFFF4F90 ?
1024 4000000002FE0830 ?
000028217 ?
9FFFFFFFFFFF4540 ?
60000000000B5D60 ?
C00000000000295A ?
600000000003B7D0 ?
9FFFFFFFBF3F9224 ?
updexe()+720 call updThreePhaseExe() C000000097AB6B98 ?
000000000 ?
9FFFFFFFBF3C6EC0 ?
9FFFFFFFFFFF5040 ?
opiexe()+7872 call updexe() C000000097AB6B98 ?
C000000097AB31F4 ?
C000000097AB31C8 ?
9FFFFFFFBF3C6EC0 ?
C000000097AB3694 ?
9FFFFFFFBF3F9218 ?
042222008 ?
C000000097AB6B98 ?
kpoal8()+3872 call opiexe() 9FFFFFFFFFFF6EE0 ?
4000000002A89C60 ?
00001E815 ?
9FFFFFFFFFFF5260 ?
60000000000B5D60 ?
C0000000000012AD ?
60000000000C26D8 ?
60000000000314C0 ?
opiodr()+2128 call kpoal8() 9FFFFFFFFFFF7610 ?
C000000000001530 ?
9FFFFFFFFFFF9CF0 ?
9FFFFFFFFFFF6F30 ?
60000000000B5D60 ?
9FFFFFFFBE5820A0 ?
ttcpip()+1680 call opiodr() 00000005E ? 000000017 ?
4000000001B03620 ?
0000046B0 ?
9FFFFFFFFFFF7620 ?
opitsk()+2336 call ttcpip() 600000000003D0C0 ?
000000000 ?
9FFFFFFFFFFF9CF0 ?
000000001 ?
9FFFFFFFFFFF9E60 ?
9FFFFFFFFFFF9C54 ?
4000000001BE9620 ?
000000000 ?
opiino()+1840 call opitsk() 000000000 ? 000000000 ?
60000000000B5D60 ?
40000000027FBEB0 ?
00001804D ?
4000000001B03638 ?
opiodr()+2128 call opiino() 00000003C ?
9FFFFFFFFFFFC6B0 ?
9FFFFFFFFFFFEE50 ?
9FFFFFFFFFFFBB70 ?
60000000000B5D60 ?
C000000000001530 ?
opidrv()+1088 call opiodr() 00000003C ? 000000004 ?
4000000001B030D0 ?
0000046B0 ?
9FFFFFFFFFFFC6C0 ?
60000000000B5D60 ?
sou2o()+336 call opidrv() 00000003C ?
9FFFFFFFFFFFEE50 ?
60000000000C26D0 ?
opimai_real()+224 call sou2o() 9FFFFFFFFFFFEE70 ?
00000003C ? 000000004 ?
9FFFFFFFFFFFEE50 ?
main()+368 call opimai_real() 000000000 ?
9FFFFFFFFFFFEEA0 ?
main_opd_entry()+80 call main() 000000002 ?
9FFFFFFFFFFFF360 ?
60000000000B5D60 ?
C000000000000004 ?
--------------------- Binary Stack Dump ---------------------

复制代码

update表结构

SQL> desc SGPM.S_95598_WKST
Name Null? Type
----------------------------------------- -------- ----------------------------
APP_NO NOT NULL VARCHAR2(16 CHAR)
ID NOT NULL NUMBER(16)
GROUP_NO VARCHAR2(32 CHAR)
BUSI_TYPE_CODE VARCHAR2(8 CHAR)
BUSI_SUB_TYPE VARCHAR2(10 CHAR)
COUNTY_CODE VARCHAR2(8 CHAR)
URBAN_RURAL_FLAG VARCHAR2(8 CHAR)
ORG_NO VARCHAR2(16 CHAR)
EMP_NO VARCHAR2(16 CHAR)
HANDLE_TIME DATE
ACCEPT_MODE VARCHAR2(8 CHAR)
ACCEPT_CONTENT VARCHAR2(4000 CHAR)
HANDLE_OPINION VARCHAR2(4000 CHAR)
REPLY_FLAG VARCHAR2(8 CHAR)
REPLY_DATE NUMBER
REPLY_MODE VARCHAR2(8 CHAR)
CONS_OPINION VARCHAR2(4000 CHAR)
REPLY_TEL VARCHAR2(32 CHAR)
SEND_DATE DATE
ATTACH BLOB -----------------正好更新的是这个字段
IDEN_MODE VARCHAR2(8 CHAR)
CERT_TYPE_CODE VARCHAR2(8 CHAR)
CERT_NO VARCHAR2(32 CHAR)
ARC_MODE VARCHAR2(8 CHAR)
INTEGRITY_FLAG VARCHAR2(8 CHAR)
ACCURACY_FLAG VARCHAR2(8 CHAR)
ARC_OPINION VARCHAR2(4000 CHAR)
TIME_LEN NUMBER(15)
ARC_EMP_NAME VARCHAR2(16 CHAR)
ARC_DATE DATE
HANDLE_STATUS_CODE VARCHAR2(256 CHAR)
REPLY_SUCC_FLAG VARCHAR2(8 CHAR)
RETVISIT_FAIL_REASON VARCHAR2(256 CHAR)
REPLY_FAIL_TIMES NUMBER(5)
CUST_NO VARCHAR2(48 CHAR)
CUST_TYPE VARCHAR2(24 CHAR)
REAL_ARRIVE_TIME DATE
CUST_NAME VARCHAR2(768 CHAR)
VISIT_SCORE NUMBER(5)
TG_NO VARCHAR2(16 CHAR)
METER_NO VARCHAR2(32 CHAR)
DISPATCH_LEN NUMBER(15)
TRANSFER_LEN NUMBER(15)
IMPORTANT_CUST_LEVEL VARCHAR2(8 CHAR)
OVER_TIME DATE
CITY_CODE VARCHAR2(8 CHAR)
TARGET_DEPT VARCHAR2(16 CHAR)
APP_REJECT_FLAG VARCHAR2(8 CHAR)
REMARK VARCHAR2(4000 CHAR)
SG_APP_NO VARCHAR2(16 CHAR)

复制代码

xifenfei · 发表于 2014-6-13 23:49:15

alert 日志信息

Thu Jun 12 11:04:41 2014
Errors in file /u01/app/oracle/admin/qhdlyx/udump/qhdlyx_ora_9140.trc:
ORA-00600: internal error code, arguments: [kgh_heap_sizes:ds], [0x9FFFFFFFBF068D18], [], [], [], [], [], []
ORA-00600: internal error code, arguments: [kgh_heap_sizes:ds], [0x9FFFFFFFBF068D18], [], [], [], [], [], []
ORA-00600: internal error code, arguments: [kgh_heap_sizes:ds], [0x9FFFFFFFBF068D18], [], [], [], [], [], []
ORA-00600: internal error code, arguments: [kgh_heap_sizes:ds], [0x9FFFFFFFBF068D18], [], [], [], [], [], []
ORA-00600: internal error code, arguments: [kgh_heap_sizes:ds], [0x9FFFFFFFBF068D18], [], [], [], [], [], []
ORA-00600: internal error code, arguments: [kghGetHpSz1], [0x9FFFFFFFBF068F58], [], [], [], [], [], []
ORA-00600: internal error code, arguments: [kgh_heap_sizes:ds], [0x9FFFFFFFBF068D18], [], [], [], [], [], []
ORA-07445: exception encountered: core dump [_memcpy()+2448] [SIGSEGV] [Address not mapped to object] [0x9FFFFFFFBF200000] [] []
Thu Jun 12 11:04:43 2014
Errors in file /u01/app/oracle/admin/qhdlyx/udump/qhdlyx_ora_9140.trc:
ORA-00600: internal error code, arguments: [kgh_heap_sizes:ds], [0x9FFFFFFFBF068D18], [], [], [], [], [], []
ORA-00600: internal error code, arguments: [kgh_heap_sizes:ds], [0x9FFFFFFFBF068D18], [], [], [], [], [], []
ORA-00600: internal error code, arguments: [kgh_heap_sizes:ds], [0x9FFFFFFFBF068D18], [], [], [], [], [], []
ORA-00600: internal error code, arguments: [kgh_heap_sizes:ds], [0x9FFFFFFFBF068D18], [], [], [], [], [], []
ORA-00600: internal error code, arguments: [kgh_heap_sizes:ds], [0x9FFFFFFFBF068D18], [], [], [], [], [], []
ORA-00600: internal error code, arguments: [kgh_heap_sizes:ds], [0x9FFFFFFFBF068D18], [], [], [], [], [], []
ORA-00600: internal error code, arguments: [kghGetHpSz1], [0x9FFFFFFFBF068F58], [], [], [], [], [], []
ORA-00600: internal error code, arguments: [kgh_heap_sizes:ds], [0x9FFFFFFFBF068D18], [], [], [], [], [], []
ORA-07445: exception encountered: core dump [_memcpy()+2448] [SIGSEGV] [Address not mapped to object] [0x9FFFFFFFBF200000] [] []
Thu Jun 12 13:02:07 2014

复制代码

trace文件记录

*** 2014-06-12 11:04:28.049
ksedmp: internal or fatal error
ORA-07445: exception encountered: core dump [_memcpy()+2448] [SIGSEGV] [Address not mapped to object] [0x9FFFFFFFBF200000] [] []
Current SQL statement for this session:
UPDATE /*+ RESTRICT_ALL_REF_CONS */ "SGPM"."S_95598_WKST" SET "ATTACH" = :a1 WHERE "APP_NO" = :b0
----- Call Stack Trace -----
calling call entry argument values in hex
location type point (? means dubious value)
-------------------- -------- -------------------- ----------------------------
ksedst()+64 call ksedst1() 000000001 ? 000000001 ?
ksedmp()+2176 call ksedst() 000000001 ?
C050000000000C9F ?
4000000003FED9A0 ?
000000000 ? 000000000 ?
000000000 ?
ssexhd()+1264 call ksedmp() 000000003 ?
9FFFFFFFFFFDDFA0 ?
60000000000B5D60 ?
9FFFFFFFFFFDE570 ?
C050000000000B9F ?
40000000068C6C00 ?
FFFFFFFFFFFF96DD ?
60000000000C2E10 ?
<kernel> call ssexhd() C0000000B0276418 ?
60000000000C4D00 ?
C0000000400077C0 ?
60000000000B5D60 ?
_memcpy()+2448 call <kernel>
updgrh()+9616 call _memcpy() 000000000 ? 000000000 ?
000000000 ? 000000000 ?
000000000 ? 000000000 ?
000000000 ? 000000000 ?
upduaw()+208 call updgrh() C000000097AB3510 ?
9FFFFFFFBF3C6EC0 ?
60000000000B5D60 ?
4000000002C41A90 ?
00002E99D ? 000000000 ?
C000000000001BBE ?
kdusru()+880 call upduaw() 9FFFFFFFBF3F9218 ?
000000000 ?
9FFFFFFFBF3C7198 ?
kauupd()+704 call kdusru() 9FFFFFFFBF3F0DC4 ?
000000000 ?
9FFFFFFFBF3C6EC0 ?
000000000 ?
60000000000B5D60 ?
C00000000000122C ?
4000000002C44680 ?
00002E855 ?
updrow()+2592 call kauupd() 9FFFFFFFBF3F0DC0 ?
000000000 ?
9FFFFFFFBF3C6EC0 ?
000000000 ?
C000000097AB4490 ?
000000003 ? 0000CEF34 ?
C000000097AB3450 ?
qerupRowProcedure() call updrow() 9FFFFFFFFFFF3D60 ?
+176 4000000002C54480 ?
qerupFetch()+1328 call qerupRowProcedure() C000000097AB31F4 ?
000000000 ?
C0000000000013AD ?
4000000002C54A10 ?
000028499 ? 000000000 ?
updaul()+4544 call qerupFetch() C000000097AB3748 ?
000000000 ?
9FFFFFFFFFFF3D78 ?
000007FFF ?
9FFFFFFFFFFF3D70 ?
60000000000B5D60 ?
9FFFFFFFFFFF4500 ?
C0000000000018B9 ?
updThreePhaseExe()+ call updaul() 9FFFFFFFFFFF4F90 ?
1024 4000000002FE0830 ?
000028217 ?
9FFFFFFFFFFF4540 ?
60000000000B5D60 ?
C00000000000295A ?
600000000003B7D0 ?
9FFFFFFFBF3F9224 ?
updexe()+720 call updThreePhaseExe() C000000097AB6B98 ?
000000000 ?
9FFFFFFFBF3C6EC0 ?
9FFFFFFFFFFF5040 ?
opiexe()+7872 call updexe() C000000097AB6B98 ?
C000000097AB31F4 ?
C000000097AB31C8 ?
9FFFFFFFBF3C6EC0 ?
C000000097AB3694 ?
9FFFFFFFBF3F9218 ?
042222008 ?
C000000097AB6B98 ?
kpoal8()+3872 call opiexe() 9FFFFFFFFFFF6EE0 ?
4000000002A89C60 ?
00001E815 ?
9FFFFFFFFFFF5260 ?
60000000000B5D60 ?
C0000000000012AD ?
60000000000C26D8 ?
60000000000314C0 ?
opiodr()+2128 call kpoal8() 9FFFFFFFFFFF7610 ?
C000000000001530 ?
9FFFFFFFFFFF9CF0 ?
9FFFFFFFFFFF6F30 ?
60000000000B5D60 ?
9FFFFFFFBE5820A0 ?
ttcpip()+1680 call opiodr() 00000005E ? 000000017 ?
4000000001B03620 ?
0000046B0 ?
9FFFFFFFFFFF7620 ?
opitsk()+2336 call ttcpip() 600000000003D0C0 ?
000000000 ?
9FFFFFFFFFFF9CF0 ?
000000001 ?
9FFFFFFFFFFF9E60 ?
9FFFFFFFFFFF9C54 ?
4000000001BE9620 ?
000000000 ?
opiino()+1840 call opitsk() 000000000 ? 000000000 ?
60000000000B5D60 ?
40000000027FBEB0 ?
00001804D ?
4000000001B03638 ?
opiodr()+2128 call opiino() 00000003C ?
9FFFFFFFFFFFC6B0 ?
9FFFFFFFFFFFEE50 ?
9FFFFFFFFFFFBB70 ?
60000000000B5D60 ?
C000000000001530 ?
opidrv()+1088 call opiodr() 00000003C ? 000000004 ?
4000000001B030D0 ?
0000046B0 ?
9FFFFFFFFFFFC6C0 ?
60000000000B5D60 ?
sou2o()+336 call opidrv() 00000003C ?
9FFFFFFFFFFFEE50 ?
60000000000C26D0 ?
opimai_real()+224 call sou2o() 9FFFFFFFFFFFEE70 ?
00000003C ? 000000004 ?
9FFFFFFFFFFFEE50 ?
main()+368 call opimai_real() 000000000 ?
9FFFFFFFFFFFEEA0 ?
main_opd_entry()+80 call main() 000000002 ?
9FFFFFFFFFFFF360 ?
60000000000B5D60 ?
C000000000000004 ?
--------------------- Binary Stack Dump ---------------------

复制代码

update表结构

SQL> desc SGPM.S_95598_WKST
Name Null? Type
----------------------------------------- -------- ----------------------------
APP_NO NOT NULL VARCHAR2(16 CHAR)
ID NOT NULL NUMBER(16)
GROUP_NO VARCHAR2(32 CHAR)
BUSI_TYPE_CODE VARCHAR2(8 CHAR)
BUSI_SUB_TYPE VARCHAR2(10 CHAR)
COUNTY_CODE VARCHAR2(8 CHAR)
URBAN_RURAL_FLAG VARCHAR2(8 CHAR)
ORG_NO VARCHAR2(16 CHAR)
EMP_NO VARCHAR2(16 CHAR)
HANDLE_TIME DATE
ACCEPT_MODE VARCHAR2(8 CHAR)
ACCEPT_CONTENT VARCHAR2(4000 CHAR)
HANDLE_OPINION VARCHAR2(4000 CHAR)
REPLY_FLAG VARCHAR2(8 CHAR)
REPLY_DATE NUMBER
REPLY_MODE VARCHAR2(8 CHAR)
CONS_OPINION VARCHAR2(4000 CHAR)
REPLY_TEL VARCHAR2(32 CHAR)
SEND_DATE DATE
ATTACH BLOB -----------------正好更新的是这个字段
IDEN_MODE VARCHAR2(8 CHAR)
CERT_TYPE_CODE VARCHAR2(8 CHAR)
CERT_NO VARCHAR2(32 CHAR)
ARC_MODE VARCHAR2(8 CHAR)
INTEGRITY_FLAG VARCHAR2(8 CHAR)
ACCURACY_FLAG VARCHAR2(8 CHAR)
ARC_OPINION VARCHAR2(4000 CHAR)
TIME_LEN NUMBER(15)
ARC_EMP_NAME VARCHAR2(16 CHAR)
ARC_DATE DATE
HANDLE_STATUS_CODE VARCHAR2(256 CHAR)
REPLY_SUCC_FLAG VARCHAR2(8 CHAR)
RETVISIT_FAIL_REASON VARCHAR2(256 CHAR)
REPLY_FAIL_TIMES NUMBER(5)
CUST_NO VARCHAR2(48 CHAR)
CUST_TYPE VARCHAR2(24 CHAR)
REAL_ARRIVE_TIME DATE
CUST_NAME VARCHAR2(768 CHAR)
VISIT_SCORE NUMBER(5)
TG_NO VARCHAR2(16 CHAR)
METER_NO VARCHAR2(32 CHAR)
DISPATCH_LEN NUMBER(15)
TRANSFER_LEN NUMBER(15)
IMPORTANT_CUST_LEVEL VARCHAR2(8 CHAR)
OVER_TIME DATE
CITY_CODE VARCHAR2(8 CHAR)
TARGET_DEPT VARCHAR2(16 CHAR)
APP_REJECT_FLAG VARCHAR2(8 CHAR)
REMARK VARCHAR2(4000 CHAR)
SG_APP_NO VARCHAR2(16 CHAR)

复制代码

xifenfei · 发表于 2014-6-13 23:49:36

alert 日志信息

Thu Jun 12 11:04:41 2014
Errors in file /u01/app/oracle/admin/qhdlyx/udump/qhdlyx_ora_9140.trc:
ORA-00600: internal error code, arguments: [kgh_heap_sizes:ds], [0x9FFFFFFFBF068D18], [], [], [], [], [], []
ORA-00600: internal error code, arguments: [kgh_heap_sizes:ds], [0x9FFFFFFFBF068D18], [], [], [], [], [], []
ORA-00600: internal error code, arguments: [kgh_heap_sizes:ds], [0x9FFFFFFFBF068D18], [], [], [], [], [], []
ORA-00600: internal error code, arguments: [kgh_heap_sizes:ds], [0x9FFFFFFFBF068D18], [], [], [], [], [], []
ORA-00600: internal error code, arguments: [kgh_heap_sizes:ds], [0x9FFFFFFFBF068D18], [], [], [], [], [], []
ORA-00600: internal error code, arguments: [kghGetHpSz1], [0x9FFFFFFFBF068F58], [], [], [], [], [], []
ORA-00600: internal error code, arguments: [kgh_heap_sizes:ds], [0x9FFFFFFFBF068D18], [], [], [], [], [], []
ORA-07445: exception encountered: core dump [_memcpy()+2448] [SIGSEGV] [Address not mapped to object] [0x9FFFFFFFBF200000] [] []
Thu Jun 12 11:04:43 2014
Errors in file /u01/app/oracle/admin/qhdlyx/udump/qhdlyx_ora_9140.trc:
ORA-00600: internal error code, arguments: [kgh_heap_sizes:ds], [0x9FFFFFFFBF068D18], [], [], [], [], [], []
ORA-00600: internal error code, arguments: [kgh_heap_sizes:ds], [0x9FFFFFFFBF068D18], [], [], [], [], [], []
ORA-00600: internal error code, arguments: [kgh_heap_sizes:ds], [0x9FFFFFFFBF068D18], [], [], [], [], [], []
ORA-00600: internal error code, arguments: [kgh_heap_sizes:ds], [0x9FFFFFFFBF068D18], [], [], [], [], [], []
ORA-00600: internal error code, arguments: [kgh_heap_sizes:ds], [0x9FFFFFFFBF068D18], [], [], [], [], [], []
ORA-00600: internal error code, arguments: [kgh_heap_sizes:ds], [0x9FFFFFFFBF068D18], [], [], [], [], [], []
ORA-00600: internal error code, arguments: [kghGetHpSz1], [0x9FFFFFFFBF068F58], [], [], [], [], [], []
ORA-00600: internal error code, arguments: [kgh_heap_sizes:ds], [0x9FFFFFFFBF068D18], [], [], [], [], [], []
ORA-07445: exception encountered: core dump [_memcpy()+2448] [SIGSEGV] [Address not mapped to object] [0x9FFFFFFFBF200000] [] []
Thu Jun 12 13:02:07 2014

复制代码

trace文件记录

*** 2014-06-12 11:04:28.049
ksedmp: internal or fatal error
ORA-07445: exception encountered: core dump [_memcpy()+2448] [SIGSEGV] [Address not mapped to object] [0x9FFFFFFFBF200000] [] []
Current SQL statement for this session:
UPDATE /*+ RESTRICT_ALL_REF_CONS */ "SGPM"."S_95598_WKST" SET "ATTACH" = :a1 WHERE "APP_NO" = :b0
----- Call Stack Trace -----
calling call entry argument values in hex
location type point (? means dubious value)
-------------------- -------- -------------------- ----------------------------
ksedst()+64 call ksedst1() 000000001 ? 000000001 ?
ksedmp()+2176 call ksedst() 000000001 ?
C050000000000C9F ?
4000000003FED9A0 ?
000000000 ? 000000000 ?
000000000 ?
ssexhd()+1264 call ksedmp() 000000003 ?
9FFFFFFFFFFDDFA0 ?
60000000000B5D60 ?
9FFFFFFFFFFDE570 ?
C050000000000B9F ?
40000000068C6C00 ?
FFFFFFFFFFFF96DD ?
60000000000C2E10 ?
<kernel> call ssexhd() C0000000B0276418 ?
60000000000C4D00 ?
C0000000400077C0 ?
60000000000B5D60 ?
_memcpy()+2448 call <kernel>
updgrh()+9616 call _memcpy() 000000000 ? 000000000 ?
000000000 ? 000000000 ?
000000000 ? 000000000 ?
000000000 ? 000000000 ?
upduaw()+208 call updgrh() C000000097AB3510 ?
9FFFFFFFBF3C6EC0 ?
60000000000B5D60 ?
4000000002C41A90 ?
00002E99D ? 000000000 ?
C000000000001BBE ?
kdusru()+880 call upduaw() 9FFFFFFFBF3F9218 ?
000000000 ?
9FFFFFFFBF3C7198 ?
kauupd()+704 call kdusru() 9FFFFFFFBF3F0DC4 ?
000000000 ?
9FFFFFFFBF3C6EC0 ?
000000000 ?
60000000000B5D60 ?
C00000000000122C ?
4000000002C44680 ?
00002E855 ?
updrow()+2592 call kauupd() 9FFFFFFFBF3F0DC0 ?
000000000 ?
9FFFFFFFBF3C6EC0 ?
000000000 ?
C000000097AB4490 ?
000000003 ? 0000CEF34 ?
C000000097AB3450 ?
qerupRowProcedure() call updrow() 9FFFFFFFFFFF3D60 ?
+176 4000000002C54480 ?
qerupFetch()+1328 call qerupRowProcedure() C000000097AB31F4 ?
000000000 ?
C0000000000013AD ?
4000000002C54A10 ?
000028499 ? 000000000 ?
updaul()+4544 call qerupFetch() C000000097AB3748 ?
000000000 ?
9FFFFFFFFFFF3D78 ?
000007FFF ?
9FFFFFFFFFFF3D70 ?
60000000000B5D60 ?
9FFFFFFFFFFF4500 ?
C0000000000018B9 ?
updThreePhaseExe()+ call updaul() 9FFFFFFFFFFF4F90 ?
1024 4000000002FE0830 ?
000028217 ?
9FFFFFFFFFFF4540 ?
60000000000B5D60 ?
C00000000000295A ?
600000000003B7D0 ?
9FFFFFFFBF3F9224 ?
updexe()+720 call updThreePhaseExe() C000000097AB6B98 ?
000000000 ?
9FFFFFFFBF3C6EC0 ?
9FFFFFFFFFFF5040 ?
opiexe()+7872 call updexe() C000000097AB6B98 ?
C000000097AB31F4 ?
C000000097AB31C8 ?
9FFFFFFFBF3C6EC0 ?
C000000097AB3694 ?
9FFFFFFFBF3F9218 ?
042222008 ?
C000000097AB6B98 ?
kpoal8()+3872 call opiexe() 9FFFFFFFFFFF6EE0 ?
4000000002A89C60 ?
00001E815 ?
9FFFFFFFFFFF5260 ?
60000000000B5D60 ?
C0000000000012AD ?
60000000000C26D8 ?
60000000000314C0 ?
opiodr()+2128 call kpoal8() 9FFFFFFFFFFF7610 ?
C000000000001530 ?
9FFFFFFFFFFF9CF0 ?
9FFFFFFFFFFF6F30 ?
60000000000B5D60 ?
9FFFFFFFBE5820A0 ?
ttcpip()+1680 call opiodr() 00000005E ? 000000017 ?
4000000001B03620 ?
0000046B0 ?
9FFFFFFFFFFF7620 ?
opitsk()+2336 call ttcpip() 600000000003D0C0 ?
000000000 ?
9FFFFFFFFFFF9CF0 ?
000000001 ?
9FFFFFFFFFFF9E60 ?
9FFFFFFFFFFF9C54 ?
4000000001BE9620 ?
000000000 ?
opiino()+1840 call opitsk() 000000000 ? 000000000 ?
60000000000B5D60 ?
40000000027FBEB0 ?
00001804D ?
4000000001B03638 ?
opiodr()+2128 call opiino() 00000003C ?
9FFFFFFFFFFFC6B0 ?
9FFFFFFFFFFFEE50 ?
9FFFFFFFFFFFBB70 ?
60000000000B5D60 ?
C000000000001530 ?
opidrv()+1088 call opiodr() 00000003C ? 000000004 ?
4000000001B030D0 ?
0000046B0 ?
9FFFFFFFFFFFC6C0 ?
60000000000B5D60 ?
sou2o()+336 call opidrv() 00000003C ?
9FFFFFFFFFFFEE50 ?
60000000000C26D0 ?
opimai_real()+224 call sou2o() 9FFFFFFFFFFFEE70 ?
00000003C ? 000000004 ?
9FFFFFFFFFFFEE50 ?
main()+368 call opimai_real() 000000000 ?
9FFFFFFFFFFFEEA0 ?
main_opd_entry()+80 call main() 000000002 ?
9FFFFFFFFFFFF360 ?
60000000000B5D60 ?
C000000000000004 ?
--------------------- Binary Stack Dump ---------------------

复制代码

update表结构

SQL> desc SGPM.S_95598_WKST
Name Null? Type
----------------------------------------- -------- ----------------------------
APP_NO NOT NULL VARCHAR2(16 CHAR)
ID NOT NULL NUMBER(16)
GROUP_NO VARCHAR2(32 CHAR)
BUSI_TYPE_CODE VARCHAR2(8 CHAR)
BUSI_SUB_TYPE VARCHAR2(10 CHAR)
COUNTY_CODE VARCHAR2(8 CHAR)
URBAN_RURAL_FLAG VARCHAR2(8 CHAR)
ORG_NO VARCHAR2(16 CHAR)
EMP_NO VARCHAR2(16 CHAR)
HANDLE_TIME DATE
ACCEPT_MODE VARCHAR2(8 CHAR)
ACCEPT_CONTENT VARCHAR2(4000 CHAR)
HANDLE_OPINION VARCHAR2(4000 CHAR)
REPLY_FLAG VARCHAR2(8 CHAR)
REPLY_DATE NUMBER
REPLY_MODE VARCHAR2(8 CHAR)
CONS_OPINION VARCHAR2(4000 CHAR)
REPLY_TEL VARCHAR2(32 CHAR)
SEND_DATE DATE
ATTACH BLOB -----------------正好更新的是这个字段
IDEN_MODE VARCHAR2(8 CHAR)
CERT_TYPE_CODE VARCHAR2(8 CHAR)
CERT_NO VARCHAR2(32 CHAR)
ARC_MODE VARCHAR2(8 CHAR)
INTEGRITY_FLAG VARCHAR2(8 CHAR)
ACCURACY_FLAG VARCHAR2(8 CHAR)
ARC_OPINION VARCHAR2(4000 CHAR)
TIME_LEN NUMBER(15)
ARC_EMP_NAME VARCHAR2(16 CHAR)
ARC_DATE DATE
HANDLE_STATUS_CODE VARCHAR2(256 CHAR)
REPLY_SUCC_FLAG VARCHAR2(8 CHAR)
RETVISIT_FAIL_REASON VARCHAR2(256 CHAR)
REPLY_FAIL_TIMES NUMBER(5)
CUST_NO VARCHAR2(48 CHAR)
CUST_TYPE VARCHAR2(24 CHAR)
REAL_ARRIVE_TIME DATE
CUST_NAME VARCHAR2(768 CHAR)
VISIT_SCORE NUMBER(5)
TG_NO VARCHAR2(16 CHAR)
METER_NO VARCHAR2(32 CHAR)
DISPATCH_LEN NUMBER(15)
TRANSFER_LEN NUMBER(15)
IMPORTANT_CUST_LEVEL VARCHAR2(8 CHAR)
OVER_TIME DATE
CITY_CODE VARCHAR2(8 CHAR)
TARGET_DEPT VARCHAR2(16 CHAR)
APP_REJECT_FLAG VARCHAR2(8 CHAR)
REMARK VARCHAR2(4000 CHAR)
SG_APP_NO VARCHAR2(16 CHAR)

复制代码

xifenfei · 发表于 2014-6-14 00:07:43

alert 日志信息

Thu Jun 12 11:04:41 2014
Errors in file /u01/app/oracle/admin/qhdlyx/udump/qhdlyx_ora_9140.trc:
ORA-00600: internal error code, arguments: [kgh_heap_sizes:ds], [0x9FFFFFFFBF068D18], [], [], [], [], [], []
ORA-00600: internal error code, arguments: [kgh_heap_sizes:ds], [0x9FFFFFFFBF068D18], [], [], [], [], [], []
ORA-00600: internal error code, arguments: [kgh_heap_sizes:ds], [0x9FFFFFFFBF068D18], [], [], [], [], [], []
ORA-00600: internal error code, arguments: [kgh_heap_sizes:ds], [0x9FFFFFFFBF068D18], [], [], [], [], [], []
ORA-00600: internal error code, arguments: [kgh_heap_sizes:ds], [0x9FFFFFFFBF068D18], [], [], [], [], [], []
ORA-00600: internal error code, arguments: [kghGetHpSz1], [0x9FFFFFFFBF068F58], [], [], [], [], [], []
ORA-00600: internal error code, arguments: [kgh_heap_sizes:ds], [0x9FFFFFFFBF068D18], [], [], [], [], [], []
ORA-07445: exception encountered: core dump [_memcpy()+2448] [SIGSEGV] [Address not mapped to object] [0x9FFFFFFFBF200000] [] []
Thu Jun 12 11:04:43 2014
Errors in file /u01/app/oracle/admin/qhdlyx/udump/qhdlyx_ora_9140.trc:
ORA-00600: internal error code, arguments: [kgh_heap_sizes:ds], [0x9FFFFFFFBF068D18], [], [], [], [], [], []
ORA-00600: internal error code, arguments: [kgh_heap_sizes:ds], [0x9FFFFFFFBF068D18], [], [], [], [], [], []
ORA-00600: internal error code, arguments: [kgh_heap_sizes:ds], [0x9FFFFFFFBF068D18], [], [], [], [], [], []
ORA-00600: internal error code, arguments: [kgh_heap_sizes:ds], [0x9FFFFFFFBF068D18], [], [], [], [], [], []
ORA-00600: internal error code, arguments: [kgh_heap_sizes:ds], [0x9FFFFFFFBF068D18], [], [], [], [], [], []
ORA-00600: internal error code, arguments: [kgh_heap_sizes:ds], [0x9FFFFFFFBF068D18], [], [], [], [], [], []
ORA-00600: internal error code, arguments: [kghGetHpSz1], [0x9FFFFFFFBF068F58], [], [], [], [], [], []
ORA-00600: internal error code, arguments: [kgh_heap_sizes:ds], [0x9FFFFFFFBF068D18], [], [], [], [], [], []
ORA-07445: exception encountered: core dump [_memcpy()+2448] [SIGSEGV] [Address not mapped to object] [0x9FFFFFFFBF200000] [] []
Thu Jun 12 13:02:07 2014

复制代码

trace文件记录

*** 2014-06-12 11:04:28.049
ksedmp: internal or fatal error
ORA-07445: exception encountered: core dump [_memcpy()+2448] [SIGSEGV] [Address not mapped to object] [0x9FFFFFFFBF200000] [] []
Current SQL statement for this session:
UPDATE /*+ RESTRICT_ALL_REF_CONS */ "SGPM"."S_95598_WKST" SET "ATTACH" = :a1 WHERE "APP_NO" = :b0
----- Call Stack Trace -----
calling call entry argument values in hex
location type point (? means dubious value)
-------------------- -------- -------------------- ----------------------------
ksedst()+64 call ksedst1() 000000001 ? 000000001 ?
ksedmp()+2176 call ksedst() 000000001 ?
C050000000000C9F ?
4000000003FED9A0 ?
000000000 ? 000000000 ?
000000000 ?
ssexhd()+1264 call ksedmp() 000000003 ?
9FFFFFFFFFFDDFA0 ?
60000000000B5D60 ?
9FFFFFFFFFFDE570 ?
C050000000000B9F ?
40000000068C6C00 ?
FFFFFFFFFFFF96DD ?
60000000000C2E10 ?
<kernel> call ssexhd() C0000000B0276418 ?
60000000000C4D00 ?
C0000000400077C0 ?
60000000000B5D60 ?
_memcpy()+2448 call <kernel>
updgrh()+9616 call _memcpy() 000000000 ? 000000000 ?
000000000 ? 000000000 ?
000000000 ? 000000000 ?
000000000 ? 000000000 ?
upduaw()+208 call updgrh() C000000097AB3510 ?
9FFFFFFFBF3C6EC0 ?
60000000000B5D60 ?
4000000002C41A90 ?
00002E99D ? 000000000 ?
C000000000001BBE ?
kdusru()+880 call upduaw() 9FFFFFFFBF3F9218 ?
000000000 ?
9FFFFFFFBF3C7198 ?
kauupd()+704 call kdusru() 9FFFFFFFBF3F0DC4 ?
000000000 ?
9FFFFFFFBF3C6EC0 ?
000000000 ?
60000000000B5D60 ?
C00000000000122C ?
4000000002C44680 ?
00002E855 ?
updrow()+2592 call kauupd() 9FFFFFFFBF3F0DC0 ?
000000000 ?
9FFFFFFFBF3C6EC0 ?
000000000 ?
C000000097AB4490 ?
000000003 ? 0000CEF34 ?
C000000097AB3450 ?
qerupRowProcedure() call updrow() 9FFFFFFFFFFF3D60 ?
+176 4000000002C54480 ?
qerupFetch()+1328 call qerupRowProcedure() C000000097AB31F4 ?
000000000 ?
C0000000000013AD ?
4000000002C54A10 ?
000028499 ? 000000000 ?
updaul()+4544 call qerupFetch() C000000097AB3748 ?
000000000 ?
9FFFFFFFFFFF3D78 ?
000007FFF ?
9FFFFFFFFFFF3D70 ?
60000000000B5D60 ?
9FFFFFFFFFFF4500 ?
C0000000000018B9 ?
updThreePhaseExe()+ call updaul() 9FFFFFFFFFFF4F90 ?
1024 4000000002FE0830 ?
000028217 ?
9FFFFFFFFFFF4540 ?
60000000000B5D60 ?
C00000000000295A ?
600000000003B7D0 ?
9FFFFFFFBF3F9224 ?
updexe()+720 call updThreePhaseExe() C000000097AB6B98 ?
000000000 ?
9FFFFFFFBF3C6EC0 ?
9FFFFFFFFFFF5040 ?
opiexe()+7872 call updexe() C000000097AB6B98 ?
C000000097AB31F4 ?
C000000097AB31C8 ?
9FFFFFFFBF3C6EC0 ?
C000000097AB3694 ?
9FFFFFFFBF3F9218 ?
042222008 ?
C000000097AB6B98 ?
kpoal8()+3872 call opiexe() 9FFFFFFFFFFF6EE0 ?
4000000002A89C60 ?
00001E815 ?
9FFFFFFFFFFF5260 ?
60000000000B5D60 ?
C0000000000012AD ?
60000000000C26D8 ?
60000000000314C0 ?
opiodr()+2128 call kpoal8() 9FFFFFFFFFFF7610 ?
C000000000001530 ?
9FFFFFFFFFFF9CF0 ?
9FFFFFFFFFFF6F30 ?
60000000000B5D60 ?
9FFFFFFFBE5820A0 ?
ttcpip()+1680 call opiodr() 00000005E ? 000000017 ?
4000000001B03620 ?
0000046B0 ?
9FFFFFFFFFFF7620 ?
opitsk()+2336 call ttcpip() 600000000003D0C0 ?
000000000 ?
9FFFFFFFFFFF9CF0 ?
000000001 ?
9FFFFFFFFFFF9E60 ?
9FFFFFFFFFFF9C54 ?
4000000001BE9620 ?
000000000 ?
opiino()+1840 call opitsk() 000000000 ? 000000000 ?
60000000000B5D60 ?
40000000027FBEB0 ?
00001804D ?
4000000001B03638 ?
opiodr()+2128 call opiino() 00000003C ?
9FFFFFFFFFFFC6B0 ?
9FFFFFFFFFFFEE50 ?
9FFFFFFFFFFFBB70 ?
60000000000B5D60 ?
C000000000001530 ?
opidrv()+1088 call opiodr() 00000003C ? 000000004 ?
4000000001B030D0 ?
0000046B0 ?
9FFFFFFFFFFFC6C0 ?
60000000000B5D60 ?
sou2o()+336 call opidrv() 00000003C ?
9FFFFFFFFFFFEE50 ?
60000000000C26D0 ?
opimai_real()+224 call sou2o() 9FFFFFFFFFFFEE70 ?
00000003C ? 000000004 ?
9FFFFFFFFFFFEE50 ?
main()+368 call opimai_real() 000000000 ?
9FFFFFFFFFFFEEA0 ?
main_opd_entry()+80 call main() 000000002 ?
9FFFFFFFFFFFF360 ?
60000000000B5D60 ?
C000000000000004 ?
--------------------- Binary Stack Dump ---------------------

复制代码

update表结构

SQL> desc SGPM.S_95598_WKST
Name Null? Type
----------------------------------------- -------- ----------------------------
APP_NO NOT NULL VARCHAR2(16 CHAR)
ID NOT NULL NUMBER(16)
GROUP_NO VARCHAR2(32 CHAR)
BUSI_TYPE_CODE VARCHAR2(8 CHAR)
BUSI_SUB_TYPE VARCHAR2(10 CHAR)
COUNTY_CODE VARCHAR2(8 CHAR)
URBAN_RURAL_FLAG VARCHAR2(8 CHAR)
ORG_NO VARCHAR2(16 CHAR)
EMP_NO VARCHAR2(16 CHAR)
HANDLE_TIME DATE
ACCEPT_MODE VARCHAR2(8 CHAR)
ACCEPT_CONTENT VARCHAR2(4000 CHAR)
HANDLE_OPINION VARCHAR2(4000 CHAR)
REPLY_FLAG VARCHAR2(8 CHAR)
REPLY_DATE NUMBER
REPLY_MODE VARCHAR2(8 CHAR)
CONS_OPINION VARCHAR2(4000 CHAR)
REPLY_TEL VARCHAR2(32 CHAR)
SEND_DATE DATE
ATTACH BLOB -----------------正好更新的是这个字段
IDEN_MODE VARCHAR2(8 CHAR)
CERT_TYPE_CODE VARCHAR2(8 CHAR)
CERT_NO VARCHAR2(32 CHAR)
ARC_MODE VARCHAR2(8 CHAR)
INTEGRITY_FLAG VARCHAR2(8 CHAR)
ACCURACY_FLAG VARCHAR2(8 CHAR)
ARC_OPINION VARCHAR2(4000 CHAR)
TIME_LEN NUMBER(15)
ARC_EMP_NAME VARCHAR2(16 CHAR)
ARC_DATE DATE
HANDLE_STATUS_CODE VARCHAR2(256 CHAR)
REPLY_SUCC_FLAG VARCHAR2(8 CHAR)
RETVISIT_FAIL_REASON VARCHAR2(256 CHAR)
REPLY_FAIL_TIMES NUMBER(5)
CUST_NO VARCHAR2(48 CHAR)
CUST_TYPE VARCHAR2(24 CHAR)
REAL_ARRIVE_TIME DATE
CUST_NAME VARCHAR2(768 CHAR)
VISIT_SCORE NUMBER(5)
TG_NO VARCHAR2(16 CHAR)
METER_NO VARCHAR2(32 CHAR)
DISPATCH_LEN NUMBER(15)
TRANSFER_LEN NUMBER(15)
IMPORTANT_CUST_LEVEL VARCHAR2(8 CHAR)
OVER_TIME DATE
CITY_CODE VARCHAR2(8 CHAR)
TARGET_DEPT VARCHAR2(16 CHAR)
APP_REJECT_FLAG VARCHAR2(8 CHAR)
REMARK VARCHAR2(4000 CHAR)
SG_APP_NO VARCHAR2(16 CHAR)

复制代码

xifenfei · 发表于 2014-6-14 00:11:12

alert 日志信息

Thu Jun 12 11:04:41 2014
Errors in file /u01/app/oracle/admin/qhdlyx/udump/qhdlyx_ora_9140.trc:
ORA-00600: internal error code, arguments: [kgh_heap_sizes:ds], [0x9FFFFFFFBF068D18], [], [], [], [], [], []
ORA-00600: internal error code, arguments: [kgh_heap_sizes:ds], [0x9FFFFFFFBF068D18], [], [], [], [], [], []
ORA-00600: internal error code, arguments: [kgh_heap_sizes:ds], [0x9FFFFFFFBF068D18], [], [], [], [], [], []
ORA-00600: internal error code, arguments: [kgh_heap_sizes:ds], [0x9FFFFFFFBF068D18], [], [], [], [], [], []
ORA-00600: internal error code, arguments: [kgh_heap_sizes:ds], [0x9FFFFFFFBF068D18], [], [], [], [], [], []
ORA-00600: internal error code, arguments: [kghGetHpSz1], [0x9FFFFFFFBF068F58], [], [], [], [], [], []
ORA-00600: internal error code, arguments: [kgh_heap_sizes:ds], [0x9FFFFFFFBF068D18], [], [], [], [], [], []
ORA-07445: exception encountered: core dump [_memcpy()+2448] [SIGSEGV] [Address not mapped to object] [0x9FFFFFFFBF200000] [] []
Thu Jun 12 11:04:43 2014
Errors in file /u01/app/oracle/admin/qhdlyx/udump/qhdlyx_ora_9140.trc:
ORA-00600: internal error code, arguments: [kgh_heap_sizes:ds], [0x9FFFFFFFBF068D18], [], [], [], [], [], []
ORA-00600: internal error code, arguments: [kgh_heap_sizes:ds], [0x9FFFFFFFBF068D18], [], [], [], [], [], []
ORA-00600: internal error code, arguments: [kgh_heap_sizes:ds], [0x9FFFFFFFBF068D18], [], [], [], [], [], []
ORA-00600: internal error code, arguments: [kgh_heap_sizes:ds], [0x9FFFFFFFBF068D18], [], [], [], [], [], []
ORA-00600: internal error code, arguments: [kgh_heap_sizes:ds], [0x9FFFFFFFBF068D18], [], [], [], [], [], []
ORA-00600: internal error code, arguments: [kgh_heap_sizes:ds], [0x9FFFFFFFBF068D18], [], [], [], [], [], []
ORA-00600: internal error code, arguments: [kghGetHpSz1], [0x9FFFFFFFBF068F58], [], [], [], [], [], []
ORA-00600: internal error code, arguments: [kgh_heap_sizes:ds], [0x9FFFFFFFBF068D18], [], [], [], [], [], []
ORA-07445: exception encountered: core dump [_memcpy()+2448] [SIGSEGV] [Address not mapped to object] [0x9FFFFFFFBF200000] [] []
Thu Jun 12 13:02:07 2014

复制代码

trace文件记录

*** 2014-06-12 11:04:28.049
ksedmp: internal or fatal error
ORA-07445: exception encountered: core dump [_memcpy()+2448] [SIGSEGV] [Address not mapped to object] [0x9FFFFFFFBF200000] [] []
Current SQL statement for this session:
UPDATE /*+ RESTRICT_ALL_REF_CONS */ "SGPM"."S_95598_WKST" SET "ATTACH" = :a1 WHERE "APP_NO" = :b0
----- Call Stack Trace -----
calling call entry argument values in hex
location type point (? means dubious value)
-------------------- -------- -------------------- ----------------------------
ksedst()+64 call ksedst1() 000000001 ? 000000001 ?
ksedmp()+2176 call ksedst() 000000001 ?
C050000000000C9F ?
4000000003FED9A0 ?
000000000 ? 000000000 ?
000000000 ?
ssexhd()+1264 call ksedmp() 000000003 ?
9FFFFFFFFFFDDFA0 ?
60000000000B5D60 ?
9FFFFFFFFFFDE570 ?
C050000000000B9F ?
40000000068C6C00 ?
FFFFFFFFFFFF96DD ?
60000000000C2E10 ?
<kernel> call ssexhd() C0000000B0276418 ?
60000000000C4D00 ?
C0000000400077C0 ?
60000000000B5D60 ?
_memcpy()+2448 call <kernel>
updgrh()+9616 call _memcpy() 000000000 ? 000000000 ?
000000000 ? 000000000 ?
000000000 ? 000000000 ?
000000000 ? 000000000 ?
upduaw()+208 call updgrh() C000000097AB3510 ?
9FFFFFFFBF3C6EC0 ?
60000000000B5D60 ?
4000000002C41A90 ?
00002E99D ? 000000000 ?
C000000000001BBE ?
kdusru()+880 call upduaw() 9FFFFFFFBF3F9218 ?
000000000 ?
9FFFFFFFBF3C7198 ?
kauupd()+704 call kdusru() 9FFFFFFFBF3F0DC4 ?
000000000 ?
9FFFFFFFBF3C6EC0 ?
000000000 ?
60000000000B5D60 ?
C00000000000122C ?
4000000002C44680 ?
00002E855 ?
updrow()+2592 call kauupd() 9FFFFFFFBF3F0DC0 ?
000000000 ?
9FFFFFFFBF3C6EC0 ?
000000000 ?
C000000097AB4490 ?
000000003 ? 0000CEF34 ?
C000000097AB3450 ?
qerupRowProcedure() call updrow() 9FFFFFFFFFFF3D60 ?
+176 4000000002C54480 ?
qerupFetch()+1328 call qerupRowProcedure() C000000097AB31F4 ?
000000000 ?
C0000000000013AD ?
4000000002C54A10 ?
000028499 ? 000000000 ?
updaul()+4544 call qerupFetch() C000000097AB3748 ?
000000000 ?
9FFFFFFFFFFF3D78 ?
000007FFF ?
9FFFFFFFFFFF3D70 ?
60000000000B5D60 ?
9FFFFFFFFFFF4500 ?
C0000000000018B9 ?
updThreePhaseExe()+ call updaul() 9FFFFFFFFFFF4F90 ?
1024 4000000002FE0830 ?
000028217 ?
9FFFFFFFFFFF4540 ?
60000000000B5D60 ?
C00000000000295A ?
600000000003B7D0 ?
9FFFFFFFBF3F9224 ?
updexe()+720 call updThreePhaseExe() C000000097AB6B98 ?
000000000 ?
9FFFFFFFBF3C6EC0 ?
9FFFFFFFFFFF5040 ?
opiexe()+7872 call updexe() C000000097AB6B98 ?
C000000097AB31F4 ?
C000000097AB31C8 ?
9FFFFFFFBF3C6EC0 ?
C000000097AB3694 ?
9FFFFFFFBF3F9218 ?
042222008 ?
C000000097AB6B98 ?
kpoal8()+3872 call opiexe() 9FFFFFFFFFFF6EE0 ?
4000000002A89C60 ?
00001E815 ?
9FFFFFFFFFFF5260 ?
60000000000B5D60 ?
C0000000000012AD ?
60000000000C26D8 ?
60000000000314C0 ?
opiodr()+2128 call kpoal8() 9FFFFFFFFFFF7610 ?
C000000000001530 ?
9FFFFFFFFFFF9CF0 ?
9FFFFFFFFFFF6F30 ?
60000000000B5D60 ?
9FFFFFFFBE5820A0 ?
ttcpip()+1680 call opiodr() 00000005E ? 000000017 ?
4000000001B03620 ?
0000046B0 ?
9FFFFFFFFFFF7620 ?
opitsk()+2336 call ttcpip() 600000000003D0C0 ?
000000000 ?
9FFFFFFFFFFF9CF0 ?
000000001 ?
9FFFFFFFFFFF9E60 ?
9FFFFFFFFFFF9C54 ?
4000000001BE9620 ?
000000000 ?
opiino()+1840 call opitsk() 000000000 ? 000000000 ?
60000000000B5D60 ?
40000000027FBEB0 ?
00001804D ?
4000000001B03638 ?
opiodr()+2128 call opiino() 00000003C ?
9FFFFFFFFFFFC6B0 ?
9FFFFFFFFFFFEE50 ?
9FFFFFFFFFFFBB70 ?
60000000000B5D60 ?
C000000000001530 ?
opidrv()+1088 call opiodr() 00000003C ? 000000004 ?
4000000001B030D0 ?
0000046B0 ?
9FFFFFFFFFFFC6C0 ?
60000000000B5D60 ?
sou2o()+336 call opidrv() 00000003C ?
9FFFFFFFFFFFEE50 ?
60000000000C26D0 ?
opimai_real()+224 call sou2o() 9FFFFFFFFFFFEE70 ?
00000003C ? 000000004 ?
9FFFFFFFFFFFEE50 ?
main()+368 call opimai_real() 000000000 ?
9FFFFFFFFFFFEEA0 ?
main_opd_entry()+80 call main() 000000002 ?
9FFFFFFFFFFFF360 ?
60000000000B5D60 ?
C000000000000004 ?
--------------------- Binary Stack Dump ---------------------

复制代码

update表结构

SQL> desc SGPM.S_95598_WKST
Name Null? Type
----------------------------------------- -------- ----------------------------
APP_NO NOT NULL VARCHAR2(16 CHAR)
ID NOT NULL NUMBER(16)
GROUP_NO VARCHAR2(32 CHAR)
BUSI_TYPE_CODE VARCHAR2(8 CHAR)
BUSI_SUB_TYPE VARCHAR2(10 CHAR)
COUNTY_CODE VARCHAR2(8 CHAR)
URBAN_RURAL_FLAG VARCHAR2(8 CHAR)
ORG_NO VARCHAR2(16 CHAR)
EMP_NO VARCHAR2(16 CHAR)
HANDLE_TIME DATE
ACCEPT_MODE VARCHAR2(8 CHAR)
ACCEPT_CONTENT VARCHAR2(4000 CHAR)
HANDLE_OPINION VARCHAR2(4000 CHAR)
REPLY_FLAG VARCHAR2(8 CHAR)
REPLY_DATE NUMBER
REPLY_MODE VARCHAR2(8 CHAR)
CONS_OPINION VARCHAR2(4000 CHAR)
REPLY_TEL VARCHAR2(32 CHAR)
SEND_DATE DATE
ATTACH BLOB -----------------正好更新的是这个字段
IDEN_MODE VARCHAR2(8 CHAR)
CERT_TYPE_CODE VARCHAR2(8 CHAR)
CERT_NO VARCHAR2(32 CHAR)
ARC_MODE VARCHAR2(8 CHAR)
INTEGRITY_FLAG VARCHAR2(8 CHAR)
ACCURACY_FLAG VARCHAR2(8 CHAR)
ARC_OPINION VARCHAR2(4000 CHAR)
TIME_LEN NUMBER(15)
ARC_EMP_NAME VARCHAR2(16 CHAR)
ARC_DATE DATE
HANDLE_STATUS_CODE VARCHAR2(256 CHAR)
REPLY_SUCC_FLAG VARCHAR2(8 CHAR)
RETVISIT_FAIL_REASON VARCHAR2(256 CHAR)
REPLY_FAIL_TIMES NUMBER(5)
CUST_NO VARCHAR2(48 CHAR)
CUST_TYPE VARCHAR2(24 CHAR)
REAL_ARRIVE_TIME DATE
CUST_NAME VARCHAR2(768 CHAR)
VISIT_SCORE NUMBER(5)
TG_NO VARCHAR2(16 CHAR)
METER_NO VARCHAR2(32 CHAR)
DISPATCH_LEN NUMBER(15)
TRANSFER_LEN NUMBER(15)
IMPORTANT_CUST_LEVEL VARCHAR2(8 CHAR)
OVER_TIME DATE
CITY_CODE VARCHAR2(8 CHAR)
TARGET_DEPT VARCHAR2(16 CHAR)
APP_REJECT_FLAG VARCHAR2(8 CHAR)
REMARK VARCHAR2(4000 CHAR)
SG_APP_NO VARCHAR2(16 CHAR)

复制代码

xifenfei · 发表于 2014-6-14 09:17:26

查询到相关bug

Bug 5868257 Dump / memory corruption from DMLs
This note gives a brief overview of bug 5868257.
The content was last updated on: 06-DEC-2010
Click here for details of each of the sections below.
This bug is marked as an important issue.
Affects:
Product (Component) Oracle Server (Rdbms)
Range of versions believed to be affected Versions BELOW 11.1
Versions confirmed as being affected
10.2.0.4
9.2.0.8
Platforms affected Generic (all / most platforms affected)
It is believed to be a regression in default behaviour thus:
Regression introduced in 9.2.0.8
Regression introduced in 10.2.0.4
Fixed:
This issue is fixed in
11.1.0.6 (Base Release)
10.2.0.5 (Server Patch Set)
10.2.0.4.1 (Patch Set Update)
10.2.0.4 Patch 5 on Windows Platforms
10.2.0.4 Generic Recommended Patch Bundle #1
Symptoms:
Related To:
Corruption
Process May Dump (ORA-7445) / Abend / Abort
Memory Corruption
Internal Error May Occur (ORA-600)
ORA-1551
ORA-600 [13013]
ORA-600 [kclchkblkdma_3]
ORA-600 [13030]
ORA-600 [kcbchg1_6]
Dump in or under updgrh / skgfgiod / memcpy / memmove / kgidum
Query Rewrite (Including Materialized Views)
dml
Description
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.
- dumps on materialized view refreshes.
- dumps on DMLs in general.
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)

复制代码

已经修复的bug

Ora-00600 With Arguments : [Kgh_heap_sizes:Ds],[Kghgethpsz1], (Doc ID 467955.1) To BottomTo Bottom
Modified:02-Jul-2013Type:PROBLEM
Rate this document Email link to this document Open document in new window Printable Page
In this Document
Symptoms
Changes
Cause
Solution
References
APPLIES TO:
Oracle Database - Enterprise Edition - Version 10.2.0.3 to 10.2.0.3 [Release 10.2]
Information in this document applies to any platform.
***Checked for relevance on 02-Jul-2013***
SYMPTOMS
ORA-00600 [kgh_heap_sizes:ds], [0x11075E458],
ORA-07445 [] [] [] [] [] []
Core dumps in qmuhshput()
No database crash
CHANGES
These errors can be seen when updating/inserting into LOBs on certain 64-bit platforms
CAUSE
The cause of this problem has been identified and verified in unpublished Bug 6148212.
The effect of the bug is heap corruptions due to stale/wrong LOB pointers overwriting the heap structures
SOLUTION
To implement the solution, please execute the following steps:
Upgrade to release 11g or patch set 10.2.0.4 in which the bug is fixed
- OR -
Apply Patch 6148212 if available for your platform and Oracle version
REFERENCES
NOTE:6148212.8 - Bug 6148212 - Dump [qmuhshget_internal] can occur accessing LOBs

复制代码

你可以尝试重建表试试看

		自动登录	找回密码
密码			立即注册

replicat中断同时数据库报ora-600和ora-07445

本帖子中包含更多资源