5 Ekim 2018 Cuma

Oracle Mysterious Reboot Problem


Environment
  • Oracle RAC 11.2.0.4
  • Oracle Enterprise Linux 6.9    
Symptoms
  • Server reboots every day at same hour

When we check server alert log, we saw that server gives too many open files error before rebooting. However oracle parameters are set via oracle-11g-preinstall script.

I investigated problem to see what leds to this with <# lsof -n> command. I saw that there were plenty of open files in directory /dev/shm used by oracle processes. 

According to  oracle documentation granules size was 16MB and chucks with 16 MB caused too many open files.

After changing system from AMM (Automatic Memory Management) to ASMM (Automatic Shared Memory Management, problem was resolved. Server stopped to reboot every day.

Hiç yorum yok:

Yorum Gönder