ORA-00240: control file enqueue held for more than 120 seconds ORA-00445: background process "m000"


問題の概要
ORA-00240: control file enqueue held for more than 120 seconds ORA-00445: background process "m000"did not start after 120 seconds
処理者
xxx
システム名
xxxレポート
システムバージョン
 
プロセスアドレス
xxx
データベースのバージョン
11.2.0.2
データベースモード
RAC
データベースpatch
 
発生時間
Mon Jan 01 17:43:42 2018
問題の説明
1月1日AlertログエラーORA-00240:control file enqueue held for more than 120 seconds ORA-00445:background process"m 000"did not start after 120 seconds
エラーメッセージ
Mon Jan 01 17:43:42 2018 Errors in file/oracle/db/diag/rdbms/ireport/ireport2/trace/ireport2_arc0_3605352.trc (incident=141358): ORA-00240: control file enqueue held for more than 120 seconds Incident details in:/oracle/db/diag/rdbms/ireport/ireport2/incident/incdir_141358/ireport2_arc0_3605352_i141358.trc Mon Jan 01 17:43:45 2018 Dumping diagnostic data in directory=[cdmp_20180101174345], requested by (instance=2, osid=3605352 (ARC0)), summary=[incident=141358]. Mon Jan 01 17:44:35 2018 Errors in file/oracle/db/diag/rdbms/ireport/ireport2/trace/ireport2_mmon_3015758.trc (incident=141022): ORA-00445: background process "m000"did not start after 120 seconds Incident details in:/oracle/db/diag/rdbms/ireport/ireport2/incident/incdir_141022/ireport2_mmon_3015758_i141022.trc
trace_3605352_i141358.log 
Description 
-------------- 

*** 2018-01-01 17:43:42.717 
*** SESSION ID:(828.1) 2018-01-01 17:43:42.717 
*** CLIENT ID:() 2018-01-01 17:43:42.717 
*** SERVICE NAME:(SYS$BACKGROUND) 2018-01-01 17:43:42.717 
*** MODULE NAME:() 2018-01-01 17:43:42.717 
*** ACTION NAME:() 2018-01-01 17:43:42.717 

Dump continued from file: /oracle/db/diag/rdbms/ireport/ireport2/trace/ireport2_arc0_3605352.trc 
ORA-00240: control file enqueue held for more than 120 seconds 

========= Dump for incident 141358 (ORA 240) ======== 
----- Beginning of Customized Incident Dump(s) ----- 
------------------------------------------------------------------------------- 
CONTROL FILE ENQUEUE HELD FOR TOO LONG 

holding mode : S 
enqueue holder : 'inst 2, osid 3605352' <<<<<<
enqueue held time : 120 seconds 

The current process 'inst 2, osid 3605352' holds the control file enqueue 
for more than 120 seconds. 


---------------------------------------- 
SO: 0x7000010d16b6538, type: 4, owner: 0x7000010c13ccbe8, flag: INIT/-/-/0x00 if: 0x3 c: 0x3 
proc=0x7000010c13ccbe8, name=session, file=ksu.h LINE:12459 ID:, pg=0 
(session) sid: 828 ser: 1 trans: 0x0, creator: 0x7000010c13ccbe8 
flags: (0x51) USR/- flags_idl: (0x1) BSY/-/-/-/-/- 
flags2: (0x408) -/- 
DID: , short-term DID: 
txn branch: 0x0 
oct: 0, prv: 0, sql: 0x0, psql: 0x0, user: 0/SYS 
ksuxds FALSE at location: 0 
service name: SYS$BACKGROUND 
Current Wait Stack: 
1: waiting for 'KSV master wait' <<<<<<<<
=0x0, =0x0, =0x0 
wait_id=13855013 seq_num=11861 snap_id=2 
wait times: snap=2.493364 sec, exc=2 min 5 sec, total=2 min 5 sec <<<<
wait times: max=infinite, heur=2 min 5 sec 
wait counts: calls=41 os=41 
in_wait=1 iflags=0x5520 
0: waiting for 'Disk file operations I/O' 
FileOperation=0x2, fileno=0x0, filetype=0x3 
wait_id=13855012 seq_num=11858 snap_id=1 
wait times: snap=0.000000 sec, exc=0.000227 sec, total=2 min 5 sec 
wait times: max=infinite, heur=2 min 5 sec 
wait counts: calls=0 os=0 
in_wait=1 iflags=0x15a0 
There are 59 sessions blocked by this session. 
Dumping one waiter: 
inst: 1, sid: 2715, ser: 1 
wait event: 'enq: CF - contention' 
p1: 'name|mode'=0x43460005 
p2: '0'=0x0 
p3: 'operation'=0x0 
row_wait_obj#: 4294967295, block#: 0, row#: 0, file# 0 
min_blocked_time: 104 secs, waiter_cache_ver: 38592 
Wait State: 

----- Abridged Call Stack Trace ----- 
ksedsts()+644

この問題は、主にasmの例では、エンドプロセスがasm操作を遅々として完了することができず、arcプロセスに長時間のhang住状態が発生し、さらに長時間保持する制御ファイルのロックが発生するため、240エラーが報告されたためである.patch 12830339を打って、問題が二度と現れないかどうかを観察することをお勧めします.この問題は現在workaroundが回避できるものではない、asmインスタンス側の操作のため、asmが何らかの操作を実行する可能性がある場合、ビジネスピーク時に類似するASM操作を制限することはこの問題を回避できるはずである.
ソリューションApply patch 12830339 Bug 12973375 is dup on 12830339