Search This Blog

Friday, July 24, 2009

Set up environment for linux to install Oracle Software

// Change sysctl.conf file to add the kernel parmeters

cat >> /etc/sysctl.conf << EOF
#This sets SEMMSL, SEMMNS, SEMOPM, SEMMNI
kernel.sem = 256 32000 100 142
kernel.shmmax = 4294967295
kernel.shmmni = 4096
kernel.shmall = 2097152
kernel.msgmnb = 65535
kernel.msgmni = 2878
fs.file-max = 206173
EOF

// Persist the sysctl.conf entries

sysctl –p

// Change the ulimit values

cat >> /etc/security/limits.conf << EOF
# Oracle Application Server settings
* soft nofile 2048
* hard nofile 65536
* soft nproc  2047
* hard nproc  16384
EOF

cat >> /etc/pam.d/login << EOF
session required /lib/security/pam_limits.so
EOF

cat >> /etc/profile << EOF
ulimit -u 16384 -n 65536
EOF

#### Oracle requirements for 11gR2 database ########
kernel.sem = 256 32000 100 142
kernel.shmmax = 4294967295
kernel.shmmni = 4096
kernel.shmall = 2097152
kernel.msgmnb = 65535
kernel.msgmni = 2878
fs.file-max = 6815744
net.ipv4.ip_local_port_range = 9000 65500
net.core.rmem_default=4194304
net.core.rmem_max=4194304
net.core.wmem_default=262144
net.core.wmem_max=1048576
fs.aio-max-nr = 1048576


RPMs needed for 11gR2 Database


libaio-devel-0.3.106-3.2.i386.rpm
sysstat-7.0.2-3.SEL5_2.i386.rpm
unixODBC-devel-2.2.11-7.1.i386.rpm


local copy at \\disco1bdeapac\home\oracle\softwares\RPM112DB (oracle/oracle) windows browseable

1 comment:

Unknown said...

I am wondering why kernel.sem is not the following:
kernel.sem = 256 36352 100 142

From my understanding the parameters are:
SEMMSL, SEMMNS, SEMOPM, SEMMNI and that the second number in the group should ALWAYS be equal to the multiplication of the first number by the last number (SEMMSL * SEMMNI = SEMMNS)?
So why the 32000 instead of 36352? Will this cause any problems?