I faced with that error message on 12.1.0.2.0 EE version on RHEL6

Here are the error messages

SQL> startup nomount; ORA-27126: unable to lock shared memory segment in core linux-x86_64 Error: 12: Cannot allocate memory Additional information: 3894 Additional information: 2129923 Additional information: 6090752

If you face same issue first check your ram size and your sga_max_size parameter. If your sga_max_size higher than your ram, resize that parameter first.

If your ram&sga_max_size seems okey than check below settings on your system

1. Add or amend the following lines in the “/etc/sysctl.conf” file.

fs.file-max = 6815744

kernel.sem = 250 32000 100 128

kernel.shmmni = 4096

kernel.shmall = 1073741824

kernel.shmmax = 4398046511104

net.core.rmem_default = 262144

net.core.rmem_max = 4194304

net.core.wmem_default = 262144

net.core.wmem_max = 1048576

fs.aio-max-nr = 1048576

net.ipv4.ip_local_port_range = 9000 65500

2. Run the following command to change the current kernel parameters.

/sbin/sysctl -p

3. Add the following lines to the “/etc/security/limits.conf” file.

oracle soft nofile 1024

oracle hard nofile 65536

oracle soft nproc 16384

oracle hard nproc 16384

oracle soft stack 10240

oracle hard stack 32768

4. Amend the “/etc/security/limits.d/90-nproc.conf” file as described below. See MOS Note [ID 1487773.1]

# Change this

* soft nproc 1024

# To this

* nproc 16384

5. Set secure Linux to permissive by editing the “/etc/selinux/config” file, making sure the SELINUX flag is set as follows.

SELINUX=permissive

Once the change is complete, restart the server or run the following command.

# setenforce Permissive

If all are okay the issue related with LOCK_SGA=TRUE parameter. If that parameter has been set on your init file, just disable it or set as FALSE

Reference:

NOTE:827656.1- LOCK_SGA=TRUE Causes An ORA-27126 During Database Startup On AIX

BUG:8439698 STARTUP WITH LOCK_SGA=TRUE FAILS WITH ORA-27126: UNABLE TO LOCK SHARED MEMORY SE

NOTE:361323.1 HugePages on Linux: What It Is… and What It Is Not…

本文系统(linux)相关术语:linux系统 鸟哥的linux私房菜 linux命令大全 linux操作系统

代码区博客精选文章
分页:12
转载请注明
本文标题:ORA-27126 and Linux-x86_64 Error: 12 During Database Creation or during Database ...
本站链接:https://www.codesec.net/view/611065.html


1.凡CodeSecTeam转载的文章,均出自其它媒体或其他官网介绍,目的在于传递更多的信息,并不代表本站赞同其观点和其真实性负责;
2.转载的文章仅代表原创作者观点,与本站无关。其原创性以及文中陈述文字和内容未经本站证实,本站对该文以及其中全部或者部分内容、文字的真实性、完整性、及时性,不作出任何保证或承若;
3.如本站转载稿涉及版权等问题,请作者及时联系本站,我们会及时处理。
登录后可拥有收藏文章、关注作者等权限...
技术大类 技术大类 | 系统(linux) | 评论(0) | 阅读(83)