SELECT value/1024/1024 MB FROM v$parameter WHERE name='sga_max_size'; Check free memory :
SEMMSL = 250 (or max processes per instance) SEMMNS = 32000 (or higher) SEMOPM = 100 SEMMNI = 256 (or 1024 for large systems) Set persistently: then verify: echo 65536 >
ulimit -u Linux (check & set) :
vi /etc/security/limits.conf Add:
set maxuprc=16384 , then verify:
echo 65536 > /proc/sys/kernel/pid_max # temporary echo "kernel.pid_max=65536" >> /etc/sysctl.conf Check for zombie processes: then verify: echo 65536 >
ipcs -s | grep oracle | awk 'print $2' | xargs -n1 ipcrm -s Linux : then verify: echo 65536 >