开发者社区> zhangshengdong> 正文
阿里云
为了无法计算的价值
打开APP
阿里云APP内打开

ORA-27125: unable to create shared memory segment

简介: OS环境:CentOS release 6.5 (Final) Oracle版本:Oracle Database 10g Enterprise Edition Release 10.2.
+关注继续查看
OS环境:CentOS release 6.5 (Final)
Oracle版本:Oracle Database 10g Enterprise Edition Release 10.2.0.1.0 - 64bit

场景:数据库startup的时候报如下错误

*******************************************************************************
[oracle@localhost ~]$ sqlplus "/as sysdba"
SQL*Plus: Release 10.2.0.1.0 - Production on 星期二 5月 31 09:10:45 2016
Copyright (c) 1982, 2005, Oracle.  All rights reserved.
已连接到空闲例程。
SQL> startup
ORA-27125: unable to create shared memory segment
Linux-x86_64 Error: 1: Operation not permitted
*********************************************************************************
解决方法:
When a process uses some memory, the CPU is marking the RAM as used by that process. For efficiency, the CPU allocate RAM by chunks of 4K bytes (it's the default value on many platforms). Those chunks are named pages. Those pages can be swapped to disk, etc.
Since the process address space are virtual, the CPU and the operating system have to remember which page belong to which process, and where it is stored. Obviously, the more pages you have, the more time it takes to find where the memory is mapped. When a process uses 1GB of memory, that's 262144 entries to look up (1GB / 4K). If one Page Table Entry consume 8bytes, that's 2MB (262144 * 8) to look-up.
Most current CPU architectures support bigger pages (so the CPU/OS have less entries to look-up), those are named Huge pages (on Linux), Super Pages (on BSD) or Large Pages (on Windows), but it all the same thing.

步骤如下:
[oracle@localhost ~]$ id oracle
uid=501(oracle) gid=501(oinstall) groups=501(oinstall),502(dba)
root@localhost ~]# more /proc/sys/vm/hugetlb_shm_group 
0
[root@localhost ~]# echo 502 >/proc/sys/vm/hugetlb_shm_group
[root@localhost ~]# su - oracle
[oracle@localhost ~]$ sqlplus "/as sysdba"
SQL*Plus: Release 10.2.0.1.0 - Production on 星期二 5月 31 09:12:05 2016
Copyright (c) 1982, 2005, Oracle.  All rights reserved.
已连接到空闲例程。
SQL> startup
ORACLE 例程已经启动。
Total System Global Area 5016387584 bytes
Fixed Size                  2027640 bytes
Variable Size            1124077448 bytes
Database Buffers         3875536896 bytes
Redo Buffers               14745600 bytes
数据库装载完毕。
数据库已经打开。

版权声明:本文内容由阿里云实名注册用户自发贡献,版权归原作者所有,阿里云开发者社区不拥有其著作权,亦不承担相应法律责任。具体规则请查看《阿里云开发者社区用户服务协议》和《阿里云开发者社区知识产权保护指引》。如果您发现本社区中有涉嫌抄袭的内容,填写侵权投诉表单进行举报,一经查实,本社区将立刻删除涉嫌侵权内容。

相关文章
cl.exe is unable to create an executable file
cl.exe is unable to create an executable file
66 0
eclipse Unable to build: the file dx.jar was not loaded from the SDK folder的解决办法
eclipse Unable to build: the file dx.jar was not loaded from the SDK folder的解决办法
59 0
SQL Server 游标运用:查看所有数据库所有表大小信息(Sizes of All Tables in All Database)
原文:SQL Server 游标运用:查看所有数据库所有表大小信息(Sizes of All Tables in All Database) 一.本文所涉及的内容(Contents) 本文所涉及的内容(Contents) 背景(Contexts) 实现代码(SQL Codes) 方法一:游...
1315 0
The certificate used to sign "" has either expired or has been revoked.
这句话的意思就是“签名”的证书已过期或已被吊销。 说白了就是有人删除了你的证书,解决的办法就是在创建一个,创建证书有两种办法,。 第一: 在苹果开发者中心,进入自己的账号,请求一个CRS文件,根据这个CRS文件来创建一个证书然后就可以了。
1185 0
5 AI Trends We Can Expect to See in 2017 and Beyond
Artificial Intelligence (AI) continues to make big strides as a changemaker across various industries, unlocking significant opportunities to transf
1917 0
【OH】Creating a Database with the CREATE DATABASE Statement
 来源于online help  http://docs.oracle.com/cd/E11882_01/server.112/e25494/create.htm Home / Database / Oracle Database Online Documentation 11g Release 2 (11.
920 0
ORA-01652: unable to extend temp segment by 8192...
      最近在rebuild index时提示unable to extend temp segment by 8192 in tablespace..的错误提示。
991 0
+关注
zhangshengdong
文为世范,行为士则
182
文章
0
问答
文章排行榜
最热
最新
相关电子书
更多
低代码开发师(初级)实战教程
立即下载
阿里巴巴DevOps 最佳实践手册
立即下载
冬季实战营第三期:MySQL数据库进阶实战
立即下载