重庆思庄Oracle、Redhat认证学习论坛

 找回密码
 注册

QQ登录

只需一步,快速开始

搜索
查看: 1465|回复: 0
打印 上一主题 下一主题

[Oracle] Error ORA-235 Occurred During An Un-locked Control File Transaction

[复制链接]
跳转到指定楼层
楼主
发表于 2022-8-3 14:02:03 | 只看该作者 回帖奖励 |倒序浏览 |阅读模式
日常查看数据库警告日志的时候发现报错Error ORA-235 Occurred During An Un-locked Control File Transaction,我就去mos中查找文档,然后根据文档了解原因及解决办法。

对应文档:Error ORA-235 Occurred During An Un-locked Control File Transaction (Doc ID 2312580.1)


SYMPTOMS

Below error is seen in 12.1.0.2 database alert log:


---

Tue Sep 26 08:01:33 2017

Error ORA-235 occurred during an un-locked control file transaction. This

error can be ignored. The control file transaction will be retried.

---


CAUSE

Expected behavior


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或者以下版本一样在扫描特定的控制文件之前先请求一个控制文件队列(这样做是为了更好的性能和可用性,减小锁的影响),但是这样也可能出现在读取控制文件时,刚好其他进程在修改控制文件,则会出现此报错,但是此报错可以忽略,因为这个进程会再次读取控制文件。


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


分享到:  QQ好友和群QQ好友和群 QQ空间QQ空间 腾讯微博腾讯微博 腾讯朋友腾讯朋友
收藏收藏 支持支持 反对反对
回复

使用道具 举报

您需要登录后才可以回帖 登录 | 注册

本版积分规则

QQ|手机版|小黑屋|重庆思庄Oracle、Redhat认证学习论坛 ( 渝ICP备12004239号-4 )

GMT+8, 2024-11-29 13:03 , Processed in 0.093412 second(s), 21 queries .

重庆思庄学习中心论坛-重庆思庄科技有限公司论坛

© 2001-2020

快速回复 返回顶部 返回列表