重庆思庄Oracle、Redhat认证学习论坛
标题: ORA-07445: 出现异常错误: 核心转储 [audplsfailure()+54] [打印本页]
作者: jiawang 时间: 2018-1-3 10:01
标题: ORA-07445: 出现异常错误: 核心转储 [audplsfailure()+54]
ORA-07445: 出现异常错误: 核心转储
数据库版本：Oracle 11.2.0.1.0
数据库服务器操作系统：Red Hat Enterprise Linux Server release 6.4
报错日志：
Tue Dec 12 10:17:09 2017
Exception [type: SIGSEGV, Address not mapped to object] [ADDR:0x428] [PC:0x1ED6224, audplsfailure()+54] [flags: 0x0, count: 1]
Errors in file /u01/app/oracle/diag/rdbms/orcl/orcl1/trace/orcl1_ora_64935.trc (incident=476587):
ORA-07445: 出现异常错误: 核心转储 [audplsfailure()+54] [SIGSEGV] [ADDR:0x428] [PC:0x1ED6224] [Address not mapped to object] []
ORA-00923: 未找到要求的 FROM 关键字
Incident details in: /u01/app/oracle/diag/rdbms/orcl/orcl1/incident/incdir_476587/orcl1_ora_64935_i476587.trc
查看alert警告日志，查找对应的trace文件，发现没有正在运行的Sql语句如下：
*** 2017-12-12 10:17:09.683
dbkedDefDump(): Starting a non-incident diagnostic dump (flags=0x3, level=3, mask=0x0)
----- SQL Statement (None) -----
Current SQL information unavailable - no SQL text.
----- Call Stack Trace -----
calling call entry argument values in hex
location type point (? means dubious value)
-------------------- -------- -------------------- ----------------------------
skdstdst()+41 call kgdsdst() 000000000 ? 000000000 ?
7F604C2D8C40 ? 7F604C2D8D18 ?
7F604C2DD7C0 ? 000000003 ?
ksedst1()+103 call skdstdst() 000000000 ? 000000000 ?
7F604C2D8C40 ? 7F604C2D8D18 ?
7F604C2DD7C0 ? 000000003 ?
ksedst()+39 call ksedst1() 000000001 ? 000000001 ?
7F604C2D8C40 ? 7F604C2D8D18 ?
7F604C2DD7C0 ? 000000003 ?
dbkedDefDump()+2746 call ksedst() 000000001 ? 000000001 ?
7F604C2D8C40 ? 7F604C2D8D18 ?
7F604C2DD7C0 ? 000000003 ?
ksedmp()+41 call dbkedDefDump() 000000003 ? 000000003 ?
7F604C2D8C40 ? 7F604C2D8D18 ?
7F604C2DD7C0 ? 000000003 ?
ssexhd()+2462 call ksedmp() 000000003 ? 000000003 ?
7F604C2D8C40 ? 7F604C2D8D18 ?
7F604C2DD7C0 ? 000000003 ?
__sighandler() call ssexhd() 00000000B ? 7F604C2DEBF0 ?
7F604C2DEAE8 ? 7F604C2D8D18 ?
7F604C2DD7C0 ? 000000003 ?
audplsfailure()+54 signal __sighandler() 7F604C12F410 ? 000000000 ?
0000007D4 ? 000000000 ?
00000039B ? 000000000 ?
audfro()+115 call audplsfailure() 7F604C12F410 ? 000000000 ?
0000007D4 ? 000000000 ?
00000039B ? 000000000 ?
audcvw()+114 call audfro() 7F604C12F410 ? 000000000 ?
000000000 ? 000000000 ?
00000039B ? 000000000 ?
auddft_internal()+1 call audcvw() 7F604C12F410 ? 000000015 ?
049 00000039B ? 000000000 ?
00000039B ? 000000000 ?
auddft()+34 call auddft_internal() 7F604C12F410 ? 000000015 ?
00000039B ? 000000000 ?
001ED8982 ? 000000000 ?
kksQuickParse()+375 call auddft() 7F604C12F410 ? 000000015 ?
0 00000039B ? 000000000 ?
001ED8982 ? 000000000 ?
kksLoadParentOnLock call kksQuickParse() 00C0FCCA0 ? 7FFF85331970 ?
()+572 7FFF85331D30 ? 000000000 ?
001ED8982 ? 000000000 ?
kkslod()+58 call kksLoadParentOnLock 00C0FCCA0 ? 7F604C10F0C8 ?
() 7FFF85332790 ? 000000000 ?
001ED8982 ? 000000000 ?
kglLoadOnLock()+129 call kkslod() 00C0FCCA0 ? 7F604C10F0C8 ?
3 7FFF85332790 ? 000000000 ?
001ED8982 ? 000000000 ?
kgllkac()+259 call kglLoadOnLock() 00C0FCCA0 ? 7FFF85332790 ?
7F604C10F0C8 ? 7F604C10FCA8 ?
001ED8982 ? 000000000 ?
kglLock()+6467 call kgllkac() 00C0FCCA0 ? 7F604C10F0C8 ?
7FFF85332790 ? 7F604C10FCA8 ?
001ED8982 ? 000000000 ?
kglget()+343 call kglLock() 00C0FCCA0 ? 7FFF85332790 ?
000000001 ? 000000002 ?
7FFF85332A58 ? 000000000 ?
kkspsc0()+6157 call kglget() 00C0FCCA0 ? 7FFF85332790 ?
000000001 ? 000000002 ?
7FFF85332A58 ? 000000000 ?
kksParseCursor()+11 call kkspsc0() 7F604C131CF0 ? 7F604C1177C0 ?
6 000000949 ? 000000003 ?
000000006 ? 0000000A4 ?
opiosq0()+2019 call kksParseCursor() 7FFF85333040 ? 7F604C1177C0 ?
000000949 ? 000000003 ?
000000006 ? 0000000A4 ?
kpooprx()+274 call opiosq0() 000000003 ? 00000000E ?
7FFF85333210 ? 0000000A4 ?
000000006 ? 0000000A4 ?
kpoal8()+842 call kpooprx() 7FFF853369F4 ? 7F604C1177C0 ?
000000948 ? 000000001 ?
000000000 ? 0000000A4 ?
opiodr()+917 call kpoal8() 00000005E ? 7F604C1177C0 ?
000000948 ? 000000001 ?
000000000 ? 0000000A4 ?
ttcpip()+2183 call opiodr() 00000005E ? 00000001C ?
7FFF853369F0 ? 000000001 ?
000000000 ? 0000000A4 ?
opitsk()+1710 call ttcpip() 00C11A8F0 ? 0099C50D0 ?
7FFF853369F0 ? 000000000 ?
7FFF85336448 ? 7FFF853369EC ?
opiino()+969 call opitsk() 00C11A8F8 ? 000000000 ?
7FFF853369F0 ? 000000000 ?
7FFF85336448 ? 7FFF853369EC ?
opiodr()+917 call opiino() 00000003C ? 000000004 ?
7FFF853381E8 ? 000000000 ?
7FFF85336448 ? 7FFF853369EC ?
opidrv()+570 call opiodr() 00000003C ? 000000004 ?
7FFF853381E8 ? 000000000 ?
7FFF85336448 ? 7FFF853369EC ?
sou2o()+103 call opidrv() 00000003C ? 000000004 ?
7FFF853381E8 ? 000000000 ?
7FFF85336448 ? 7FFF853369EC ?
opimai_real()+133 call sou2o() 7FFF853381C0 ? 00000003C ?
000000004 ? 7FFF853381E8 ?
7FFF85336448 ? 7FFF853369EC ?
ssthrdmain()+265 call opimai_real() 000000002 ? 7FFF853383B0 ?
000000004 ? 7FFF853381E8 ?
7FFF85336448 ? 7FFF853369EC ?
main()+201 call ssthrdmain() 000000002 ? 7FFF853383B0 ?
000000001 ? 000000000 ?
7FFF85336448 ? 7FFF853369EC ?
__libc_start_main() call main() 000000002 ? 7FFF85338558 ?
+253 000000001 ? 000000000 ?
7FFF85336448 ? 7FFF853369EC ?
_start()+41 call __libc_start_main() 000A29984 ? 000000002 ?
7FFF85338548 ? 000000000 ?
7FFF85336448 ? 7FFF853369EC ?
解决方案：查看MOS和
Bug 24316947相匹配，
禁用
NOT EXISTS auditing这个审计，详情请点击下面链接。
https://support.oracle.com/epmos/faces/SearchDocDisplay?_adf.ctrl-state=chab0mf0a_435&_afrLoop=333343920091473#SYMPTOM
| 欢迎光临 重庆思庄Oracle、Redhat认证学习论坛 (http://bbs.cqsztech.com/) |
Powered by Discuz! X3.2 |