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

Alert log 상에서 발생한 에러

이 에러는 12.1부터 DB 내부적으로 컨트롤 파일  트랜잭션이 향상되면서 발생할 수 있습니다. 자동으로 다시 시도하기 떄문에 무시해도됩니다.

 

에러메세지

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

 

설명

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.

 

관련 SR.Doc ID 2312580.1