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 -----
轉載請註明出處，本文鏈接：https://www.uj5u.com/shujuku/258224.html
標籤：高級技術
上一篇：普歌-澤辰團隊：簡易上手操作資料庫，創建&查詢&修改&洗掉&使用
下一篇：請教oracle 查詢陳述句寫法