ORACLE SOS

 找回密码
 立即注册

QQ登录

只需一步,快速开始

搜索
查看: 5811|回复: 0

ORA-07445错误,麻烦飞哥帮忙分析一下

[复制链接]

1

主题

1

帖子

15

积分

新手上路

Rank: 1

积分
15
发表于 2017-1-12 16:21:58 | 显示全部楼层 |阅读模式
Trace file d:\oracle\diag\rdbms\orcl\orcl\trace\orcl_ora_2816.trc
Oracle Database 11g Enterprise Edition Release 11.1.0.7.0 - 64bit Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options
Windows NT Version V6.1 Service Pack 1
CPU                 : 4 - type 8664, 4 Physical Cores
Process Affinity    : 0x0000000000000000
Memory (Avail/Total): Ph:6789M/16383M, Ph+PgF:21758M/32765M
Instance name: orcl
Redo thread mounted by this instance: 1
Oracle process number: 135
Windows thread id: 2816, image: ORACLE.EXE (SHAD)


*** 2017-01-11 19:52:38.904
*** SESSION ID31.147) 2017-01-11 19:52:38.904
*** CLIENT ID) 2017-01-11 19:52:38.904
*** SERVICE NAMEorcl) 2017-01-11 19:52:38.904
*** MODULE NAMEPL/SQL Developer) 2017-01-11 19:52:38.904
*** ACTION NAMESQL Window - select v.code, v.ch) 2017-01-11 19:52:38.904

Exception [type: ACCESS_VIOLATION, UNABLE_TO_READ] [ADDR:0x0] [PC:0x1E684F4, evaopn3()+248]
DDE: Problem Key 'ORA 7445 [evaopn3()+248]' was flood controlled (0x4) (incident: 4681)
ORA-07445: 出现异常错误: 核心转储 [evaopn3()+248] [ACCESS_VIOLATION] [ADDR:0x0] [PC:0x1E684F4] [UNABLE_TO_READ] []
Dump file d:\oracle\diag\rdbms\orcl\orcl\trace\orcl_ora_2816.trc
Wed Jan 11 19:52:38 2017
ORACLE V11.1.0.7.0 - 64bit Production vsnsta=0
vsnsql=15 vsnxtr=3
Dumping diagnostics for abrupt exit from ksedmp

ksedmp exception at address PC:0xF90
ksedmp exception at 0000000000000F90

Dumping initial exception call-stack
------------------- Call Stack Trace ---------------------
Frameptr         RetAddr          Param#1          Param#2          Param#3          Param#4          Function Name
0000000001E684F4 0000000000000000 0000000000000000 0000000000000000 0000000000000000 0000000000000000 evaopn3()+248
0000000003D84D62 0000000001E683FC 00000001D0B27AF0 0000000060E4F3C0 0000000060E4FC90 0000000000000000 qerixGetKey()+4434
0000000003D854ED 0000000003D83C10 0000000000000000 0000000000022030 0000000000000019 000000000000000E qerixStart()+1585
0000000003DAA071 0000000003D84EBC 0000000000020F10 0000000003D73376 0000000100000001 0000000000000000 qertbStart()+1039
0000000003D73376 0000000003DA9C62 000000000001FD98 00000000000000FF 0000000100000001 00000001D0B2C138 qerjoStart()+562
0000000003D73376 0000000003D73144 0000000000000001 00000001D0B281F0 0000000000000001 0000000000000000 qerjoStart()+562
00000000008130F1 0000000003D73144 0000000060D40D80 0000000200000000 0000000200000001 0000000002030003 rwsstd()+305
0000000003D73376 0000000000812FC0 0000000000000000 0000000000000000 0000000000000001 0000000060D40D80 qerjoStart()+562
00000000008130F1 0000000003D73144 0000000004000004 0000000000000000 0000000000000001 0000000005EB534C rwsstd()+305
000000000315154B 0000000000812FC0 000000000001FD98 0000000000000000 0000000000000001 0000000000000000 qerhjStart()+389
00000000008130F1 00000000031513C6 0000000045339EE0 00000002146E44C0 0000000000000001 00000001D0B23EF8 rwsstd()+305
0000000003D73A0F 0000000000812FC0 00000000452D7DF8 0000000000000000 0000000000000001 00000000082DC270 qerjoFetch()+973
0000000003D7EBBE 0000000003D73642 00000000082DC314 0000000060E4FC90 000000000000001D 0000000060E404E8 qersoProcessULS()+208
0000000003D7DE7D 0000000003D7EAEE 00000001D0BBE360 000000000000001D 00000000452F5B90 00000001D0BBE360 qersoFetch()+4477
000000000424C44C 0000000003D7CD00 0000000000000000 000000002546F3C0 0000000007C19986 0000000007804AD4 opifch2()+3630
000000000424B618 000000000424B61E 0000000000000089 0000000000000005 000000005ADDB190 000000005ADDE2F8 opifch()+70
0000000000D02598 000000000424B5D2 0000000000000001 000000000000001C 000000005ADDE2F8 0000000000000000 opiodr()+1324
000000000765C79B 0000000000D0206C 0000000000000005 0000000000000002 000000005ADDE2F8 0000000200000003 ttcpip()+4631
0000000000CFF34F 000000000765B584 0000000025488600 0000000000000000 0000000000000000 0000000000000000 opitsk()+2103
0000000002A673BC 0000000000CFEB18 0000000000000000 0000000000000000 0000000000000000 0000000000000000 opiino()+1140
0000000000D02598 0000000002A66F48 000000000000003C 0000000000000004 000000005ADDFAE0 0000000000000000 opiodr()+1324
000000000047DE60 0000000000D0206C 000000000000003C 0000000000000004 000000005ADDFAE0 0000000000000000 opidrv()+810
000000000047EC28 000000000047DC0B 000000000000003C 000007FE00000004 000000005ADDFAE0 000000005ADDFB60 sou2o()+52
000000000040119B 000000000047EBF4 000000005ADDFB60 0000000000000000 0000000000000000 0000000000000000 opimai_real()+151
0000000000401060 0000000000401104 000000005ADDFB60 000000001A4FE0F0 000000005ADDFC01 000007FE00000034 opimai()+96
0000000000401FAA 0000000000401000 000000001A4FE0F0 0000000005CD5604 0000000000000060 000000000000208C OracleThreadStart()+704
000000007755652D 0000000000401CEA 000000004F50FF1C 0000000000000000 0000000000000000 0000000000000000 000000007755652D
000000007778C521 0000000077556520 0000000000000000 0000000000000000 0000000000000000 0000000000000000 000000007778C521
---------------- End of Call Stack Trace -----------------



trace文件内容如上。
google上查evaopn3()  后,结果不太明确,所以过来求教。
不过看论坛里最新的帖子已是15年的了,不知飞哥还来不来这个论坛。
google oracle的问题很多次了,还是觉得这个论坛里的解答质量最高,之前已经帮我解决了几个问题了,谢谢。

回复

使用道具 举报

您需要登录后才可以回帖 登录 | 立即注册

本版积分规则

QQ|Archiver|手机版|ORACLE SOS 技术论坛

GMT+8, 2024-12-5 02:56 , Processed in 0.032801 second(s), 21 queries .

Powered by Discuz! X3.4

Copyright © 2001-2020, Tencent Cloud.

快速回复 返回顶部 返回列表