Oracle database 11g r2 Pre-Install on Solaris 10

User: oracle
Group: oinstall

Check memory
Prtconf | grep Mem

Create Group

#groupadd oinstall
#groupadd dba

Create user

# useradd -g oinstall -G dba -d /export/home/oracle -s /usr/bin/bash oracle
# chown oracle:oinstall /export/home/oracle

Create Project

# projadd -U oracle -K "project.max-shm-memory=(priv,4g,deny)" user.oracle
# 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

Check Project Parameter

prctl -i project user.oracle
prctl -n project.max-sem-ids -i task `ps -o taskid= -p $$`

Edit Project Parameter

# 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

Config Kernel Parameter in ‘/etc/system’

set noexec_user_stack=1
set semsys:seminfo_semmni=100
set semsys:seminfo_semmns=1024
set semsys:seminfo_semmsl=300
set semsys:seminfo_semvmx=32767
set shmsys:seminfo_shmmax=2147483648
set shmsys:shminfo_shmmni=512
set shmsys:shminfo_shmmin=1
set shmsys:shminfo_shmseg=150


Config Oracle env in ‘/export/home/oracle/.profile’

export PS1='($ORACLE_SID) $PWD $ '
export ORACLE_BASE=/u01/oracle
export ORACLE_OWNER=oracle
export ORACLE_HOME=$ORACLE_BASE/product/11.2.0/dbhome_1
export PATH=$PATH:/usr/openwin/bin:$ORACLE_HOME/bin:/usr/sbin:/usr/bin
export ORACLE_SID=EDCS1

Config Soft Limit $ Hard Limit in ‘/etc/system’
set max_nprocs=30000
set maxuprc=16384

ADD ndd config to '/etc/inittab'
tm::sysinit:/usr/sbin/ndd -set /dev/tcp tcp_smallest_anon_port 9000 > /dev/console
tm::sysinit:/usr/sbin/ndd -set /dev/tcp tcp_largest_anon_port 65500 > /dev/console
tm::sysinit:/usr/sbin/ndd -set /dev/udp udp_smallest_anon_port 9000 > /dev/console
tm::sysinit:/usr/sbin/ndd -set /dev/udp udp_largest_anon_port 65500 > /dev/console


Install oracle DB
./runinstall