记一次节点一夯住内存消尽

主机夯住无法连接由于已被重启主机现象已经捕捉不到只能查看alert日志 *** 2014-03-12 06:36:48.756 Process startup failed, error stack: ORA-27300: OS system dependent operation:fork failed with status: 12 ORA-27301: OS failure message: Not enough space ORA-27302: failure occurred at: skgpspawn3 处理思路 1.先查看swap空间是否足够 RAM                              SWAP 1GB to 2GB                   1.5 times RAM > 2GB and <= 8GB          1 times RAM > 8GB                            .75 times RAM In 11.2, it is: RAM                              SWAP 1GB to 2GB                   1.5 times RAM > 2GB and <= 16GB        1 times RAM > 16GB                          16GB RAM 2.查看 oracle 用户的 "ulimit -a " 3.Troubleshooting ORA-27300 ORA-27301 ORA-27302 errors (文档 ID 579365.1) Fri Feb 28 09:42:22 2014 Errors in file /oracle/admin/hzgsj/bdump/~~~1_arc1_160632.trc: ORA-00313: open failed for members of log group 2 of thread 1 ORA-00312: online log 2 thread 1: '+~~~~~/onlinelog/group_2.291.697983879' ORA-17503: ksfdopn:2 Failed to open file ~·····/onlinelog/group_2.291.697983879 ORA-12549: TNS perating system resource quota exceeded 处理思路 也是由于交换空间耗尽引起的 System (Unix or Linux) was running out of swap therefore the next error was reported: The ORA-12549: TNS perating system resource quota exceeded error was raised due to the OS was running out of swap space. ASM  ORA-12549: TNS:Operating System Resource Quota Exceeded (文档 ID 738855.1) If RAM = 1024MB to 2048Mb   then 1.5 times RAM   elseif RAM > 2048MB and < 8192MB   then match RAM   else RAM > 8192MB   then .75 times RAM