请教ORA-07445的问题,希望各位大神能指点一下!

qq_42556338 2021-02-09 12:21:12
Oracle 11.2.0.4.0 版本,在运行时,经常会出现ORA-07445的问题,上网找了好久都没找到解决方案,希望各位大神都指点一下。
一、Log文件中的错误日志:
Sun Feb 07 13:36:37 2021
ERROR: Unable to normalize symbol name for the following short stack (at offset 213):
dbgexProcessError()+200<-dbgeExecuteForError()+65<-dbgePostErrorKGE()+2269<-dbkePostKGE_kgsf()+77<-kgeade()+562<-kgerelv()+151<-kgerev()+45<-kgerec5()+60<-sss_xcpt_EvalFilterEx()+1862<-sss_xcpt_EvalFilter()+174<-.1.4_5+59<-00007FF8B2FE1E26<-00007FF8B2FF349D<-00007FF8B2FB48D7<-00007FF8B2FF262A<-lmmhpfree()+94<-lmmcit()+44<-lpmpfin()+334<-lpmterm()+117<-lpminitm()+641<-opiinit()+181<-opimai_real()+245<-opimai()+191<-BackgroundThreadStart()+646<-00007FF8B0A713D2<-00007FF8B2F754F4
Errors in file D:\APP\ADMINISTRATOR\diag\rdbms\zsyltck\zsyltck\trace\zsyltck_j001_1732.trc (incident=12206):
ORA-07445: exception encountered: core dump [lmmhpfree()+94] [ACCESS_VIOLATION] [ADDR:0x8] [PC:0x33F5F4E] [UNABLE_TO_READ] []
Incident details in: D:\APP\ADMINISTRATOR\diag\rdbms\zsyltck\zsyltck\incident\incdir_12206\zsyltck_j001_1732_i12206.trc
Use ADRCI or Support Workbench to package the incident.
See Note 411.1 at My Oracle Support for error and packaging details.
Sun Feb 07 13:36:37 2021
Errors in file D:\APP\ADMINISTRATOR\diag\rdbms\zsyltck\zsyltck\trace\zsyltck_j000_5856.trc (incident=11214):
ORA-04030: 在尝试分配 133800 字节 (koh-kghu sessi,static frame of inst) 时进程内存不足
Incident details in: D:\APP\ADMINISTRATOR\diag\rdbms\zsyltck\zsyltck\incident\incdir_11214\zsyltck_j000_5856_i11214.trc
Use ADRCI or Support Workbench to package the incident.
See Note 411.1 at My Oracle Support for error and packaging details.
二、trc文件中的内容
Dump file D:\APP\ADMINISTRATOR\diag\rdbms\zsyltck\zsyltck\incident\incdir_12206\zsyltck_j001_1732_i12206.trc
Oracle Database 11g Enterprise Edition Release 11.2.0.4.0 - 64bit Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options
Windows NT Version V6.2
CPU : 16 - type 8664, 16 Physical Cores
Process Affinity : 0x0x0000000000000000
Memory (Avail/Total): Ph:27278M/32767M, Ph+PgF:5M/43007M
VM name : VMWare Version (6)
Instance name: zsyltck
Redo thread mounted by this instance: 0 <none>
Oracle process number: 0
Windows thread id: 1732, image: ORACLE.EXE (J001)


*** 2021-02-07 13:36:37.438
Dump continued from file: D:\APP\ADMINISTRATOR\diag\rdbms\zsyltck\zsyltck\trace\zsyltck_j001_1732.trc
ORA-07445: exception encountered: core dump [lmmhpfree()+94] [ACCESS_VIOLATION] [ADDR:0x8] [PC:0x33F5F4E] [UNABLE_TO_READ] []

========= Dump for incident 12206 (ORA 7445 [lmmhpfree()+94]) ========
----- Beginning of Customized Incident Dump(s) -----
Exception [type: ACCESS_VIOLATION, UNABLE_TO_READ] [ADDR:0x8] [PC:0x33F5F4E, lmmhpfree()+94]

Oracle Database 11g Enterprise Edition Release 11.2.0.4.0 - 64bit Production
Process Id: 0x00001b9c Thread Id : 0x000006c4 Time : Sun Feb 07 13:36:37
Excp. Code: 0xc0000005 Excp. Type: ACCESS_VIO Flags: 0x00000000

------------------- Registers ----------------------------
ip=00000000033F5F4E sp=00000000271FF3E0 rp=0000000004D4BC30
r1=0000000000000000 r2=0000000004D45960 r3=0000000004D4BC28
r4=0000000004D45960 r5=00000000271FF3E0 r6=0000000004D4BC30 r7=0000000004D44F88
r8=0000000004D4BC28 r9=0000000000000000 r10=00000000271FF440 r11=0000000004D4BC28
r12=0000000004D45A10 r13=000000000480D3B0 r14=0000000004D45960 r15=0000000000000000
------------------- End of Registers ---------------------


*** 2021-02-07 13:36:37.438
dbkedDefDump(): Starting a non-incident diagnostic dump (flags=0x3, level=3, mask=0x0)
----- SQL Statement (None) -----
Current SQL information unavailable - no SGA.

----- Call Stack Trace -----
...全文
201 点赞 收藏 4
写回复
4 条回复
切换为时间正序
请发表友善的回复…
发表回复
检查sga,shared_pool设置的大小
回复
从这日志看起来,就像是13:30前后这段时间,有job运行,最终使得库的内存不够。
回复
数据库的sga设置的多大?
回复
enthrone 03-24
Oracle 这种内部错误还是去Oracle官网寻求文档或去asktom.oracle.com 看帖发帖
回复
相关推荐
发帖
Oracle 高级技术
创建于2007-09-28

3414

社区成员

Oracle 高级技术相关讨论专区
申请成为版主
帖子事件
创建了帖子
2021-02-09 12:21
社区公告
暂无公告