ORA-27102:out of memory Linux-x86_64 Error: 12: Cannot allocate memory的處理
客戶的oracle資料庫啟動報錯,操作linux,oracle 11g由於將lock_sga引數設定為true當重啟資料庫時報錯ORA-27102: out of memory
SQL> startup nomount
ORA-27102: out of memory
Linux-x86_64 Error: 12: Cannot allocate memory
原因是因為操作引數沒有設定為允許sga所指定大小的記憶體可以被鎖定
[root@jyrac1 ~]# ulimit -a core file size (blocks, -c) 0 data seg size (kbytes, -d) unlimited scheduling priority (-e) 0 file size (blocks, -f) unlimited pending signals (-i) 16384 max locked memory (kbytes, -l) 32 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) 10240 cpu time (seconds, -t) unlimited max user processes (-u) 16384 virtual memory (kbytes, -v) unlimited file locks (-x) unlimited
解決方法有兩種
一:ulimit -l unlimited 在啟動例項之前執行只對當前會話有效
[root@jyrac1 ~]# ulimit -l unlimited [root@jyrac1 ~]# su - oracle [oracle@jyrac1 ~]$ ulimit -a core file size (blocks, -c) 0 data seg size (kbytes, -d) unlimited scheduling priority (-e) 0 file size (blocks, -f) unlimited pending signals (-i) 16384 max locked memory (kbytes, -l) unlimited max memory size (kbytes, -m) unlimited open files (-n) 65536 pipe size (512 bytes, -p) 8 POSIX message queues (bytes, -q) 819200 real-time priority (-r) 0 stack size (kbytes, -s) 10240 cpu time (seconds, -t) unlimited max user processes (-u) 16384 virtual memory (kbytes, -v) unlimited file locks (-x) unlimited
[oracle@jyrac1 ~]$ sqlplus / as sysdba SQL*Plus: Release 11.2.0.1.0 Production on Fri Jun 6 12:20:26 2014 Copyright (c) 1982, 2009, Oracle. All rights reserved. Connected to an idle instance. SQL> startup nomount ORACLE instance started. Total System Global Area 313159680 bytes Fixed Size 2212936 bytes Variable Size 109054904 bytes Database Buffers 197132288 bytes Redo Buffers 4759552 bytes SQL> show parameter lock_sga NAME TYPE VALUE ------------------------------------ ---------------------- ------------------------------ lock_sga boolean TRUE
二:修改/etc/security/limits.conf加入以下資訊
oracle soft memlock 10485760
orcale hard memlock 10485760
允許鎖定10G的記憶體
SQL> startup nomount ORACLE instance started. Total System Global Area 730714112 bytes Fixed Size 2216944 bytes Variable Size 524291088 bytes Database Buffers 197132288 bytes Redo Buffers 7073792 bytes
還有lock_sga引數設定為true是不能啟用自動記憶體管理的
SQL> show parameter memory NAME TYPE VALUE ------------------------------------ ---------------------- ------------------------------ hi_shared_memory_address integer 0 memory_max_target big integer 0 memory_target big integer 0 shared_memory_address integer 0 SQL> alter system set memory_max_target=700M scope=spfile; System altered. SQL> alter system set memory_target=600M scope=spfile; System altered. SQL> shutdown immediate ORA-01507: database not mounted ORACLE instance shut down. SQL> startup nomount ORA-00847: MEMORY_TARGET/MEMORY_MAX_TARGET and LOCK_SGA cannot be set together
說明lock_sga引數設定為true時是不能啟用自動記憶體管理的
來自 “ ITPUB部落格 ” ,連結:http://blog.itpub.net/29802484/viewspace-1353707/,如需轉載,請註明出處,否則將追究法律責任。
相關文章
- note the ORA-27102: out of memory errorError
- ORA-27102 Out of Memory問題處理
- ORA-27102:out of memory Linux-X86_64 .Linux
- ORA-27102: out of memory Linux-X86_64 Error: 28: No space left on deviceLinuxErrordev
- fork failed - Cannot allocate memoryAI
- 【ORACLE】ORA-27102: out of memory報錯的處理Oracle
- startup ORA-27102: out of memory Linux-x86_64 Error: 28: No space left on deviceLinuxErrordev
- 【ERROR】ORA-27102: out of memory 解決方法Error
- 啟動Oracle報錯ORA-27102: out of memory、Linux-x86_64 Error: 28: No space leftOracleLinuxError
- VM warning: INFO: OS::commit_memory Cannot allocate memoryMIT
- Ora-27102: Out Of Memory: Linux Error: 12: [ID 401077.1]LinuxError
- Redis 寫磁碟出錯 Cannot allocate memoryRedis
- redis 寫磁碟出錯Cannot allocate memoryRedis
- ORA-27102: out of memory Linux Error: 28: No space left on deviceLinuxErrordev
- Ubuntu Cannot allocate memory 錯誤解決方案Ubuntu
- redis : Can't save in background: fork: Cannot allocate memoryRedis
- An out of memory error has occurred.Error
- ORA-27102: out of memory故障解決
- ORA-27102: out of memory解決辦法
- oracle啟動遭遇ORA-27102: out of memoryOracle
- ORA-27102: out of memory 問題解決方法
- windows 32位ORA-27102: out of memory錯誤Windows
- ora-01034 ora-27121 Cannot allocate memory錯誤解決
- OOM(Out Of Memory)OOM
- java out of memoryJava
- ORACLE ORA-04030之 out of process memory when trying to allocateOracle
- oracle使用記憶體的錯誤,ORA-27102: out of memoryOracle記憶體
- ORA-27102: out of memory以及相關係統引數
- OOM--OUT OF MEMORYOOM
- 資料庫增加SGA,導致ORA-27102: out of memory錯誤資料庫
- PostgreSQL DBA(95) - PG 12 Partition(out of shared memory)SQL
- OOM(Out Of Memory)是什麼?OOM
- cenots7.6系統報“fork:Cannot allocate memory” 報錯的解決方法(實操)
- dbca -silent -responsefile 建庫由於tmpfs太小報錯ORA-27102: out of memory
- oracle 10g for solaris 10(x86),dbca建庫out of memory處理Oracle 10g
- Composer 記憶體不足解決方案 PHP Fatal error: Out of memory記憶體PHPError
- Thread 1 cannot allocate new log 的處理辦法thread
- AIX平臺下報ORA-04030: out of process memory when trying to allocate string bytesAI