My Oracle Support Banner

Diagnosing ORA-600 [2103] Issues in a NON RAC environment (Doc ID 406191.1)

Last updated on JANUARY 29, 2022

Applies to:

Oracle Database - Enterprise Edition - Version 8.1.7.0 to 18.1.0.0.0 [Release 8.1.7 to 18]
Oracle Database Cloud Schema Service - Version N/A and later
Oracle Database Exadata Cloud Machine - Version N/A and later
Oracle Cloud Infrastructure - Database Service - Version N/A and later
Oracle Database Backup Service - Version N/A and later
Information in this document applies to any platform.

Purpose

This document explains how to troubleshoot and find out the cause of ORA-600 [2103] in a non RAC environment.

An ORA-600 [2103] is signaled when an Oracle process cannot get a CF(Control File) enqueue for 900 seconds.

The ORA-600 [2103] could be caused by:

  • Very slow I/O subsystem where the Control files are stored.
  • Frequent log switching - redo logs too small or insufficient logs
  • Async I/O issue or multiple db_writers, you can't use both of them, back one out
  • OS / Hardware issues

Note also that AIX 5.2 ML04 was causing frequent ORA-600[2103] and the error was fixed by upgrading the system to AIX 5.2 ML 05.

Troubleshooting Steps

To view full details, sign in with your My Oracle Support account.

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


In this Document
Purpose
Troubleshooting Steps
References

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.