检查alert警告日志时,发现报错ORA-07445: exception encountered: core dump [qertbStart()+327] [SIGSEGV]
客户环境是:oracle 10.2.0.4,redhat 6.1
trace文件内容如下:
ksedmp: internal or fatal error
ORA-07445: exception encountered: core dump [qertbStart()+327] [SIGSEGV] [unknown code] [0x000000000] [] []
Current SQL statement for this session:
SELECT B.WORK_ORDER,START_PROCESS_ID,END_PROCESS_ID, WO_STATUS,TARGET_QTY,OUTPUT_QTY,IN_PDLINE_TIME,OUT_PDLINE_TIME FROM XXXX.G_WO_BASE A,XXXX.G_SN_STATUS B WHERE B.SERIAL_NUMBER = :B1 AND A.WORK_ORDER = B.WORK_ORDER AND ROWNUM = 1
----- PL/SQL Call Stack -----
object line object
handle number name
0x1fd42cc68 9 procedure jzh.SJ_WO_OUTPUT_QTY
0x1fce7db50 27 procedure jzh.SJ_GO
0x1fc3deac0 2 anonymous block
----- Call Stack Trace -----
calling call entry argument values in hex
location type point (? means dubious value)
-------------------- -------- -------------------- ----------------------------
ksedst()+31 call ksedst1() 000000000 ? 000000001 ?
2A9706ED50 ? 2A9706EDB0 ?
2A9706ECF0 ? 000000000 ?
ksedmp()+610 call ksedst() 000000000 ? 000000001 ?
2A9706ED50 ? 2A9706EDB0 ?
2A9706ECF0 ? 000000000 ?
ssexhd()+629 call ksedmp() 000000003 ? 000000001 ?
2A9706ED50 ? 2A9706EDB0 ?
2A9706ECF0 ? 000000000 ?
__funlockfile()+64 call ssexhd() 00000000B ? 2A9706FD70 ?
2A9706FC40 ? 2A9706EDB0 ?
2A9706ECF0 ? 000000000 ?
qertbStart()+327 signal __funlockfile() 107EE5DA0 ? 107EE65F0 ?-------报错的地方
检查metalink,发现一篇文章Ora-07445 [Qertbstart+01b0] (文档 ID 1301870.1) ,解释如下:
SYMPTOMS
The following errors appears when executing a statement with bind variables:
ORA-07445 [qertbStart+01b0] and ORA-12899
CAUSE
This is related to Bug 5868257, NULL variable is used for bind variable
SOLUTION
Apply patch 5868257 or install last bundle patchset 10.2.0.4.x
Issue 5868257 is fixed since patchset 10.2.0.4.
原因是由于在使用绑定变量时使用了NULL值导致了该错误,解决方法是打5868257补丁,当然在使用绑定变量避免使用NULL也可解决该错误!
客户环境是:oracle 10.2.0.4,redhat 6.1
trace文件内容如下:
ksedmp: internal or fatal error
ORA-07445: exception encountered: core dump [qertbStart()+327] [SIGSEGV] [unknown code] [0x000000000] [] []
Current SQL statement for this session:
SELECT B.WORK_ORDER,START_PROCESS_ID,END_PROCESS_ID, WO_STATUS,TARGET_QTY,OUTPUT_QTY,IN_PDLINE_TIME,OUT_PDLINE_TIME FROM XXXX.G_WO_BASE A,XXXX.G_SN_STATUS B WHERE B.SERIAL_NUMBER = :B1 AND A.WORK_ORDER = B.WORK_ORDER AND ROWNUM = 1
----- PL/SQL Call Stack -----
object line object
handle number name
0x1fd42cc68 9 procedure jzh.SJ_WO_OUTPUT_QTY
0x1fce7db50 27 procedure jzh.SJ_GO
0x1fc3deac0 2 anonymous block
----- Call Stack Trace -----
calling call entry argument values in hex
location type point (? means dubious value)
-------------------- -------- -------------------- ----------------------------
ksedst()+31 call ksedst1() 000000000 ? 000000001 ?
2A9706ED50 ? 2A9706EDB0 ?
2A9706ECF0 ? 000000000 ?
ksedmp()+610 call ksedst() 000000000 ? 000000001 ?
2A9706ED50 ? 2A9706EDB0 ?
2A9706ECF0 ? 000000000 ?
ssexhd()+629 call ksedmp() 000000003 ? 000000001 ?
2A9706ED50 ? 2A9706EDB0 ?
2A9706ECF0 ? 000000000 ?
__funlockfile()+64 call ssexhd() 00000000B ? 2A9706FD70 ?
2A9706FC40 ? 2A9706EDB0 ?
2A9706ECF0 ? 000000000 ?
qertbStart()+327 signal __funlockfile() 107EE5DA0 ? 107EE65F0 ?-------报错的地方
检查metalink,发现一篇文章Ora-07445 [Qertbstart+01b0] (文档 ID 1301870.1) ,解释如下:
SYMPTOMS
The following errors appears when executing a statement with bind variables:
ORA-07445 [qertbStart+01b0] and ORA-12899
CAUSE
This is related to Bug 5868257, NULL variable is used for bind variable
SOLUTION
Apply patch 5868257 or install last bundle patchset 10.2.0.4.x
Issue 5868257 is fixed since patchset 10.2.0.4.
原因是由于在使用绑定变量时使用了NULL值导致了该错误,解决方法是打5868257补丁,当然在使用绑定变量避免使用NULL也可解决该错误!
来自 “ ITPUB博客 ” ,链接:http://blog.itpub.net/10271187/viewspace-1387639/,如需转载,请注明出处,否则将追究法律责任。
转载于:http://blog.itpub.net/10271187/viewspace-1387639/