My Oracle Support Banner

Database Instance Crashed with ORA-29770 with RMV stuck on 'SECOND SPARE WAIT EVENT' (Doc ID 2657973.1)

Last updated on JULY 30, 2020

Applies to:

Oracle Database - Enterprise Edition - Version 12.2.0.1 and later
Information in this document applies to any platform.

Symptoms

Database Instance Crashed due to Error ORA-29770

2020-02-09T14:16:59.361620-05:00
Errors in file /u01/app/oracle/diag/rdbms/xxxxxxxx7/xxxx2/trace/xxxx2_lmhb_72396.trc (incident=1760774):
ORA-29770: global enqueue process RMV1 (OSID 72463) is hung for more than 70 seconds
Incident details in: /u01/app/oracle/diag/rdbms/xxxxxxxx7/xxxx2/incident/incdir_1760774/xxxx2_lmhb_72396_i1760774.trc
2020-02-09T14:17:01.883672-05:00
LOCK_DBGRP: GCR_SYSTEST debug event locked group GR+DB_xxxxxxxx7 by memno 0
ERROR: Some process(s) is not making progress.
LMHB (ospid: 72396) is terminating the instance.

 

RMV process stuck with below stack,

Short stack dump:
ksedsts()+346<-ksdxfstk()+71<-ksdxcb()+912<-sspuser()+217<-__sighandler()<-__poll()+24<-sskgxp_selectex()+306
<-skgxpiwait()+1588<-skgxpwaiti()+402<-skgxpwait()+176<-ossnet_wait_all()+279<-ossnet_wait()+339<-oss_wait_ext()+327
<-oss_wait()+108<-kcfis_reap_ioctl()+3732<-kcfis_push()+6983<-kcfis_read()+9323<-kcbflc_op()+964<-kcbflc_ramcache_pop()+403
<-kclrcflush()+507<-kclpbi()+1526<-kjmrmslmain()+4888<-ksvrdp_int()+2010<-ksvrdp_cbk()+13<-ksbdispatch()+152
<-opirip()+530<-opidrv()+602<-sou2o()+145<-opimai_real()+202<-ssthrdmain()+417<-main()+262<-__libc_start_main()+253

 

Cause

To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!


In this Document
Symptoms
Cause
Solution
References


My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.