Home >Database >Mysql Tutorial >ORA-27101,ORA-27102 错误解决方法_MySQL

ORA-27101,ORA-27102 错误解决方法_MySQL

WBOY
WBOYOriginal
2016-05-27 14:29:441012browse

bitsCN.com

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它,然后,就正常了

bitsCN.com
Statement:
The content of this article is voluntarily contributed by netizens, and the copyright belongs to the original author. This site does not assume corresponding legal responsibility. If you find any content suspected of plagiarism or infringement, please contact admin@php.cn
Previous article:MySQL常用命令_MySQLNext article:MySQL体系结构_MySQL