ORA-27125: unable to create shared memory segment

最新推荐文章于 2023-08-17 20:42:52 发布

SSRmygod

最新推荐文章于 2023-08-17 20:42:52 发布

阅读量480

点赞数

分类专栏： oracle installations oracle 文章标签： oracle 数据库 centos oracle 11g oracle10g

本文链接：https://blog.csdn.net/SSRmygod/article/details/70161879

版权

oracle 同时被 2 个专栏收录

11 篇文章 0 订阅

订阅专栏

oracle installations

10 篇文章 0 订阅

订阅专栏

出自我安装oracle10g：http://write.blog.csdn.net/postedit/70049581

情况如下：

[oracle@mygod1 ~]$ sqlplus / as sysdba

SQL*Plus: Release 10.2.0.1.0 - Production on Tue Apr 11 22:17:34 2017

Copyright (c) 1982, 2005, Oracle. All rights reserved.

Connected to an idle instance.

SQL>
SQL>
SQL>
SQL> startup
ORA-27125: unable to create shared memory segment
Linux-x86_64 Error: 1: Operation not permitted
SQL> ho cat /proc/sys/vm/hugetlb_shm_group
0

SQL> exit

解决方法：

[root@mygod1 ~]# id oracle
uid=501(oracle) gid=501(oinstall) groups=501(oinstall),502(dba)
[root@mygod1 ~]# echo "502" >/proc/sys/vm/hugetlb_shm_group

[root@mygod1 ~]# cat /proc/sys/vm/hugetlb_shm_group
502
[root@mygod1 ~]#
[root@mygod1 ~]# exit
logout

[oracle@mygod1 ~]$ sqlplus / as sysdba

SQL*Plus: Release 10.2.0.1.0 - Production on Tue Apr 11 22:22:46 2017

Copyright (c) 1982, 2005, Oracle. All rights reserved.

Connected to an idle instance.

SQL>
SQL> startup
ORACLE instance started.

Total System Global Area 595591168 bytes
Fixed Size 2022600 bytes
Variable Size 171967288 bytes
Database Buffers 419430400 bytes
Redo Buffers 2170880 bytes
Database mounted.
Database opened.
SQL>