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 188.8.131.52 to 184.108.40.206 [Release 11.1 to 11.2]
Oracle Database - Enterprise Edition - Version 220.127.116.11 to 18.104.22.168 [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 10.1.0.2 to 10.2.0.5 [Release 10.1 to 10.2]
Oracle Database - Enterprise Edition - Version 10.2.0.2 to 10.2.0.4 [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.
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