1.3 Operating System Prerequisite for Database Setup
This topic provides information on Operating System prerequisite for Database Setup.
Following are the main kernel and database initialization parameters that you need
to setup as part of the environment.
Table 1-1 Kernel Parameters and Recommended Value
| Kernel Parameters | Recommended Value | Description |
|---|---|---|
| nproc (Soft) | 2047 | Shell Limits (/etc/security/limits.conf) |
| nproc (Hard) | 16384 | Shell Limits (/etc/security/limits.conf) |
| nofile (Hard) | 1024 | Shell Limits (/etc/security/limits.conf) |
| nofile (Hard) | 65536 | Shell Limits (/etc/security/limits.conf) |
| fs.file-max | 6815744 | Kernel Parameter (/etc/sysctl.conf ) |
| kernel.shmall | 2097152 | Kernel Parameter (/etc/sysctl.conf ) |
| kernel.shmmax | 2147483648 | Kernel Parameter (/etc/sysctl.conf ) |
| kernel.shmmni | 4096 | Kernel Parameter (/etc/sysctl.conf ) |
| kernel.sem | 250 32000 100 128 | Kernel Parameter (/etc/sysctl.conf ) |
| net.ipv4.ip_local_port_range | 9000 65500 | Kernel Parameter (/etc/sysctl.conf ) |
| net.core.rmem_default | 262144 | Kernel Parameter (/etc/sysctl.conf ) |
| net.core.rmem_max | 4194304 | Kernel Parameter (/etc/sysctl.conf ) |
| net.core.wmem_default | 262144 | Kernel Parameter (/etc/sysctl.conf ) |
| net.core.wmem_max | 1048576 | Kernel Parameter (/etc/sysctl.conf ) |
|
SWAP Space |
This section displays the recommended value for SWAP space | This section displays the SWAP space requirement |
|
RAM Between 1 GB and 2 GB |
1.5 times the size of RAM |
SWAP space requirement |
|
Between 2 GB and 16 GB |
Equal to the size of RAM |
SWAP space requirement |
|
More than 16 GB |
16 GB |
SWAP space requirement |
| Patches | Verify as per Oracle’s platform specific release notes |