startup ORA-27102: out of memory Linux-x86_64 Error: 28: No space left on device
oracle相關引數進行調整,
要變更的引數如下:
sga_target
原值:3g
新值:20g
pga_aggregate_target
原值:15g
新值:4g
開始工作:
alter system set sga_target=20g scope=spfile;
alter system set pga_aggregate_target=4g;
然後
shutdown immediate
最後
startup
報錯如下:
SQL> startup
ORA-27102: out of memory Linux-x86_64 Error: 28: No space left on device
後經檢視suse linux的相關引數配置
Normal 0 7.8 磅 0 2 false false false MicrosoftInternetExplorer4
LN-STAT-WEB:/etc # more /etc/sysctl.conf
# Disable response to broadcasts.
# You don't want yourself becoming a Smurf amplifier.
net.ipv4.icmp_echo_ignore_broadcasts = 1
# enable route verification on all interfaces
net.ipv4.conf.all.rp_filter = 1
# enable ipV6 forwarding
#net.ipv6.conf.all.forwarding = 1
#add for oracle11g
kernel.shmall =8388608 -- 值一定要配置成這個(page size)
kernel.shmmax = 15618062894 --配置為實體記憶體一半
kernel.shmmni = 4096
kernel.sem = 250 32000 100 128
net.ipv4.ip_local_port_range = 1024 65000
net.core.rmem_default = 4194304
net.core.rmem_max = 4194304
net.core.wmem_default = 262144
net.core.wmem_max = 262144
fs.file-max = 6553600
sysctl -p --生效之
接著startup就可以了
來自 “ ITPUB部落格 ” ,連結:http://blog.itpub.net/9240380/viewspace-619784/,如需轉載,請註明出處,否則將追究法律責任。
相關文章
- ORA-27102: out of memory Linux-X86_64 Error: 28: No space left on deviceLinuxErrordev
- ORA-27102: out of memory Linux Error: 28: No space left on deviceLinuxErrordev
- 啟動Oracle報錯ORA-27102: out of memory、Linux-x86_64 Error: 28: No space leftOracleLinuxError
- Linux-x86_64 Error: 28: No space left on device問題LinuxErrordev
- ORA-27102:out of memory Linux-x86_64 Error: 12: Cannot allocate memory的處理LinuxError
- ORA-27102:out of memory Linux-X86_64 .Linux
- No space left on devicedev
- note the ORA-27102: out of memory errorError
- openGauss 出現-Error-No-space-left-on-device-提示Errordev
- 【ERROR】ORA-27102: out of memory 解決方法Error
- 關於“No space left on device的原因”dev
- 沒有磁碟空間 No space left on devicedev
- Oracle案例06—— OGG-01098 Could not flush "./dirdat/e1000004383" (error 28, No space left on device)OracleErrordev
- ORA-27102: out of memory故障解決
- Ora-27102: Out Of Memory: Linux Error: 12: [ID 401077.1]LinuxError
- write /usr/include/openssl/cms.h: no space left on devicedev
- ORA-27102: out of memory解決辦法
- oracle啟動遭遇ORA-27102: out of memoryOracle
- ORA-27102 Out of Memory問題處理
- An out of memory error has occurred.Error
- java踩坑之java.io.IOException: No space left on deviceJavaExceptiondev
- 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錯誤資料庫
- ORA-27301: OS failure message: No space left on device解決一例AIdev
- OOM(Out Of Memory)OOM
- java out of memoryJava
- dbca -silent -responsefile 建庫由於tmpfs太小報錯ORA-27102: out of memory
- Apache啟動報錯No space left on device: AH00023該怎麼解決Apachedev
- OOM--OUT OF MEMORYOOM
- 模擬LINUX磁碟分割槽有可用空間無可用Inodes時報錯:No space left on deviceLinuxdev
- ORA-09187、linux-x86_64 Error:28 AND ORA-09945LinuxError
- Docker啟動出現"No space left on device" 或者 docker日誌太多導致磁碟佔滿問題Dockerdev
- Composer 記憶體不足解決方案 PHP Fatal error: Out of memory記憶體PHPError
- Error 945 Database cannot be opened due to inaccessible files or insufficient memory or disk spaceErrorDatabase