启动Oracle报错ORA-27102: out of memory、Linux-x86_64 Error: 28: No space left

短命女 2024-04-18 00:45 25阅读 0赞

生产环境的一套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  
    
4.    
    
5.  \# 报错原因  
    
6.  \# 查看内核参数配置文件，发现关于内存的内核参数被修改成很小的值，这个值远远低于数据库SGA、PGA内存参数设置的值；进而导致数据库无法启动。  
    
7.  $ cat sysctl.conf  
    
8.  \# Controls the maximum shared segment size, in bytes  
    
9.  kernel.shmmax = 68719476736  
    
10.   
    
11. \# Controls the maximum number of shared memory segments, in pages  
    
12. kernel.shmall = 4294967296  
    
13.   
    
14.   
    
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  
    
21.   
    
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  
    
44.   
    
45. SQL> startup pfile='/u01/oracle/product/11gr2/db\_home/dbs/initerp.ora'  
    
46. ORACLE instance started.  
    
47.   
    
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/，如需转载，请注明出处，否则将追究法律责任。

转载于:http://blog.itpub.net/26506993/viewspace-2155754/