Installing Oracle 10g on many operating system has been my regular jobs for this 2 month. Most of this jobs using Solaris 10 as their operating system. Usually when doing installation, i have a backup from solaris people from many other vendors or their principal to do the setting for solaris 10. I just sit back and relax and watch them do the setting shmmax. It really enjoyable though :D.
Yesterday (02 Dec 2008) , i got my chance to do the setting on production server on myself. Just want to write this note as a reminder on installing other Solaris 10 system on setting up kernel parameters :
# projmod -sK “project.max-sem-nsems=(priv,256,deny)” user.oracle
# projmod -sK “project.max-sem-ids=(priv,100,deny)” user.oracle
# projmod -sK “project.max-shm-ids=(priv,100,deny)” user.oracle
# projmod -sK “project.max-shm-memory=(privileged,10GB,deny)” user.oracle
using this statement as mention on oracle installation for solaris documentation is possible :
prctl -n project.max-shm-memory -v 11gb -r -i project user.oracle
however if you use this statement it will not be permanent, which mean after reboot the server you have to set it again.
to verify with # cat /etc/project or # prctl -i project user.oracle.
as for noexec_user_stack=1 it still has to be set on /etc/system : set noexec_user_stack=1
— thanks for reading — hope it will be useful to anyone who need it.