最后公司数据库出现问题，老是莫明关闭，最近出现第三次了。

求助各位老大帮助看看分析一下，哪里有问题！

相关的报警日志如下：

（这次关闭应该是在 15：17，我手动启动服务是15：22，日志中加了一些空行和+++分隔符）

Wed Apr 19 15:13:35 2023
Thread 1 advanced to log sequence 141167 (LGWR switch)
Current log# 2 seq# 141167 mem# 0: D:\EAS\EAS\REDO02.LOG
+++++++++++++++++++++++++
Wed Apr 19 15:17:18 2023

Errors in file D:\ORACLE\diag\rdbms\eas\eas\trace\eas_ora_3276.trc (incident=181315):
ORA-04030: 鍦ㄥ皾璇曞垎閰?217888 瀛楄妭 (kkoutlCreatePh,apppred : kkotbalp) 鏃惰繘绋嬪唴瀛樹笉瓒?
Incident details in: D:\ORACLE\diag\rdbms\eas\eas\incident\incdir_181315\eas_ora_3276_i181315.trc
Use ADRCI or Support Workbench to package the incident.
See Note 411.1 at My Oracle Support for error and packaging details.

Errors in file D:\ORACLE\diag\rdbms\eas\eas\trace\eas_ora_3276.trc (incident=181316):
ORA-04030: 鍦ㄥ皾璇曞垎閰?824504 瀛楄妭 (pga heap,kco buffer) 鏃惰繘绋嬪唴瀛樹笉瓒?
ORA-04030: 鍦ㄥ皾璇曞垎閰?217888 瀛楄妭 (kkoutlCreatePh,apppred : kkotbalp) 鏃惰繘绋嬪唴瀛樹笉瓒?
Incident details in: D:\ORACLE\diag\rdbms\eas\eas\incident\incdir_181316\eas_ora_3276_i181316.trc
Use ADRCI or Support Workbench to package the incident.
See Note 411.1 at My Oracle Support for error and packaging details.

Wed Apr 19 15:17:23 2023
Errors in file D:\ORACLE\diag\rdbms\eas\eas\trace\eas_ora_9412.trc (incident=184901):
ORA-04030: 鍦ㄥ皾璇曞垎閰?1049112 瀛楄妭 (pga heap,kllcqgf:kllsltba) 鏃惰繘绋嬪唴瀛樹笉瓒?
Incident details in: D:\ORACLE\diag\rdbms\eas\eas\incident\incdir_184901\eas_ora_9412_i184901.trc

Use ADRCI or Support Workbench to package the incident.
See Note 411.1 at My Oracle Support for error and packaging details.
+++++++++++++++++++++++++
Wed Apr 19 15:17:23 2023
Dumping diagnostic data in directory=[cdmp_20230419151723], requested by (instance=1, osid=3276), summary=[incident=181316].
Errors in file FFF-FFF D:\ORACLE\diag\rdbms\eas\eas\incident\incdir_181315\eas_ora_3276_i181315.trc:

ORA-04030: 鍦ㄥ皾璇曞垎閰?824504 瀛楄妭 (pga heap,kco buffer) 鏃惰繘绋嬪唴瀛樹笉瓒?
ORA-04030: 鍦ㄥ皾璇曞垎閰?217888 瀛楄妭 (kkoutlCreatePh,apppred : kkotbalp) 鏃惰繘绋嬪唴瀛樹笉瓒?
Errors in file D:\ORACLE\diag\rdbms\eas\eas\trace\eas_ora_3276.trc (incident=181317):

ORA-04030: 鍦ㄥ皾璇曞垎閰?824504 瀛楄妭 (pga heap,kco buffer) 鏃惰繘绋嬪唴瀛樹笉瓒?
ORA-04030: 鍦ㄥ皾璇曞垎閰?217888 瀛楄妭 (kkoutlCreatePh,apppred : kkotbalp) 鏃惰繘绋嬪唴瀛樹笉瓒?
Incident details in: D:\ORACLE\diag\rdbms\eas\eas\incident\incdir_181317\eas_ora_3276_i181317.trc

