Ora-27102: Out Of Memory: Linux Error: 12: Cannot Allocate Memory with LOCK_SGA=TRUE[ID 401077.1]
来源:互联网 发布:海外域名注册 编辑:程序博客网 时间:2024/05/17 23:06
Ora-27102: Out Of Memory: Linux Error: 12: Cannot Allocate Memory with LOCK_SGA=TRUE
In this Document
Symptoms
Cause
Solution
Applies to:
Linux OS - Version: Enterprise Linux 4.2 and later [Release: RHEL4U2 and later ]Linux x86
Linux x86-64
Linux Kernel - Version: 4.2
Symptoms
After setting oracle init.ora parameter "lock_sga=true" , the instance will not start, getsORA-27102: out of memory Linux-x86_64 Error: 12: Cannot allocate memory on startup
SQL> startup nomount
ORA-27102: out of memory
Linux Error: 12: Cannot allocate memory
SQL> startup mount;
ORA-27102: out of memory
Linux Error: 12: Cannot allocate memory
.
Cause
The "ulimit -l" parameter is not set to allow the amount of memory (sga size) being requested to be locked. For example:# ulimit -a
core file size (blocks, -c) 0
data seg size (kbytes, -d) unlimited
scheduling priority (-e) 20
file size (blocks, -f) unlimited
pending signals (-i) 16382
max locked memory (kbytes, -l) 64 # <<<<<<<
max memory size (kbytes, -m) unlimited
open files (-n) 1024
pipe size (512 bytes, -p) 8
POSIX message queues (bytes, -q) 819200
real-time priority (-r) 0
stack size (kbytes, -s) 8192
cpu time (seconds, -t) unlimited
max user processes (-u) unlimited
virtual memory (kbytes, -v) unlimited
file locks (-x) unlimited
Refer to the "man" page for ulimit -l
Solution
To implement the solution do:
Issue command "ulimit -l unlimited" prior to starting the instance
- Ora-27102: Out Of Memory: Linux Error: 12: Cannot Allocate Memory with LOCK_SGA=TRUE[ID 401077.1]
- Ora-27102: Out Of Memory: Linux Error: 12: Cannot Allocate Memory with LOCK_SGA=TRUE[ID 401077.1]
- kali linux ERROR 12 Cannot allocate memory
- mount error 12 = Cannot allocate memory
- mount error 12 = Cannot allocate memory
- error='Cannot allocate memory'
- ORA-27102: Out of memory error
- Upon startup of Linux database get ORA-27102: out of memory Linux-X86_64 Error: 28: [ID 301830.1]
- ORA-27102:out of memory Linux-X86_64
- ORA-27102: out of memory Linux-X86_64 Error: 28: No space left on device (Doc ID 301830.1)
- mount error(12): Cannot allocate memory解决办法
- ORA-27102: out of memory
- ORA-27102:out of memory
- ORA-27102: out of memory
- ORA-27102: out of memory
- ORA-27102: out of memory
- ORA-27102: out of memory
- Linux Out of memory error
- xcode4.3 如何手动安装iPhone simulator 4.3/5.0
- C#设计模式读书笔记
- Android进阶2之SlidingDrawer(滑动式抽屉)
- linux AIO (异步IO) 那点事儿 [转]
- 使用linq访问数据库
- Ora-27102: Out Of Memory: Linux Error: 12: Cannot Allocate Memory with LOCK_SGA=TRUE[ID 401077.1]
- 使用boost线程池很好的例子
- CentOS 5.x + Apache 2.x + PHP 5.3.x + GD2 + Xcache + vsftpd + MySQL 安装日志
- 如何改变Apache端口
- 嵌入式C/C++语言精华文章集锦
- 获取从上月起往前推24个月的月份下拉框(js)
- hdu 2303 它大爷的用java过不了,才用c++
- python 类中下划线的作用
- 获取从上月起往前推24个月的月份下拉框(Extjs)