主机夯住无法连接由于已被重启主机现象已经捕捉不到只能查看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