linux服务器上启动oracle报错:
SQL>startup;
ORA-27125:unable to create shared memory segment
Linux-x86_64 Error: 1:Operation not permitted
SQL>
网上查询报错信息是跟/proc/sys/vm/hugetlb_shm_group这个文件有关;
查询oracle用户id,在该文件添加uid
[oracle@localhost ~]id oracle
uid=500(oracle) gid=500(dba) groups=500(dba)
[oracle@localhost ~]echo 500 > /proc/sys/vm/hugetlb_shm_group
再启动oracle:
[oracle@localhost ~]sqlplus / as sysdba
SQL*Plus: Release 10.2.0.1.0 - Production on 星期五 3月 15 12:47:14 2019
Copyright (c) 1982, 2005, Oracle. All rights reserved.
Connected to:
Oracle Database 10g Enterprise Edition Release 10.2.0.1.0 - 64bit Production
With the Partitioning, OLAP and Data Mining iptions
SQL>startup;
ORACKE instance started.
Total System Global Area 1224736768 bytes
Fixed Size 2020384 bytes
Variable Size 31870144 bytes
Database Buffers 889192448 bytes
Redi Buffers 14753792 bytes
Database mounted.
Database opened.
SQL>
启动成功。
PS:有时重启数据库之后又会出现上述情况,那么在/etc/sysctl.conf文件中添加如下内容即可:vm.hugetlb_shm_group = 500