My Oracle Support Banner

ASM instance startup hang for infinite time with 'enq: DN - contention' (Doc ID 2663260.1)

Last updated on JULY 20, 2024

Applies to:

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

Symptoms

ASM instance was stuck while starting up with 'enq: DN - contention' after multipath failure at OS level.


and is blocked by
=> Oracle session identified by:
{
instance: 2 (+asm.+asm2)
os id: 30685
process id: 6, oracle@xxxxxx (GEN0)
session id: xxx
session serial #: xxx
}
which is waiting for 'enq: DD - contention' with wait info:
{
p1: 'name|mode'=0x44440006
p2: 'disk group'=0x0
p3: 'type'=0x1
time in wait: 3564 min 43 sec
timeout after: never
wait id: 482130
blocking: 782 sessions
current sql:
short stack: ksedsts()+346<-ksdxfstk()+71<-ksdxcb()+912<-sspuser()+217<-__sighandler()<-semtimedop()+10<-skgpwwait()+200<-ksliwat()+2268<-kslwaitctx()+197<-ksqcmi()+8465<-ksqgtlctx()+4872<-ksqgelctx()+771<-kfgUseDmt()+930<-kfdChangeDiskstring()+625<-kspsetv1()+1990<-ksplfp()+6176<-ksbcti()+247<-ksbabs()+551<-ksbrdp()+1079<-opirip()+609<-opidrv()+602<-sou2o()+145<-opimai_real()+202<-ssthrdmain()+417<-main()+262<-__libc_start_main()+245
wait history:
* time between current wait and wait #1: 0.000057 sec
1. event: 'rdbms ipc message'
time waited: 2.971706 sec
wait id: 482129 p1: 'timeout'=0x12c
* time between wait #1 and #2: 0.000493 sec
2. event: 'rdbms ipc message'
time waited: 2.999372 sec
wait id: 482128 p1: 'timeout'=0x12c
* time between wait #2 and #3: 0.000618 sec
3. event: 'rdbms ipc message'
time waited: 2.939767 sec
wait id: 482127 p1: 'timeout'=0x126
}
and is blocked by
=> Oracle session identified by:
{
instance: x (+asm.+asmx)
os id: 23268
process id: 59, oracle@xxxxxx (TNS V1-V3)
session id: xxx
session serial #: xxx
}
which is waiting for 'enq: DN - contention' with wait info:
{
p1: 'name|mode'=0x444e0004
p2: '0'=0x27
p3: '0'=0x0
time in wait: 2 min 18 sec (last interval)
time in wait: 2387 min 30 sec (total)
timeout after: never
wait id: 938
blocking: 785 sessions
current sql: alter diskgroup FRA5 mount
short stack: ksedsts()+346<-ksdxfstk()+71<-ksdxcb()+912<-sspuser()+217<-__sighandler()
<-semtimedop()+10<-skgpwwait()+200<-ksliwat()+2268<-kslwaitctx()+197<-kjusuc()+9058<-ksipgetctxia()+5359
<-ksqcmi()+27067<-ksqgtlctx()+4872<-ksqgelctx()+771<-kfmNew()+510<-kfgAssignNumber()+178<-kfxdrvMount()+1580
<-kfxdrvEntry()+2283<-opiexe()+27104<-opiosq0()+4766<-kpooprx()+404<-kpoal8()+850<-opiodr()+1229<-ttcpip()+1257
<-opitsk()+1940<-opiino()+941<-opiodr()+1229<-opidrv()+1021<-sou2o()+145<-opimai_real()+455<-ssthrdmain()+417<-main()+262<-
wait history:
* time between current wait and wait #1: 0.000000 sec
1. event: 'ges resource directory to be unfrozen'
time waited: 0.000002 sec
wait id: 950
* time between wait #1 and #2: 0.000000 sec
2. event: 'enq: DN - contention'
time waited: 20 min 50 sec (last interval)
time waited: 2385 min 11 sec (total)
wait id: 938 p1: 'name|mode'=0x444e0004
p2: '0'=0x27
p3: '0'=0x0
* time between wait #2 and #3: 0.000000 sec
3. event: 'ges resource directory to be unfrozen'
time waited: 0.000002 sec
wait id: 949
}

Chain 1 Signature: 'enq: DN - contention'<='enq: DD - contention'<='reliable message'<='enq: PE - contention'
Chain 1 Signature Hash: 0xf78d2639
-------------------------------------------------------------------------------

File_name:: diag/asm/+asm/+ASMx/trace/+ASMx_ora_8772.trc  in diag/asm/+asm/+ASMx/incident/incdir_290/+ASMx_ora_877

 

After addressing above hang ,few diskgroup mount was failing with ORA-600 [kssdel : bad live] while mounting on few instances.

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.