1、内存使用情况, 2、swap使用情况 3、windows下第三方工具
1、手动，查session找出处理时间最长的事务，然后看看具体是什么事务。根据事务执行的sql定位问题；2、执行ADDM并查看报告，根据报告分析处理挂起的原因。这个很多原因，跟是不是RAC关系不大。
LGWR: terminating instance due to error 472 --> Need help DB is up - why this happened Db had blocking session - I issue a alter system set events 'immediate trace name systemstate level 266'; and the db just crashed. Now I need to make an explanation of this and I don't know wh...
PMON (ospid: 248987): terminating the instance due to error 484 Wed Feb 15 08:53:54 2023 System state dump requested by (instance=1, osid=248987 (PMON)), summary=[abnormal instance termination]. System State dumped to trace file /opt/oracle/oracle/diag/rdbms/xxxx/xxxxx/trace/xxxxx_diag_...
Instance terminated by PMON, pid = 43224 经过查询发现是swap不足导致实例宕机，当时swap只有4g 解决...
数据库日志报错“PMON (ospid: 5987): terminating the instance due to error 471” 实例异常终止。 数据库日志: Archived Log entry 14380 added for thread 1 sequence 9960 ID 0x6d1a9509 dest 1: ALTER SYSTEM ARCHIVE LOG Thread 1 advanced to log sequence 9962 (LGWR switch) ...
kjzdattdlm: Can not attach to DLM (LMON up=[TRUE], DB mounted=[FALSE]). 节点1的ASM告警日志: LMON (ospid: 14339) detects hung instances during IMR reconfiguration LMON (ospid: 14339) tries to kill the instance 2 in 37 seconds.
Oracle Database - Enterprise Edition - Version 11.2.0.4 and later: Terminating The Instance Due To Error 471
23点出现 PMON (ospid: 2853): terminating the instance due to error 471 导致数据库停止 日志截图 alter log日志 Wed Mar 08 23:36:02 2017 System state dump requested by (instance=1, osid=2853 (PMON)), summary=[abnormal instance termination]. ...
kjzdattdlm: Can not attach to DLM (LMON up=[TRUE], DB mounted=[FALSE]). 节点1的ASM告警日志: LMON (ospid: 14339) detects hung instances during IMR reconfiguration LMON (ospid: 14339) tries to kill the instance 2 in 37 seconds.