ORA-27102:out of memory Linux-X86_64 .
1.startup Linux下oracle報以下錯
ORA-27102:out of memory Linux-X86_64
Error: 28: No space left on device
ORA-27102:out of memory Linux-X86_64
Error: 28: No space left on device
2.檢查alter日誌報:
Checkpoint not complete
Current log# 3 seq# 514388 mem# 0: /opt/oracle/product/10.2.0/oradata/orcl/redo03.log
Thread 1 advanced to log sequence 514389
Current log# 2 seq# 514389 mem# 0: /opt/oracle/product/10.2.0/oradata/orcl/redo02.log
Wed Feb 13 21:36:22 2013
Thread 1 advanced to log sequence 514390
Current log# 1 seq# 514390 mem# 0: /opt/oracle/product/10.2.0/oradata/orcl/redo01.log
Checkpoint not complete
Current log# 3 seq# 514388 mem# 0: /opt/oracle/product/10.2.0/oradata/orcl/redo03.log
Thread 1 advanced to log sequence 514389
Current log# 2 seq# 514389 mem# 0: /opt/oracle/product/10.2.0/oradata/orcl/redo02.log
Wed Feb 13 21:36:22 2013
Thread 1 advanced to log sequence 514390
Current log# 1 seq# 514390 mem# 0: /opt/oracle/product/10.2.0/oradata/orcl/redo01.log
3.檢查redo日誌大小:
SQL>select bytes/1024/1024 from v$log;
SQL>select bytes/1024/1024 from v$log;
BYTES/1024/1024
---------------
50
50
50
4.參考其它省redo日誌大小新增並修改redo日誌大小後:
---------------
50
50
50
4.參考其它省redo日誌大小新增並修改redo日誌大小後:
SQL> select bytes/1024/1024 from v$log;
BYTES/1024/1024
---------------
500
500
500
500
500
---------------
500
500
500
500
500
5.檢查alter日誌中不再報Checkpoint not complete錯誤系統正常.
來自 “ ITPUB部落格 ” ,連結:http://blog.itpub.net/29429468/viewspace-1067876/,如需轉載,請註明出處,否則將追究法律責任。
相關文章
- ORA-27102:out of memory Linux-x86_64 Error: 12: Cannot allocate memory的處理LinuxError
- 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
- note the ORA-27102: out of memory errorError
- 啟動Oracle報錯ORA-27102: out of memory、Linux-x86_64 Error: 28: No space leftOracleLinuxError
- ORA-27102: out of memory故障解決
- 【ERROR】ORA-27102: out of memory 解決方法Error
- ORA-27102: out of memory解決辦法
- oracle啟動遭遇ORA-27102: out of memoryOracle
- ORA-27102 Out of Memory問題處理
- 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以及相關係統引數
- ORA-27102: out of memory Linux Error: 28: No space left on deviceLinuxErrordev
- oracle使用記憶體的錯誤,ORA-27102: out of memoryOracle記憶體
- 資料庫增加SGA,導致ORA-27102: out of memory錯誤資料庫
- Ora-27102: Out Of Memory: Linux Error: 12: [ID 401077.1]LinuxError
- OOM(Out Of Memory)OOM
- java out of memoryJava
- dbca -silent -responsefile 建庫由於tmpfs太小報錯ORA-27102: out of memory
- OOM--OUT OF MEMORYOOM
- An out of memory error has occurred.Error
- OOM(Out Of Memory)是什麼?OOM
- 解決MYSQL工具mysqldump 遇到 Out of memory 方法MySql
- PostgreSQL DBA(95) - PG 12 Partition(out of shared memory)SQL
- git post資料過大報錯-Out of memoryGit
- iOS Out-Of-Memory 原理闡述及方案調研iOS
- A significant part of sql server process memory has been paged outNifiSQLServer
- Out of memory: Kill process 2249 (nginx) score 1 or sacrifice childNginx
- oracle LOGICAL standby ORA-04030: out of process memoryOracle
- android 載入圖片輕鬆避免OOM(out of memory)AndroidOOM
- 由node的批量requests引起的”heap out of memory”解決方案
- ORACLE ORA-04030之 out of process memory when trying to allocateOracle
- solaris上建立oracle資料庫出現:out of memory 錯誤Oracle資料庫
- Composer 記憶體不足解決方案 PHP Fatal error: Out of memory記憶體PHPError
- Win10系統玩cf出現out of memory的解決方法Win10
- Java Out Of Memory解決之JAVA_OPTS引數說明與配置Java