1,12.2 RAC 节点1上有三个cdb:cdb1、edb1、bdb1;
出现问题的是bdb1上的docare实例
2,应用反应故障发生在2-19 16:50
3,alert日志:
2020-02-19T16:16:43.165982+08:00
DBRM (ospid: 46991502) waits for event ‘latch: shared pool’ for 85 secs.
DBRM (ospid: 46991502) waits for latch ‘shared pool’ for 85 secs.
2020-02-19T16:16:45.404947+08:00
Errors in file /u01/app/oracle/diag/rdbms/bdb/bdb1/trace/bdb1_lmhb_44435210.trc (incident=1802279) (PDBNAME=CDB$ROOT):
ORA-29771: process USER (OSID 42927534) blocks DBRM (OSID 46991502) for more than 70 seconds
Incident details in: /u01/app/oracle/diag/rdbms/bdb/bdb1/incident/incdir_1802279/bdb1_lmhb_44435210_i1802279.trc
2020-02-19T16:16:46.885270+08:00
USER (ospid: 42927534) is blocking DBRM (ospid: 46991502) in a wait
LMHB (ospid: 44435210) kills USER (ospid: 42927534).
Please check LMHB trace file for more detail.
2020-02-19T16:16:46.897757+08:00
WARNING: inbound connection timed out (ORA-3136)
墨值悬赏

评论
