LMON terminating the instance due to error 227

(Doc ID 2316855.1)

Last updated on OCTOBER 17, 2017

Applies to:

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

Symptoms

The alert log shows an error of a corrupt control file  and it also shows that "This is not a real data corruption", but the instance goes down.

1. Database alertlog

Wed Sep 13 23:03:47 2017
Archived Log entry 384073 added for thread 1 sequence 71151 ID 0xe19cb074 dest 1:
Wed Sep 13 23:05:12 2017
Hex dump of (file 0, block 5) in trace file /u01/app/oracle/diag/rdbms/rac_cos/rac1/trace/rac1_lmon_135751.trc
Corrupt block relative dba: 0x00000005 (file 0, block 5)
Bad check value found during control file block read
Data in bad block:
type: 21 format: 2 rdba: 0x00000005
last change scn: 0x0000.00000000 seq: 0x1 flg: 0x04
spare1: 0x0 spare2: 0x0 spare3: 0x0
consistency value in tail: 0x00001501
check value in block header: 0x38c
computed block checksum: 0xc
Control file block read for fixed table access has failed due to concurrent controlfile updates.
This is not a real data corruption. Please retry the query.
Errors in file /u01/app/oracle/diag/rdbms/rac_cos/rac1/trace/rac1_lmon_135751.trc:
ORA-00202: control file: '+DATA01/racdy/controlfile/current.rac1' : control file: '+DATA01/racdy/controlfile/current.rac1'
Errors in file /u01/app/oracle/diag/rdbms/rac_cos/rac1/trace/rac1_lmon_135751.trc (incident=48089):
ORA-00227: corrupt block detected in control file: (block 5, # blocks 1) : corrupt block detected in control file: (block 5, # blocks 1)
ORA-00202: control file: '+DATA01/racdy/controlfile/current.rac1' : control file: '+DATA01/racdy/controlfile/current.rac1'
Incident details in: /u01/app/oracle/diag/rdbms/rac_cos/rac1/incident/incdir_48089/rac1_lmon_135751_i48089.trc
Wed Sep 13 23:05:13 2017
Dumping diagnostic data in directory=[cdmp_20170913230513], requested by (instance=1, osid=135751 (LMON)), summary=[incident=48089].
Errors in file /u01/app/oracle/diag/rdbms/rac_cos/rac1/trace/rac1_lmon_135751.trc:
ORA-00227: corrupt block detected in control file: (block 5, # blocks 1) : corrupt block detected in control file: (block 5, # blocks 1)
ORA-00202: control file: '+DATA01/racdy/controlfile/current.rac1' : control file: '+DATA01/racdy/controlfile/current.rac1'
LMON (ospid: 135751): terminating the instance due to error 227                                                                                        <<<<<<
Wed Sep 13 23:05:13 2017
opiodr aborting process unknown ospid (235702) as a result of ORA-1092
Wed Sep 13 23:05:13 2017

 2. Lmon call stack

kgesev()+280 call dbkePostKGE_kgsf() 00C0F0A40 ? 7F6633EF76E0 ?
0000000E3 ? 000000001 ?
000000000 ? 000000002 ?
ksesec2()+170 call kgesev() 00C0F0A40 ? 7F6633EF76E0 ?
0000000E3 ? 000000002 ?
7FFF539F2A80 ? 000000002 ?
kcccsi()+177 call ksesec2() 00C0F0A40 ? 000000000 ?
000000005 ? 000000000 ?
000000001 ? 000000001 ?
kccrbp()+1910 call kcccsi() 0000000E3 ? 000000000 ?
000000005 ? 000000001 ?
000000001 ? 000000001 ?
kccgrd()+202 call kccrbp() EE00675B0 ? 000000005 ?
7F66337C1E00 ? 000004000 ?
000000005 ? 000000001 ?
kjxgrf_getcp()+672 call kccgrd() 000000000 ? 000000005 ?
0000001E4 ? 7FFF539F2FF0 ?
7F66337C1E00 ? 000000001 ?
kjxgrf_hb_read()+79 call kjxgrf_getcp() 7F6634693000 ? 000000003 ?
000000002 ? 7FFF539F2FF0 ?
7F66337C1E00 ? 000000001 ?
kjxgrDD_hb_read()+1 call kjxgrf_hb_read() 7F6634693000 ? 7FFF539F3270 ?
31 000000003 ? 000000002 ?
7F66337C1E00 ? 000000001 ?
kjxgrnbrisalive()+4 call kjxgrDD_hb_read() 7F66346933B8 ? 7FFF539F3270 ?
34 000000003 ? 000000002 ?
7F66337C1E00 ? 000000001 ?
kjxgrnbrchk()+64 call kjxgrnbrisalive() 7F66346931C8 ? 7FFF539F3270 ?
000000003 ? 000000002 ?
7F66337C1E00 ? 000000001 ?
kjxggpoll()+344 call kjxgrnbrchk() 7F66346931C8 ? 7FFF539F3270 ?
000000003 ? 000000002 ?
7F66337C1E00 ? 000000001 ?
kjfmact()+286 call kjxggpoll() 7F6634694180 ? 000000000 ?
000000003 ? 000000002 ?
7F66337C1E00 ? 000000001 ?
kjfdact()+183 call kjfmact() 7F6634694180 ? F595B4B98 ?
000000000 ? 000000002 ?
7F66337C1E00 ? 000000001 ?
kjfcln()+4341 call kjfdact() 7F6634694180 ? F595B4B98 ?
000000000 ? 000000002 ?

 

Changes

 None

Cause

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms