重庆思庄Oracle、KingBase、PostgreSQL、Redhat认证学习论坛

标题: oel7.4 上dbca报错 ORA-27125 解决方法 [打印本页]

作者: 郑全    时间: 2017-8-21 18:44
标题: oel7.4 上dbca报错 ORA-27125 解决方法
环境:oel 7.4 +oracle 10.2.0.1 64bit

dbca创建数据库时,直接报 ORA-27125的错误,以为是共享内存段不够,减小到shm以下,也不行.
错误如下:
ORA-27125: unable to create shared memory segment
Linux-x86_64 Error: 1: Operation not permitted
在某些操作系统上,当启动数据库或者创建数据库时都可能出现ORA-27125错误,我在Oracle Linux 7.4 上安装Oracle 10.2.0.1,创建数据库时就遇到了这个错误。

这个错误的解决就是修改 /proc/sys/vm/hugetlb_shm_group 文件。
解决方法也很简单,首先检查oracle用户的组信息:
[oracle ~]$ id oracle
uid=500(oracle) gid=502(oinstall) groups=502(oinstall),501(dba)
[oracle ~]$ more /proc/sys/vm/hugetlb_shm_group
0
下面用root执行下面的命令,将dba组添加到系统内核中:
# echo 501 > /proc/sys/vm/hugetlb_shm_group
然后重新安装数据库,问题消失。
那么hugetlb_shm_group组是什么呢?以下是解释:
hugetlb_shm_group contains group id that is allowed to create SysV shared memory segment using hugetlb page
这里反复提到了HugePage,以下是关于HugePage的说明和解释:
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.


作者: 郑全    时间: 2017-8-21 20:42
这个还不能高兴太早,修改了这个值:
echo 1001 > /proc/sys/vm/hugetlb_shm_group
下次重启操作系统,你就发现:

more  /proc/sys/vm/hugetlb_shm_group
又为0了,怎么办.
作者: 郑全    时间: 2017-8-22 15:28
这个经过测试,oel7.4上安装11g数据库11.2.0.4,不存在这个问题.
作者: 郑全    时间: 2017-8-27 20:35
在rhel.7.4上安装oracle 10.2.0.1后,每次重起后,
more  /proc/sys/vm/hugetlb_shm_group又变为了 0,解决办法为:

修改/etc/sysctl.conf
增加
vm.hugetlb_shm_group=1001
之后,再次重起,就不会修改回去了.





欢迎光临 重庆思庄Oracle、KingBase、PostgreSQL、Redhat认证学习论坛 (http://bbs.cqsztech.com/) Powered by Discuz! X3.2