无痕

3 积分	0 好友	2 主题

发消息

ORA-07445 [opiosq0()+81] [SIGSEGV]

1^#

发表于 2012-7-5 16:20:19 | 查看: 3675| 回复: 1

product alert log 中出现大量 7445错误记录
ORA-07445: exception encountered: core dump [opiosq0()+81] [SIGSEGV] [Address not mapped to object] [0x00000005A] [] []
Wed Jun 27 16:06:16 CST 2012
Errors in file /oracle/admin/centerdb/udump/centerdb_ora_18982.trc:
ORA-07445: exception encountered: core dump [opiosq0()+81] [SIGSEGV] [Address not mapped to object] [0x00000005A] [] []
Wed Jun 27 16:08:17 CST 2012
Errors in file /oracle/admin/centerdb/udump/centerdb_ora_19969.trc:
ORA-07445: exception encountered: core dump [opiosq0()+81] [SIGSEGV] [Address not mapped to object] [0x00000005A] [] []
Wed Jun 27 16:10:16 CST 2012
Errors in file /oracle/admin/centerdb/udump/centerdb_ora_20831.trc:
ORA-07445: exception encountered: core dump [opiosq0()+81] [SIGSEGV] [Address not mapped to object] [0x00000005A] [] []
Wed Jun 27 16:12:16 CST 2012

看到opiosq0函数，是操作系统抛出的异常，看看下面的 call stack:

Exception signal: 11 (SIGSEGV), code: 1 (Address not mapped to object), addr: 0x5a, PC: [0x3696c79, opiosq0()+81]
*** 2012-06-27 16:08:17.006
ksedmp: internal or fatal error
ORA-07445: exception encountered: core dump [opiosq0()+81] [SIGSEGV] [Address not mapped to object] [0x00000005A] [] []
No current SQL statement being executed.
----- Call Stack Trace -----
calling             call    entry             argument values in hex
location          type    point             (? means dubious value)
-------------------- -------- -------------------- ----------------------------
ksedst()+31       call    ksedst1()          000000000 ? 000000001 ?
                                                2AE96BAE9D50 ? 2AE96BAE9DB0 ?
                                                2AE96BAE9CF0 ? 000000000 ?
ksedmp()+610       call    ksedst()          000000000 ? 000000001 ?
                                                2AE96BAE9D50 ? 2AE96BAE9DB0 ?
                                                2AE96BAE9CF0 ? 000000000 ?
ssexhd()+629       call    ksedmp()          000000003 ? 000000001 ?
                                                2AE96BAE9D50 ? 2AE96BAE9DB0 ?
                                                2AE96BAE9CF0 ? 000000000 ?
__restore_rt()+0    call    ssexhd()          00000000B ? 2AE96BAEAD70 ?
                                                2AE96BAEAC40 ? 2AE96BAE9DB0 ?
                                                2AE96BAE9CF0 ? 000000000 ?
opiosq0()+81       signal __restore_rt()    00000004A ? 000000000 ?
                                                7FFF3802FAD8 ? 0000000A4 ?
                                                000000000 ? 000000000 ?
kpooprx()+318       call    opiosq0()          00000004A ? 00000000E ?
                                                7FFF3802FAD8 ? 0000000A4 ?
                                                000000000 ? 000000000 ?
kpoal8()+783       call    kpooprx()          7FFF38032CBC ? 7FFF38030D00 ?
                                                000000024 ? 000000001 ?
                                                000000000 ? 000000000 ?
opiodr()+1184       call    kpoal8()          00000005E ? 000000017 ?
                                                7FFF38032CB8 ? 000000001 ?
                                                6AF000000000001 ? 000000000 ?
ttcpip()+1226       call    opiodr()          00000005E ? 000000017 ?
                                                7FFF38032CB8 ? 000000000 ?
                                                005BEBDB0 ? 000000000 ?
opitsk()+1310       call    ttcpip()          006AF1FB0 ? 0054A67A0 ?
                                                7FFF38032CB8 ? 000000000 ?
                                                7FFF380327B8 ? 7FFF38032E20 ?
opiino()+1024       call    opitsk()          000000003 ? 000000000 ?
                                                7FFF38032CB8 ? 000000001 ?
                                                000000000 ? B29000200000001 ?
opiodr()+1184       call    opiino()          00000003C ? 000000004 ?
                                                7FFF38033EB8 ? 000000000 ?
                                                000000000 ? B29000200000001 ?
opidrv()+548       call    opiodr()          00000003C ? 000000004 ?
                                                7FFF38033EB8 ? 000000000 ?
                                                005BEB860 ? B29000200000001 ?
sou2o()+114       call    opidrv()          00000003C ? 000000004 ?
                                                7FFF38033EB8 ? 000000000 ?
                                                005BEB860 ? B29000200000001 ?
opimai_real()+163 call    sou2o()             7FFF38033E90 ? 00000003C ?
                                                000000004 ? 7FFF38033EB8 ?
                                                005BEB860 ? B29000200000001 ?
main()+116          call    opimai_real()       000000002 ? 7FFF38033F20 ?
                                                000000004 ? 7FFF38033EB8 ?
                                                005BEB860 ? B29000200000001 ?
__libc_start_main()  call    main()             000000002 ? 7FFF38033F20 ?
+244                                              000000004 ? 7FFF38033EB8 ?
                                                005BEB860 ? B29000200000001 ?
_start()+41       call    __libc_start_main()  00072D128 ? 000000002 ?
                                                7FFF38034078 ? 000000000 ?
                                                005BEB860 ? 000000002 ?

同时在trace最后发现：WARNING:Could not increase the asynch I/O limit to 1152 for SQL direct I/O. It is set to 128

隐约感觉与隐含参数有关。

以上简要信息，想请教及各位的意建与建议。

分享0