啟動Oracle報錯ORA-27102: out of memory、Linux-x86_64 Error: 28: No space left

feelpurple發表於2018-06-07
OracleLinuxError
生產環境的一套Oracle資料庫，啟動資料庫的時候，報錯。

  1. SQL> startup pfile='/u01/oracle/product/11gr2/db_home/dbs/initerp.ora'
  2. ORA-27102: out of memory
  3. Linux-x86_64 Error: 28: No space left on device

  5. # 報錯原因
  6. # 檢視核心引數配置檔案，發現關於記憶體的核心引數被修改成很小的值，這個值遠遠低於資料庫SGA、PGA記憶體引數設定的值；進而導致資料庫無法啟動。
  7. $ cat sysctl.conf
  8. # Controls the maximum shared segment size, in bytes
  9. kernel.shmmax = 68719476736

  11. # Controls the maximum number of shared memory segments, in pages
  12. kernel.shmall = 4294967296


  15. fs.aio-max-nr = 1048576
  16. fs.file-max = 6815744
  17. kernel.shmmax = 536870912
  18. net.ipv4.ip_local_port_range = 9000 65500
  19. kernel.shmall = 2097152
  20. kernel.shmmax = 2147483648

  22. # 解決方法
  23. # 註釋掉錯誤的引數，重新重新整理核心引數
  24. [root@erp2 ~]# sysctl -p
  25. net.ipv4.ip_forward = 0
  26. net.ipv4.conf.default.rp_filter = 1
  27. net.ipv4.conf.default.accept_source_route = 0
  28. kernel.sysrq = 0
  29. kernel.core_uses_pid = 1
  30. net.ipv4.tcp_syncookies = 1
  31. kernel.msgmnb = 65536
  32. kernel.msgmax = 65536
  33. kernel.shmmax = 68719476736
  34. kernel.shmall = 4294967296
  35. fs.aio-max-nr = 1048576
  36. fs.file-max = 6815744
  37. net.ipv4.ip_local_port_range = 9000 65500
  38. kernel.shmmni = 4096
  39. kernel.sem = 250 32000 100 128
  40. net.core.rmem_default = 262144
  41. net.core.rmem_max = 4194304
  42. net.core.wmem_default = 262144
  43. net.core.wmem_max = 1048576

  45. SQL> startup pfile='/u01/oracle/product/11gr2/db_home/dbs/initerp.ora'
  46. ORACLE instance started.

  48. Total System Global Area 1.0689E+10 bytes
  49. Fixed Size         2216344 bytes
  50. Variable Size         1946160744 bytes
  51. Database Buffers     8724152320 bytes
  52. Redo Buffers         16945152 bytes
  53. Database mounted.
  54. Database opened.
  55. SQL> shutdown immediate
  56. Database closed.
  57. Database dismounted.
  58. ORACLE instance shut down.

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

相關文章