My Oracle Support Banner

Troubleshooting ORA-01116: Error In Opening... Error 24 Too Many Open Files (Doc ID 866092.1)

Last updated on FEBRUARY 20, 2019

Applies to:

Oracle Database - Enterprise Edition - Version to [Release 11.1 to 11.2]
Oracle Database - Enterprise Edition - Version to [Release 9.0.1 to 9.2]
Oracle E-Business Intelligence - Version 11.5.9 to 12.1.1 [Release 11.5 to 12.1]
Oracle Database - Enterprise Edition - Version to [Release 10.1 to 10.2]
Oracle Database - Enterprise Edition - Version to [Release 10.2]
Information in this document applies to any platform.


The Error 24 is often seen when submitting a Concurrent Request such as a Daily Business Intelligence (DBI) initial or incremental load, however it can occur at any time when performing a variety of operations.  In this note we will assume that the problem is reproducible at will use the submission of the DBI Request Set as an example.

There are only two known causes of this problem.  The purpose of this note is to provide a clear set of instructions to determine what the cause of the problem is in order to take appropriate action.

It is an Operating System (OS) error which Oracle encounters and reports back to the application/user.

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
Troubleshooting Steps

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