Use ADRCI or Support Workbench to package the incident.
See Note 411.1 at My Oracle Support for error and packaging details.
+++++++++++++++++++++++++
Wed Apr 19 15:17:24 2023
Exception [type: ACCESS_VIOLATION, UNABLE_TO_READ] [ADDR:0x18] [PC:0x3691B9E, clsdcxini()+126]
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<-00007FFCF62018A6<-00007FFCF6212F2D<-00007FFCF61D4547<-00007FFCF62120BA<-clsdcxini()+126<-clsdinitx()+104<-clsdinit()+39<-ksdnfy()+600<-kscnfy()+1091<-opirip()+723<-opidrv()+906<-sou2o()+98<-opimai_real()+280<-opimai()+191<-BackgroundThreadStart()+646<-00007FFCF3F913F2<-00007FFCF61954F4
Errors in file D:\ORACLE\diag\rdbms\eas\eas\trace\eas_m000_5860.trc (incident=184945):

ORA-07445: exception encountered: core dump [clsdcxini()+126] [ACCESS_VIOLATION] [ADDR:0x18] [PC:0x3691B9E] [UNABLE_TO_READ] []
Incident details in: D:\ORACLE\diag\rdbms\eas\eas\incident\incdir_184945\eas_m000_5860_i184945.trc
Use ADRCI or Support Workbench to package the incident.
See Note 411.1 at My Oracle Support for error and packaging details.
+++++++++++++++++++++++++
Wed Apr 19 15:22:19 2023
Adjusting the default value of parameter parallel_max_servers
from 1280 to 470 due to the value of parameter processes (500)
Starting ORACLE instance (normal)

eas_m000_5860.trc

Trace file D:\ORACLE\diag\rdbms\eas\eas\trace\eas_m000_5860.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 : 32 - type 8664, 32 Physical Cores
Process Affinity : 0x0x0000000000000000
Memory (Avail/Total): Ph:22336M/49151M, Ph+PgF:4M/196607M
VM name : VMWare Version (6)
Instance name: eas
Redo thread mounted by this instance: 1
Oracle process number: 0
Windows thread id: 5860, image: ORACLE.EXE (M000)


*** 2023-04-19 15:17:24.009
Exception [type: ACCESS_VIOLATION, UNABLE_TO_READ] [ADDR:0x18] [PC:0x3691B9E, clsdcxini()+126]
DDE: Flood control is not active
Incident 184945 created, dump file: D:\ORACLE\diag\rdbms\eas\eas\incident\incdir_184945\eas_m000_5860_i184945.trc
ORA-07445: exception encountered: core dump [clsdcxini()+126] [ACCESS_VIOLATION] [ADDR:0x18] [PC:0x3691B9E] [UNABLE_TO_READ] []

eas_m000_5860_i184945.trc

Dump file D:\ORACLE\diag\rdbms\eas\eas\incident\incdir_184945\eas_m000_5860_i184945.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 : 32 - type 8664, 32 Physical Cores
Process Affinity : 0x0x0000000000000000
Memory (Avail/Total): Ph:22332M/49151M, Ph+PgF:4M/196607M
VM name : VMWare Version (6)
Instance name: eas
Redo thread mounted by this instance: 1
Oracle process number: 0
Windows thread id: 5860, image: ORACLE.EXE (M000)


*** 2023-04-19 15:17:24.165
Dump continued from file: D:\ORACLE\diag\rdbms\eas\eas\trace\eas_m000_5860.trc
ORA-07445: exception encountered: core dump [clsdcxini()+126] [ACCESS_VIOLATION] [ADDR:0x18] [PC:0x3691B9E] [UNABLE_TO_READ] []

========= Dump for incident 184945 (ORA 7445 [clsdcxini()+126]) ========
----- Beginning of Customized Incident Dump(s) -----
Exception [type: ACCESS_VIOLATION, UNABLE_TO_READ] [ADDR:0x18] [PC:0x3691B9E, clsdcxini()+126]

Oracle Database 11g Enterprise Edition Release 11.2.0.4.0 - 64bit Production
Process Id: 0x000021f8 Thread Id : 0x000016e4 Time : Wed Apr 19 15:17:24
Excp. Code: 0xc0000005 Excp. Type: ACCESS_VIO Flags: 0x00000000

