Home » Infrastructure » Linux » why ?
why ? [message #98916] Wed, 17 September 2003 00:34 Go to next message
Thanh
Messages: 1
Registered: September 2003
Junior Member
Errors in file bdump/lgwr_2109.trc:
ORA-00313: open failed for members of log group 1 of thread 1
ORA-00312: online log 1 thread 1: 'redo01.log'
ORA-27041: unable to open file
Linux Error: 23: Too many open files in system
Additional information: 2
LGWR: terminating instance due to error 313
Re: why - Too many open files in system [message #98935 is a reply to message #98916] Wed, 05 November 2003 23:21 Go to previous messageGo to next message
Frank Naude
Messages: 4579
Registered: April 1998
Senior Member
Hi,

View your /proc/sys/fs/file-max file to get the current "open files" limit for your system. If you want to set it (e.g. 65536) type:
"echo 65536 >/proc/sys/fs/file-max"

You can also check your High-Water-Mark in the /proc/sys/fs/file-nr file. There are 3 numbers, the first is your high-water-mark, the second are your actually open file and the third is the file-max-entry.

Best regards.

Frank
Re: why - Too many open files in system [message #98991 is a reply to message #98935] Thu, 19 February 2004 08:21 Go to previous message
Robert Mijango
Messages: 1
Registered: February 2004
Junior Member
Hi,
this just happened to me. I increased the fs.file-max from the default 8192 to 10240.
I am running PostgreSQL on an Intel P4 with 3GB of RAM. How can I calculate what would be a good file-max without overallocating resources?
Regards,
Robert Mijango
Previous Topic: Segment fault 1 when running netmgr
Next Topic: Multiple database on Linux
Goto Forum:
  


Current Time: Thu Mar 28 20:32:16 CDT 2024