Diagnosing ORA-600  Issues in a NON RAC environment
(Doc ID 406191.1)
Last updated on NOVEMBER 28, 2023
Applies to:Oracle Database - Enterprise Edition - Version 18.104.22.168 to 22.214.171.124.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.
This document explains how to troubleshoot and find out the cause of ORA-600  in a non RAC environment.
An ORA-600  is signaled when an Oracle process cannot get a CF(Control File) enqueue for 900 seconds.
The ORA-600  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 and the error was fixed by upgrading the system to AIX 5.2 ML 05.
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