ORA-27125: unable to create shared memory segment

本文介绍了解决Oracle数据库安装后启动时遇到的ORA-27125错误的方法。通过调整Linux系统中huge pages的相关设置,解决了由于页表过大导致的问题。

摘要生成于 C知道 ,由 DeepSeek-R1 满血版支持, 前往体验 >

平台环境   :  Oracle Linux Server release 5.7 x86_64
数据库版本 :  Oracle Database 10g Enterprise Edition Release 10.2.0.1.0 - 64bi

在安装Oracle安装过程中,dbca 建instance的,遇到如下错误

image


以前遇到安装ORACLE成功后,启动过程中遇到ORA-27125错误,但是解决方法一致。官方资料介绍如下:

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.


   1: [root@gsp cdrom]# id oracle
   2: uid=501(oracle) gid=501(oinstall) groups=501(oinstall),502(dba)
   3: [root@gsp cdrom]# more /proc/sys/vm/hugetlb_shm_group
   4: 0
   5: [root@gsp cdrom]#  echo 502 >/proc/sys/vm/hugetlb_shm_group
   6: [root@gsp cdrom]# 
   7: [root@gsp cdrom]# 
评论
添加红包

请填写红包祝福语或标题

红包个数最小为10个

红包金额最低5元

当前余额3.43前往充值 >
需支付:10.00
成就一亿技术人!
领取后你会自动成为博主和红包主的粉丝 规则
hope_wisdom
发出的红包
实付
使用余额支付
点击重新获取
扫码支付
钱包余额 0

抵扣说明:

1.余额是钱包充值的虚拟货币,按照1:1的比例进行支付金额的抵扣。
2.余额无法直接购买下载,可以购买VIP、付费专栏及课程。

余额充值