ORA-29771: Process GCR0 blocks CKPT for more than 70 seconds
(Doc ID 2611169.1)
Last updated on JULY 20, 2024
Applies to:
Oracle Database - Enterprise Edition - Version 18.5.0.0.0 and laterInformation 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 |