ORA-27102:out of memory Linux-X86_64 .

劍舞刀鋒發表於2014-01-07
1.startup Linux下oracle報以下錯 
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
 
3.檢查redo日誌大小:
SQL>select bytes/1024/1024 from v$log;
BYTES/1024/1024
---------------
             50
             50
             50
4.參考其它省redo日誌大小新增並修改redo日誌大小後:
SQL> select bytes/1024/1024 from v$log;
BYTES/1024/1024
---------------
     500
     500
     500
     500
     500
5.檢查alter日誌中不再報Checkpoint not complete錯誤系統正常.

來自 “ ITPUB部落格 ” ,連結:http://blog.itpub.net/29429468/viewspace-1067876/,如需轉載,請註明出處,否則將追究法律責任。

相關文章