环境描述
选项
信息
系统类型
Linux x86 64-bit
系统内核
3.10.0-957.el7.x86_64
数据库版本
19.7.0.0.0
内存
500G
CPUs
128
架构
RAC
问题描述
数据库二节点经常性的自动重启
第一层分析:自动重启的原因
数据库重启,一般都是先看alert日志,有如下显示
2020-07-16T16:59:10.896311+08:00
System state dump requested by (instance=2, osid=124268 (PMON)), summary=[abnormal instance termination]. error - 'Instance is terminating.'
System State dumped to trace file /oracle/diag/rdbms/loandb/loandb2/trace/loandb2_diag_124290.trc
2020-07-16T16:59:10.918179+08:00
PMON (ospid: 124268): terminating the instance due to ORA error 471
2020-07-16T16:59:10.922909+08:00
Cause - 'Instance is being terminated due to fatal process death (pid: 76, ospid: 124440, DBW4)'
2020-07-16T16:59:20.408801+08:00
Termination issued to instance processes. Waiting for the processes to exit, wait time 5 sec
2020-07-16T16:59:20.704260+08:00
ORA-1092 : opitsk aborting process
2020-07-16T16:59:24.413038+08:00
Instance terminated by PMON, pid =