ETL not completing successfully - error: Too many open files in system.
- Product: Aleph
- Product Version: 20, 21, 22, 23
- Relevant for Installation Type: Dedicated-Direct, Direct, Local, Total Care
Problem Symptoms:
The ETL does not appear to have completed - the batch log shows it as running, but grepping for the process does not show any activity
$data_scratch/p_arc_01_2.log has error:
Oracle error: fetch z69
ORA-01116: error in opening database file 9
ORA-01110: data file 9: '/
/bin/csh: Too many open files in system.
Can't make pipe.
Cause:
Maximum number of open files on server is set to a value less than 65536, e.g.
$ cat /proc/sys/fs/file-max
32767
Resolution:
As System Administrator of the Aleph server, set the maximum number of open files (fs.file-max) to 65536 or higher.
- Article last edited: 26-Jun-2016