------------------- Registers ----------------------------
ip=0000000003691B9E sp=0000000038E6E430 rp=0000000038E6EA88
r1=0000000000000000 r2=000000000000B018 r3=00000000276BF688
r4=00000000038D0200 r5=0000000038E6E430 r6=0000000038E6EA88 r7=000000000B31AA70
r8=0000000000000000 r9=00000000000000B8 r10=0000000000008000 r11=0000000000000000
r12=0000000000000000 r13=0000000038E6E8F8 r14=000000014025CEC4 r15=0000000038E6E9E0
------------------- End of Registers ---------------------


*** 2023-04-19 15:17:24.181
dbkedDefDump(): Starting a non-incident diagnostic dump (flags=0x3, level=3, mask=0x0)
----- SQL Statement (None) -----
Current SQL information unavailable - no session.

*** 2023-04-19 15:17:24.181
dbkedDefDump(): Starting a non-incident diagnostic dump (flags=0x3, level=2, mask=0x4)
----- SQL Statement (None) -----
Current SQL information unavailable - no session.

eas_ora_3276.trc

Trace file D:\ORACLE\diag\rdbms\eas\eas\trace\eas_ora_3276.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 : 32 - type 8664, 32 Physical Cores
Process Affinity : 0x0x0000000000000000
Memory (Avail/Total): Ph:22719M/49151M, Ph+PgF:409M/196607M
VM name : VMWare Version (6)
Instance name: eas
Redo thread mounted by this instance: 1
Oracle process number: 53
Windows thread id: 3276, image: ORACLE.EXE (SHAD)


*** 2023-04-19 09:31:30.821
*** SESSION ID:(526.9) 2023-04-19 09:31:30.821
*** CLIENT ID:() 2023-04-19 09:31:30.821
*** SERVICE NAME:(EAS) 2023-04-19 09:31:30.821
*** MODULE NAME:(JDBC Thin Client) 2023-04-19 09:31:30.821
*** ACTION NAME:() 2023-04-19 09:31:30.821

kdccak: retry_cnt_fuk > KDC_FUK_RET
EnumerateLoadedModules64 failed with error 0

*** 2023-04-19 11:27:22.562
DDE: Problem Key 'ORA 4030' was flood controlled (0x6) (incident: 181314)
ORA-04030: 在尝试分配 13920 字节 (QERHJ hash-joi,rworalo : rwordops) 时进程内存不足
Incident 181315 created, dump file: D:\ORACLE\diag\rdbms\eas\eas\incident\incdir_181315\eas_ora_3276_i181315.trc

*** 2023-04-19 15:17:18.853
ORA-04030: 在尝试分配 217888 字节 (kkoutlCreatePh,apppred : kkotbalp) 时进程内存不足

Incident 181316 created, dump file: D:\ORACLE\diag\rdbms\eas\eas\incident\incdir_181316\eas_ora_3276_i181316.trc
ORA-04030: 在尝试分配 824504 字节 (pga heap,kco buffer) 时进程内存不足
ORA-04030: 在尝试分配 217888 字节 (kkoutlCreatePh,apppred : kkotbalp) 时进程内存不足

Incident 181317 created, dump file: D:\ORACLE\diag\rdbms\eas\eas\incident\incdir_181317\eas_ora_3276_i181317.trc
ORA-04030: 在尝试分配 824504 字节 (pga heap,kco buffer) 时进程内存不足
ORA-04030: 在尝试分配 217888 字节 (kkoutlCreatePh,apppred : kkotbalp) 时进程内存不足

服务器是windows server 2012 r2

64位

内存：48G

SQL> show parameter sga;
NAME                                 TYPE        VALUE
------------------------------------ ----------- ------------------------------
lock_sga                             boolean     FALSE
pre_page_sga                         boolean     FALSE
sga_max_size                         big integer 32G
sga_target                           big integer 18G

SQL> show parameter pga;
NAME                                 TYPE        VALUE
------------------------------------ ----------- ------------------------------
pga_aggregate_target                 big integer 6G