system completely freezes and becomes unresponsive
459919Oct 13 2005 — edited Nov 28 2005Hi,
We have a single processor, 1 GB RAM Redhat system (desktop). Normally with the database(oracle 10.1g) and client connections running, the memory utilization of this server is around 90-99% . However every few days the box completely freezes and becomes unresponsive (users cannot login, client connections fail). We have to hardboot the box and restart the database. When in stuck state, the log files are not updated, except that sendmail logs heavy load average. ( Messages like "Load Avg 12: 1 Times(s) Load Avg 13: 1 Times(s) Load Avg 14: 1 Times" and so on) and the free memory falls to 8 mb or less but with above 2 gb swap space available.
My question is if there is no free memory, system should thrash (excessive swapping) and become slow, but instead our box completely freezes, though the interactive response ( for any connection which is still active) and ping response is ok, they aren't slow.
Is there any kernel level parameter that can be tuned so the server won't freeze, (tries to move the memory pages to swap space or any other way). When the server is stuck (freezes ) any ssh connections still active will stay on, but new connections fail. One time, using that session, I tried to free up memory by killing processes like X Server etc, but still the server didn't unfreeze.
Server info:
Red Hat Enterprise Linux AS release 3 (Taroon Update 4)
Kernel (uname -r) 2.4.21-27.EL
Intel Pentium 4 CPU 2.80GHz (Single processor)
1 GB RAM
Oracle db version - 10.1.0.3.0
Lastly, I don't think this is any hw problem, because we see similiar problem on multiple system with similiar configs.
Please guide how to resolve the problem. Thanks.