Too many open files ORA-01116: error in opening database file
(Doc ID 3071187.1)
Last updated on FEBRUARY 12, 2025
Applies to:
Oracle Database - Enterprise Edition - Version 19.18.0.0.0 and laterInformation in this document applies to any platform.
Symptoms
Running Oracle Solaris 11.4.49.126.2. Application that is using an Oracle 19.18.0 database (LOKE), on an LDOM. Application crashed - "Too many open files" error (ORA-01116: error in opening database file).
Number of open files is very high and increasing, for some oracle “ora_j00X_loke-processes” (job queue slave processes).
The process ora_j004_loke (PID: 20829) has 40720 files in /proc/20829/fd and after 5 hours.
The database was restarted 2024-12-03, so the process ora_j004_loke started around that time, but under /proc/20829/fd/ most of the files are dated Aug 27 2018!?
Application might crash again once reach the max limit of open files.
Truss showing /app/oracle/product/19.18.0/xdk/mesg/lpxus.msb opened too many times!
# ps -ef | grep ora_j004_loke | grep -v grep
oracle 20829 26572 0 Dec 04 ? 85:51 ora_j004_loke
# pfiles 20829 | grep '^ [0-9]' | wc -l
90
# ls -l /proc/20829/fd | wc -l
46892
Cause
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
| Symptoms |
| Cause |
| Solution |
| References |