kernel: Out of Memory: Killed process 17402 (oracle) on 9.2.0.8.0 - 64bit
Hello,
After two months testing this server, the instance crash due two out of memory conditions.
The alert say :
Pmon end Instance and
ORA-00471: DBWR process terminated with error
Browsing the log at system level I found that kernel oom-killer kill to DBWR and LGWR process, thus crashing the instance.
I'm running a 5 Gygas SGA on a 8gygas RAM memory and the workload is very low, because this server is on testing phase, also the crash was at 4:00 am, not people work at this time.
The linux kernel is :
Linux albor-produccion.asefa.es 2.6.9-89.0.0.0.1.ELsmp #1 SMP Tue May 19 05:31:20 EDT 2009 x86_64 x86_64 x86_64 GNU/Linux
And the distribution is Oracle Linux
Red Hat Enterprise Linux AS release 4 (Nahant Update 8).
I've search some for this topic but is not clear the action to take to avoid this condition.
Any would help?
Many thanks
Arturo