ORA-00235: control file read without a lock inconsistent due to concurrent update

某系统有如下报错：

Errors in file /u01/app/oracle/diag/rdbms/hsxtdb/hsxtdb2/trace/hsxtdb2_tt04_20904.trc:
ORA-00235: control file read without a lock inconsistent due to concurrent update
复制

trace如下：

			...
*** 2021-05-05T05:07:19.066101+08:00 (CDB$ROOT(1))
krsw_end_stream: Ending open KRSB streams
krsw_end_stream: Ending open KRSB streams
krsw_end_stream: Ending open KRSB streams
krsw_end_stream: Ending open KRSB streams
krsw_end_stream: Ending open KRSB streams
krsw_end_stream: Ending open KRSB streams
krsw_end_stream: Ending open KRSB streams
krsw_end_stream: Ending open KRSB streams
krsw_end_stream: Ending open KRSB streams
krsw_end_stream: Ending open KRSB streams
krsw_end_stream: Ending open KRSB streams
krsw_end_stream: Ending open KRSB streams
krsw_end_stream: Ending open KRSB streams
krsw_end_stream: Ending open KRSB streams
krsw_end_stream: Ending open KRSB streams
krsa_icftxn_exc: Error ORA-235 occurred during an un-locked control file

*** 2021-05-05T08:52:18.382611+08:00 (CDB$ROOT(1))
krsa_icftxn_exc: transaction.  This error can be ignored.  The control
krsa_icftxn_exc: file transaction will be retried.
krsw_end_stream: Ending open KRSB streams
krsw_end_stream: Ending open KRSB streams
krsw_end_stream: Ending open KRSB streams
			...
复制

匹配MOS：

Error ORA-235 Occurred During An Un-locked Control File Transaction (Doc ID 2312580.1)
复制

SOLUTION

Starting from Oracle 12c, controlfile transactions are enhanced. We are no longer request a controlfile enqueue before scanning a particular controlfile section. 

This is done to minimize locking issues and improve performance and scalability. Due to this change, the process reading a controlfile section may sometimes encounter ORA-235 

if the same section is being modified by another process. When this occurs, the reading process will simply re-read the section again. You can safely ignore this message, it's not an issue.



The errors cannot be suppressed at database level by setting any event or initialization parameter. The reason is that although the errors are harmless, they do give an idea of the concurrency on 

the controlfile and can help debug issues relating to slow controlfile i/o etc so, this enhancement has been added specifically by development. It's best to modify any monitoring scripts to ignore/exclude this error. 

Since this is working as designed and these are simply informational, the messages can simply be ignored.
复制

按照ORACLE的说法，这个ora错误是由于12c及以上版本数据库对控制文件的读取做了改进，不在需要像oracle11g或者以下版本一样在扫描特定的控制文件之前先请求一个控制文件队列（这样做是为了更好的性能和可用性，减小锁的影响），但是这样也可能出现在读取控制文件时，刚好其他进程在修改控制文件，则会出现此报错，但是此报错可以忽略，因为这个进程会再次读取控制文件。

可以看出，如果偶然出现这个报错，是可以忽略的，但是如果一直大面积出现，还是要注意是否有进程一直在修改控制文件引起其他进程无法正常读取导致这个报错。