• 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