Quick reference: pre-installation steps of Oracle database 10g and 11g (non RAC) on RHEL 5

1. Users, groups and directories

# groupadd oinstall

# groupadd dba

# groupadd oper

# useradd -g oinstall -G dba,oper oracle

# passwd oracle

# mkdir -p /u01/app/oracle

# chown oracle:oinstall /u01/app

# chown oracle:oinstall /u01/app/oracle

2. Packages (This needs an yum repository to be configured ready. If you do not have it, refer steps here to create)

# yum install compat-libstdc++* elfutils* gcc-c++ libaio-devel libXp sysstat unixODBC-devel

3. Kernel parameters

/etc/sysctl.conf:

fs.aio-max-nr = 1048576

fs.file-max   = 6815744

kernel.shmall = 2097152

kernel.shmmax = 536870912

kernel.shmmni = 4096

kernel.sem    = 250 32000 100 128

net.ipv4.ip_local_port_range = 9000 65500

net.core.rmem_default =  262144

net.core.rmem_max     = 4194304

net.core.wmem_default =  262144

net.core.wmem_max     = 1048586

To make these effect immediately

# sysctl -p

4. Shell limits

/etc/pam.d/login:

session    required     pam_limits.so

/etc/security/limits.conf:

oracle  soft    nproc    2047

oracle  hard    nproc   16384

oracle  soft    nofile   1024

oracle  hard    nofile  65536

/etc/profile:

if [ $USER = "oracle" ]; then

  ulimit -u 16384 -n 65536

fi