Ora-27103 Internal Error Svr4 Error 11 Resource Temporarily Unavailable -

SHOW PARAMETER processes SHOW PARAMETER sessions Increase (e.g., to 2000):

SELECT value/1024/1024 MB FROM v$parameter WHERE name='sga_max_size'; Check free memory :

set semsys:seminfo_semmns=4096 set semsys:seminfo_semmni=1024 set semsys:seminfo_semmsl=512 (if instance is down): SHOW PARAMETER processes SHOW PARAMETER sessions Increase (e

ulimit -u Linux (check & set) :

ipcs -s | grep oracle | awk 'print $2' | xargs -n1 ipcrm -s Linux : SHOW PARAMETER processes SHOW PARAMETER sessions Increase (e

echo "kernel.sem = 250 32000 100 256" >> /etc/sysctl.conf sysctl -p in /etc/system :

# Current semaphore limits (SEMMSL, SEMMNS, SEMOPM, SEMMNI) ipcs -ls | grep "max number of arrays" cat /proc/sys/kernel/sem Recommended for Oracle: SHOW PARAMETER processes SHOW PARAMETER sessions Increase (e

set maxuprc=16384 , then verify: