Preparation

Posted 5 April, 2006 - 14:19

Preparing the Operating System for ORACLE 9i

Configure Shared Memory, Semaphores, File Handles, Limits

Edit /etc/sysctl.conf to set up these items (figure 1.0):

Figure 1.0

kernel.shmmax = 2147483648
kernel.sem = 250 32000 100 128
fs.file-max=65536


The above changes are basic ones for a system with 512Mb RAM.

Edit /etc/security/limits.conf to set up the following values (figure 1.1):

Figure 1.1

oracle    soft    nofile     4096
oracle    hard    nofile    16384
oracle    soft    nproc      2047
oracle    hard    nproc     16384

For details on these configuration settings, consult both the ORACLE installation guide and Unix systems administration documentation.