Ora-27102: Out Of Memory: Linux Error: 12: [ID 401077.1]
Ora-27102: Out Of Memory: Linux Error: 12: Cannot Allocate Memory with LOCK_SGA=TRUE
In this Document
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
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
來自 “ ITPUB部落格 ” ,連結:http://blog.itpub.net/20674423/viewspace-767830/,如需轉載,請註明出處,否則將追究法律責任。
相關文章
- note the ORA-27102: out of memory errorError
- ORA-27102:out of memory Linux-x86_64 Error: 12: Cannot allocate memory的處理LinuxError
- ORA-27102: out of memory Linux Error: 28: No space left on deviceLinuxErrordev
- 【ERROR】ORA-27102: out of memory 解決方法Error
- ORA-27102: out of memory Linux-X86_64 Error: 28: No space left on deviceLinuxErrordev
- startup ORA-27102: out of memory Linux-x86_64 Error: 28: No space left on deviceLinuxErrordev
- ORA-27102:out of memory Linux-X86_64 .Linux
- ORA-27102: out of memory故障解決
- 啟動Oracle報錯ORA-27102: out of memory、Linux-x86_64 Error: 28: No space leftOracleLinuxError
- ORA-27102: out of memory解決辦法
- oracle啟動遭遇ORA-27102: out of memoryOracle
- ORA-27102 Out of Memory問題處理
- An out of memory error has occurred.Error
- ORA-27102: out of memory 問題解決方法
- windows 32位ORA-27102: out of memory錯誤Windows
- 【ORACLE】ORA-27102: out of memory報錯的處理Oracle
- ORA-27102: out of memory以及相關係統引數
- oracle使用記憶體的錯誤,ORA-27102: out of memoryOracle記憶體
- 資料庫增加SGA,導致ORA-27102: out of memory錯誤資料庫
- OOM(Out Of Memory)OOM
- java out of memoryJava
- dbca -silent -responsefile 建庫由於tmpfs太小報錯ORA-27102: out of memory
- PostgreSQL DBA(95) - PG 12 Partition(out of shared memory)SQL
- Linux 6下EBS R12.2.4開啟報錯 OutOfMemory(out of memory)Linux
- OOM--OUT OF MEMORYOOM
- Composer 記憶體不足解決方案 PHP Fatal error: Out of memory記憶體PHPError
- OOM(Out Of Memory)是什麼?OOM
- android 載入圖片輕鬆避免OOM(out of memory)AndroidOOM
- Javascript記憶體溢位,FATAL ERROR: CALL_AND_RETRY_LAST Allocation failed - JavaScript heap out of memoryJavaScript記憶體溢位ErrorASTAI
- error C2061: syntax error : identifier '__RPC__out_xcount_part'ErrorIDERPC
- PHP Fatal error: Allowed memory size of 1610612736 bytesPHPError
- 解決MYSQL工具mysqldump 遇到 Out of memory 方法MySql
- Fatal NI Connect Error 12170, 'TNS-12535: TNS:operation timed outError
- 原來OOM的罪魁禍首是C程式碼---android out of memory(OOM)OOMC程式Android
- 解決yarn打包時出現“FATAL ERROR: Reached heap limit Allocation failed - JavaScript heap out of memory”的問題YarnErrorMITAIJavaScript
- git post資料過大報錯-Out of memoryGit
- iOS Out-Of-Memory 原理闡述及方案調研iOS
- Out of sort memory, consider increasing server sort buffer size的兩種情況IDEServer