ORA-27125: unable to create shared memory segment

简介:

平台环境   :  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]# 
相关文章
|
7月前
|
Oracle 关系型数据库
Customer RecommendedORA-27090 - Unable to Reserve Kernel Resources for Asynchronous Disk I/O
Customer RecommendedORA-27090 - Unable to Reserve Kernel Resources for Asynchronous Disk I/O
52 4
|
关系型数据库 数据库管理 Oracle
|
SQL Oracle 关系型数据库
ORACLE ORA-04030之 out of process memory when trying to allocate
    近期巡检中,一oracle 11g rac节点出现ORACLE ORA-04030之 out of process memory when trying to allocate报错,查询ORACLE官方MOS确定是:BUG11852492,原因是用户会话单进程占用PGA超过4GB异常终止,根据MOS文章1325100.1的建议:可以根据服务器实际情况及SQL运行的实际情况放开PGA单进程使用内存空间的限制到16GB。
1665 0