set semsys:seminfo_semmns=4096 set semsys:seminfo_semmni=1024 set semsys:seminfo_semmsl=512 (if instance is down):
# Current limits cat /proc/sys/kernel/shmmax cat /proc/sys/kernel/shmall Set for large SGA: Check free memory :
echo "kernel.sem = 250 32000 100 256" >> /etc/sysctl.conf sysctl -p in /etc/system : Check free memory :
ulimit -u Linux (check & set) :
vi /etc/security/limits.conf Add:
SELECT value/1024/1024 MB FROM v$parameter WHERE name='sga_max_size'; Check free memory : Check free memory :
