My Oracle Support Banner

Database instance crash with ORA-29770 while RSnn was waiting with 'cell ram cache population' (Doc ID 2794421.1)

Last updated on FEBRUARY 14, 2022

Applies to:

Oracle Exadata Storage Server Software - Version and later
Information in this document applies to any platform.


  Database instance crashed with ORA-29770.


RS00 (ospid: 121787_121948) waits for event 'cell ram cache population' for 0 secs.
Errors in file /u01/app/oracle/diag/rdbms/xxxxxxxc/xxxxxxx1/trace/xxxxxxx1_lmhb_121854.trc (incident=25161) (PDBNAME=CDB$ROOT):
ORA-29770: global enqueue process RS00 (OSID 121787_121948) is hung for more than 70 seconds
Incident details in: /u01/app/oracle/diag/rdbms/xxxxxxxc/xxxxxxx1/incident/incdir_25161/xxxxxxx1_lmhb_121854_i25161.trc
LOCK_DBGRP: GCR_SYSTEST debug event locked group GR+DB_xxxxxxxC by memno 0
Process termination requested for pid 121787_121790 [source = rdbms], [info = 0] [request issued by pid: 121854, uid: 25265]

File_name:: alert_xxxxxxx1.log

========= Dump for incident 29996 (ORA 29770) ========
----- Beginning of Customized Incident Dump(s) -----
=== RS00 (ospid: 385055_385080) Heartbeat Report
RS00 (ospid: 385055_385080) has no heartbeats for 91 sec. (threshold 70)
: heartbeat state 0x1.ffff (inwait) pso-flag 0x100
: waiting for event 'cell ram cache population' for 0 secs with wait_id 66123755.
===[ Wait Chain ]===
Wait chain is empty.
Process moved according to collected snapshots
Dumping PROCESS RS00 (ospid: 385055_385080) States
===[ System Load State ]===
CPU Total 2 Raw 2 Core 48 Socket 2
Load normal: Cur 609 Highmark 122880 (2.37 480.00)
===[ Latch State ]===
Not in Latch Get
===[ Session State Object ]===

[3 samples, 05:02:30 - 05:02:32]
idle wait at each sample
[1 sample, 05:02:29]
waited for 'cell ram cache population', seq_num: 47288
p1: 'cellhash#'=0x5fee1d57
p2: ''=0x0
p3: ''=0x0
time_waited: >= 0 sec (still in wait)
[38 samples, 05:01:53 - 05:02:28]
idle wait at each sample
Sampled Session History Summary:
longest_non_idle_wait: 'cell ram cache population'
[1 sample, 05:02:45 ]
time_waited: 0.000002 sec (sample interval: 0 sec)

File_name:: xxxxxxx1_lmhb_385066_i29996.trc

As per cellhash value ,we looked at cell level.
nothing observed as on cell level.



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

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