My Oracle Support Banner

ORA-29771: Process GCR0 blocks CKPT for more than 70 seconds (Doc ID 2611169.1)

Last updated on FEBRUARY 28, 2020

Applies to:

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

Symptoms

ORA-29771: process GCR0 (OSID 101490) blocks CKPT (OSID 101475) for more than 70 seconds in ASC3 SC


+++++alert_+<ASMn>.log

2019-11-12T04:27:16.356481-05:00
CKPT (ospid: 101475) waits for event 'latch free' for 76 secs.
CKPT (ospid: 101475) waits for latch 'ASM <> client latch' for 76 secs.
2019-11-12T04:27:20.558818-05:00
Errors in file <ORACLE_BASE>/diag/asm/+asm/+<ASMn>/trace/+<ASMn>_lmhb_101467.trc  (incident=230489):
ORA-29771: process GCR0 (OSID 101490) blocks CKPT (OSID 101475) for more than 70 seconds
Incident details in: <ORACLE_BASE>/diag/asm/+asm/+<ASMn>/incident/incdir_230489/+<ASMn>_lmhb_101467_i230489.trc
2019-11-12T04:27:23.219304-05:00
System state dump requested by (instance=4, osid=4295068763 (LMHB)), summary=[incident=230489 (kjfm_29771)].
System State dumped to trace file <ORACLE_BASE>/diag/asm/+asm/+<ASMn>/trace/+<ASMn>_diag_101458_20191112042723.trc
2019-11-12T04:27:23.245109-05:00
GCR0 (ospid: 101490) is blocking CKPT (ospid: 101475) in a wait
LMHB (ospid: 101467) kills GCR0 (ospid: 101490).
Please check LMHB trace file for more detail.
2019-11-12T04:27:23.246701-05:00
Process termination requested for pid 101490 [source = unknown], [info = 0] [request issued by pid: 101467, uid: 101]
2019-11-12T04:59:32.008925-05:00
NOTE: Flex client id 0x0 [<instance>:<instance1>:clu1] attempting to connect

 


++++alert_+<ASMn>.log

2019-11-12T04:27:23.027742-05:00
System state dump requested by (instance=4, osid=4295068763 (LMHB)), summary=[incident=230489 (kjfm_29771)].
System State dumped to trace file <ORACLE_BASE>/diag/asm/+asm/+<ASMn>/trace/+<ASMn>_diag_244023_20191112042723.trc
2019-11-12T04:27:23.256902-05:00
NOTE: Flex client id 0x0 [<instance>:clu1] attemp


++++alert_+<ASMn>.log

2019-11-12T04:27:23.017378-05:00
System state dump requested by (instance=4, osid=4295068763 (LMHB)), summary=[incident=230489 (kjfm_29771)].
System State dumped to trace file <ORACLE_BASE>/diag/asm/+asm/+<ASMn>/trace/+<ASMn>_diag_86623_20191112042723.trc

 


++++<ASMn>_lmhb_101467_i230489.trc

----- Beginning of Customized Incident Dump(s) -----
Process CKPT (ospid: 101475) is waiting for event 'latch free'.
Process GCR0 (ospid: 101490) is the blocker of the wait chain.
===[ Wait Chain ]===

Changes

 

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
Changes
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.