My Oracle Support Banner

Flex: ORA-00240: Control File Enqueue Held for More Than 120 Seconds (Doc ID 2434297.1)

Last updated on MARCH 12, 2021

Applies to:

Oracle Database - Enterprise Edition - Version 12.2.0.1 to 12.2.0.1 [Release 12.2]
Information in this document applies to any platform.

Symptoms

Database instance terminated due to error 15082 after ORA-00240.

alert_<instance_name>.log from <oracle base>/diag/rdbms/<db name>/<instance name>/trace location:

Errors in file /u01/app/oracle/diag/rdbms/<dbname>/<instance_name>/trace/<instance_name>_dbw0_14251.trc (incident=96243):
ORA-00240: control file enqueue held for more than 120 seconds
Incident details in: /u01/app/oracle/diag/rdbms/<dbname>/<instance_name>/incident/incdir_96243/<instance_name>_dbw0_14251_i96243.trc
2018-06-04T17:57:04.755773+08:00
NOTE: ASMB0 registering with ASM instance as Flex client 0x10005 (reg:1758032404) (reconnect)
2018-06-04T17:57:19.831035+08:00
ERROR: terminating instance because ASMB is stuck for 243 seconds
GEN0 (ospid: 14201): terminating the instance due to error 15082
2018-06-04T17:57:20.508506+08:00
System state dump requested by (instance=2, osid=14201 (GEN0)), summary=[abnormal instance termination].
System State dumped to trace file /u01/app/oracle/diag/rdbms/<dbname>/<instance_name>/trace/<instance_name>_diag_14211_20180604175720.trc
2018-06-04T17:57:20.814567+08:00
Dumping diagnostic data in directory=[cdmp_20180604175719], requested by (instance=2, osid=14201 (GEN0)), summary=[abnormal instance termination].
2018-06-04T17:57:22.055798+08:00
Instance terminated by GEN0, pid = 14201
2018-06-04T17:58:28.166995+08:00
Starting ORACLE instance (normal) (OS id: 20482)
Corresponding incident trace has following incident context dump.

/u01/app/oracle/diag/rdbms/<dbname>/<instance_name>/incident/incdir_96243/<instance_name>_dbw0_14251_i96243.trc: 

---- Incident Context Dump -----
Address: 0x7fffb6861368
Incident ID: 96243
Problem Key: ORA 240
Error: ORA-240 [120] [] [] [] [] [] [] [] [] [] [] []
[00]: dbgeEndDDEInvocationImpl [diag_dde]
[01]: kcc_tac_callback []<-- Signaling
[02]: ksu_dispatch_tac [ksu]
[03]: ksvcheckwait [ksv_trace]
[04]: ksvsend [ksv_trace]
[05]: kfncSlaveSendReal [KFNC]
[06]: kfncSlaveSubmitSlv2 [KFNC]
[07]: kfncSlaveSubmitSlv [KFNC]
[08]: kfncFileIdentify [KFNC]
[09]: kfioIdentify [KFIO]
[10]: ksfdafOpen [file]
[11]: ksfdopn1 [file]
[12]: ksfdopn [file]
[13]: kcfbid []
[14]: kcfida []
[15]: ksbabs [background_proc]
[16]: ksbrdp [background_proc]
[17]: opirip [OPI]
[18]: opidrv [OPI]
[19]: sou2o []
[20]: opimai_real [OPI]
[21]: ssthrdmain []
[22]: main []
[23]: __libc_start_main []
MD [00]: 'SID'='765.9330' (0x2)
MD [01]: 'ProcId'='30.1' (0x2)
MD [02]: 'Client ProcId'='oracle@host1 (TNS V1-V3).14251_140296676552512' (0x0)
Impact 0:
Impact 1:
Impact 2:
Impact 3:
Derived Impact:
----- END Incident Context Dump -
  

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
 Community Discussions
References


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