Is there an issue with "Ulimit -Hn" being set too low (at 1024) when (Oracle recommend 65536)? This is for Oracle 64-bit 11g on Linux 5.
It is one of the settings that appears to be woefully short of its recommendation. But I am also aware that the database server in question is an Oracle Data Guard Local Standby and should only really have a connection or two from its Primary database server (to ship the redo logs across).
The Local Standby database server has 'hung' about 3 times in as many months and then requires a reboot. I do not have access to this server, so rely on others to look at logs etc. The sanity check on kernel params uncovered the low value for "ulimit -Hn".
Has anyone ever seen that 'low' value cause a hang or crash?
Best Answer
Linux 5 does not exists. You are using linux 2 or linux 3. Or maybe are you talking about rhel5?
Back to problem : Never seen any kernel crash due to ulimit -Hn output being too low. Merely some softwares won't work correctly or even won't start. IMHO you should raise it but it's not likely to be the root cause of your problem.
Most relational database engines (at least oracle mysql and postgresql) open a lot of files.