Hello everyone,
my database engine is installed in my machine (oracle database 11.2.0.4.0), and i want to create instance on it:
Linux 2.6.39-400.209.1.el5uek 2013 x86_64 x86_64 x86_64 GNU/Linux
with resource:
and kernel seting recomended by oracle:
1. Modify your kernel settings in /etc/sysctl.conf (RedHat) as follows. If the current value for any parameter is higher than the value listed in this table, do not change the value of that parameter. Range values (such as net.ipv4.ip_local_port_range) must match exactly.
kernel.shmall = physical RAM size / pagesize For most systems, this will be the value 2097152. See [Note 301830.1](https://support.oracle.com/epmos/faces/DocumentDisplay?parent=DOCUMENT&sourceId=880936.1&id=301830.1) for more information.
kernel.shmmax = 1/2 of physical RAM, but not greater than 4GB. This would be the value 2147483648 for a system with 4Gb of physical RAM.
kernel.shmmni = 4096
kernel.sem = 250 32000 100 128
fs.file-max = 512 x processes (for example 6815744 for 13312 processes)
fs.aio-max-nr = 1048576
net.ipv4.ip\_local\_port\_range = 9000 65500
a.) The runInstaller (OUI) checks may expect this to be the old guidance of "1024 65000". The new guidance from Oracle development is "9000 65500". Please allow the runInstaller (OUI) to proceed with the new guidance from Oracle development.
net.core.rmem\_default = 262144
net.core.rmem\_max = 4194304
net.core.wmem\_default = 262144
net.core.wmem\_max = 1048576
Bellow is my kernel setting :
i already change the value of shmmax with 1/2 of physical RAM but it didn't work (ORA-27102: out of memory),
and if i change the value less than my alocated SGA (24GB), diferent error is show up "sga size cannot be greater than maximum shared memory segment size"
Please Help me to analyzed this issued,
Tks B4.