ORA-27101,ORA-27102 錯誤解決方案

錯誤提示如下

ORA-27101
shared memory realm does not exist

Cause:Unable to locate shared memory realm

Action:Verify that the realm is accessible

ORA-27102
out of memory

Cause:Out of memory

Action:Consult the trace file for details

今天在centos6上發現oracle shutdown&startup都起不來了，之前都好好的，報如下錯：

 

代碼如下	複製代碼
SQL> shutdown immediate ORA-01034: ORACLE not available ORA-27101: shared memory realm does not exist Linux-x86_64 Error: 2: No such file or directory SQL> startup ORA-27102: out of memory Linux-x86_64 Error: 12: Cannot allocate memory Additional information: 1 Additional information: 1736716 Additional information: 8

然後根據這二個ora-去找啊找啊，沒有進展，參數什麼的也沒有變化。

最後突然想起在server上開了一下vncserver這個噁心的傢伙，但木有隨手關了它，top一下，我去，吃了好多的CPU+記憶體，趕緊用root stop它，然後，就正常了。