ipcs -s | grep oracle | awk 'print $2' | xargs -n1 ipcrm -s Linux :
vi /etc/security/limits.conf Add:
# shmmax = 80% of RAM, shmall = shmmax / 4096 (page size) echo "kernel.shmmax = 68719476736" >> /etc/sysctl.conf # 64GB echo "kernel.shmall = 16777216" >> /etc/sysctl.conf sysctl -p : ipcs -s | grep oracle | awk 'print
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: ipcs -s | grep oracle | awk 'print
set maxuprc=16384 , then verify:
ls -l $ORACLE_HOME/bin/oracle # Should have setuid (rwsr-s--x) chmod 6751 $ORACLE_HOME/bin/oracle Increase (Linux): ipcs -s | grep oracle | awk 'print
# Current semaphore limits (SEMMSL, SEMMNS, SEMOPM, SEMMNI) ipcs -ls | grep "max number of arrays" cat /proc/sys/kernel/sem Recommended for Oracle:
oracle soft nproc 16384 oracle hard nproc 32768 oracle soft nofile 65536 oracle hard nofile 65536 in /etc/system :
hbspt.forms.create({ portalId: "5005699", formId: "0eae776d-9123-4ab9-980e-ab305eedde03" });
hbspt.forms.create({ portalId: "5005699", formId: "d7eeccc4-e338-4f4c-af55-6c77519cf7f1" });