Group: system group whose members have write permission to oraInventory directory :) Default : oinstall, or can change to DBA.
http://hi.baidu.com/tnsping/blog/item/dde022b4a38f637b8ad4b263.html
http://wenku.baidu.com/view/7ab6e5eb81c758f5f61f6760.html
SQL>show parameter sga
sga_max_size big integer 804M
SQL> select 804*1024*1024 from dual;
804*1024*1024
-------------
843055104
改成6G后
可以启动!
top
Cpu(s): 0.0%us, 0.0%sy, 0.0%ni, 99.8%id, 0.2%wa, 0.0%hi, 0.0%si, 0.0%st
Mem: 3082488k total, 2706636k used, 375852k free, 34704k buffers
Swap: 4095992k total, 0k used, 4095992k free, 1356548k cached
stop instance:
Mem: 3082488k total, 2021280k used, 1061208k free, 35772k buffers
Swap: 4095992k total, 0k used, 4095992k free, 868748k cached
改成1G 差不多?
Mem: 3082488k total, 2720904k used, 361584k free, 36164k buffers
Swap: 4095992k total, 0k used, 4095992k free, 1359020k cached
改成100M,只是多用了一点而已。
Mem: 3082488k total, 2728236k used, 354252k free, 37444k buffers
Swap: 4095992k total, 0k used, 4095992k free, 1361344k cached
kernel.shmmni = 1
kernel.shmmax = 105450496
SGA_MAX=8G
SQL> startup
ORA-27102: out of memory
Linux-x86_64 Error: 28: No space left on device
shmmni 10 还不行,改成20启动了。 但是性能应该还是有影响。