告警日志如下:
Thread 1 advanced to log sequence 4799 (LGWR switch)
Current log# 1 seq# 4799 mem# 0: +DATA/ora11g/onlinelog/group_1.267.1108719261
Current log# 1 seq# 4799 mem# 1: +OCR/ora11g/onlinelog/group_1.257.1108719261
Tue Mar 05 03:05:27 2024
Archived Log entry 12305 added for thread 1 sequence 4798 ID 0xc83a952 dest 1:
Tue Mar 05 15:58:06 2024
Process m001 died, see its trace file
Tue Mar 05 16:42:05 2024
Process PZ99 died, see its trace file
Process PZ99 died, see its trace file
Process PZ99 died, see its trace file
Process PZ99 died, see its trace file
Tue Mar 05 16:42:51 2024
Process m001 died, see its trace file
Tue Mar 05 16:46:57 2024
Process PZ99 died, see its trace file
Process PZ99 died, see its trace file
Tue Mar 05 16:47:54 2024
Process W000 died, see its trace file
Process W000 died, see its trace file
Process W000 died, see its trace file
Tue Mar 05 16:48:06 2024
Process W000 died, see its trace file
Process W000 died, see its trace file
Process W000 died, see its trace file
执行SHUTDOWN 报错如下
SQL> shutdown immediate
ORA-01034: ORACLE not available
ORA-27102: out of memory
Linux-x86_64 Error: 12: Cannot allocate memory
Additional information: 1
Additional information: 3
Additional information: 8