{"id":595,"date":"2014-01-30T10:19:14","date_gmt":"2014-01-30T03:19:14","guid":{"rendered":"http:\/\/blog.trichev.com\/?p=595"},"modified":"2017-08-10T09:27:25","modified_gmt":"2017-08-10T02:27:25","slug":"oracle-database-11g-r2-requirements-rhel-6","status":"publish","type":"post","link":"https:\/\/trichev.com\/blog\/2014\/01\/30\/oracle-database-11g-r2-requirements-rhel-6\/","title":{"rendered":"Oracle Database 11g R2 requirements. RHEL 6"},"content":{"rendered":"

Kernel Parameters:<\/strong><\/p>\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n
Parameter<\/th>\nMinimum Value<\/th>\nFile<\/th>\n<\/tr>\n<\/thead>\n
semmsl<\/code><\/td>\n250<\/td>\n\/proc\/sys\/kernel\/sem<\/code><\/td>\n<\/tr>\n
semopm<\/code><\/td>\n100<\/td>\n<\/td>\n<\/tr>\n
semmni<\/code><\/td>\n128<\/td>\n<\/td>\n<\/tr>\n
semm<\/code><\/td>\n32000<\/td>\n<\/td>\n<\/tr>\n
shmall<\/code><\/td>\n2097152<\/td>\n\/proc\/sys\/kernel\/shmall<\/code><\/td>\n<\/tr>\n
shmmax<\/code><\/td>\nMinimum: 536870912;<\/p>\n

Maximum: A value that is 1 byte less than the physical memory<\/p>\n

Recommended: More than half the physical memory<\/p>\n

See My Oracle Support Note 567506.1 for additional information about configuring shmmax<\/code>.<\/td>\n

\/proc\/sys\/kernel\/shmmax<\/code><\/td>\n<\/tr>\n
shmmni<\/code><\/td>\n4096<\/td>\n\/proc\/sys\/kernel\/shmmni<\/code><\/td>\n<\/tr>\n
file<\/code>–max<\/code><\/td>\n6815744<\/td>\n\/proc\/sys\/fs\/file-max<\/code><\/td>\n<\/tr>\n
ip_local_port_range<\/code><\/td>\nMinimum: 9000;<\/p>\n

Maximum: 65500<\/td>\n

\/proc\/sys\/net\/ipv4\/ip_local_port_range<\/code><\/td>\n<\/tr>\n
rmem_default<\/code><\/td>\n262144<\/td>\n\/proc\/sys\/net\/core\/rmem_default<\/code><\/td>\n<\/tr>\n
rmem_max<\/code><\/td>\n4194304<\/td>\n\/proc\/sys\/net\/core\/rmem_max<\/code><\/td>\n<\/tr>\n
wmem_default<\/code><\/td>\n262144<\/td>\n\/proc\/sys\/net\/core\/wmem_default<\/code><\/td>\n<\/tr>\n
wmem_max<\/code><\/td>\n1048576<\/td>\n\/proc\/sys\/net\/core\/wmem_max<\/code><\/td>\n<\/tr>\n
aio-max-nr<\/code><\/td>\n1048576;<\/p>\n

Note: This value limits concurrent outstanding requests and should be set to avoid I\/O subsystem failures.<\/td>\n

\/proc\/sys\/fs\/aio-max-nr<\/code><\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n
<\/div>\n
Make a note of the current values and identify any values that you must change.<\/div>\n
\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n
Parameter<\/th>\nCommand<\/th>\n<\/tr>\n<\/thead>\n
semmsl<\/code>, semmns<\/code>, semopm<\/code>, and semmni<\/code><\/td>\n# \/sbin\/sysctl -a | grep sem <\/code>This command displays the value of the semaphore parameters in the order listed.<\/td>\n<\/tr>\n
shmall<\/code>, shmmax<\/code>, and shmmni<\/code><\/td>\n# \/sbin\/sysctl -a | grep shm<\/code><\/td>\n<\/tr>\n
file-max<\/code><\/td>\n# \/sbin\/sysctl -a | grep file-max<\/code><\/td>\n<\/tr>\n
ip_local_port_range<\/code><\/td>\n# \/sbin\/sysctl -a | grep ip_local_port_range<\/code><\/td>\n<\/tr>\n
rmem_default<\/code><\/td>\n# \/sbin\/sysctl -a | grep rmem_default<\/code><\/td>\n<\/tr>\n
rmem_max<\/code><\/td>\n# \/sbin\/sysctl -a | grep rmem_max<\/code><\/td>\n<\/tr>\n
wmem_default<\/code><\/td>\n# \/sbin\/sysctl -a | grep wmem_default<\/code><\/td>\n<\/tr>\n
wmem_max<\/code><\/td>\n# \/sbin\/sysctl -a | grep wmem_max<\/code><\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<\/div>\n

\/etc\/sysctl.conf:
\nkernel.shmmax = 4294967295
\n# Maximum amount of shared memory (in pages) that can be used at one time on the system and should be at least ceil (SHMMAX\/PAGE_SIZE)
\nkernel.shmall = 1048575
\nkernel.shmmni = 4096
\nkernel.sem = 250 32000 100 128
\nnet.ipv4.ip_local_port_range = 9000 65500
\nnet.core.rmem_default = 262144
\nnet.core.rmem_max = 4194304
\nnet.core.wmem_default = 262144
\nnet.core.wmem_max = 1048576
\nfs.aio-max-nr = 1048576
\nfs.file-max = 6815744<\/p>\n

\/sbin\/sysctl -p<\/p>\n

\/sbin\/sysctl -a<\/p>\n

Resource Limit Recommended Ranges:<\/strong><\/p>\n\n\n\n\n\n\n\n
Resource Shell Limit<\/th>\nResource<\/th>\nSoft Limit<\/th>\nHard Limit<\/th>\n<\/tr>\n<\/thead>\n
Open file descriptors<\/td>\nnofile<\/td>\nat least 1024<\/td>\nat least 65536<\/td>\n<\/tr>\n
Number of processes available to a single user<\/td>\nnproc<\/td>\nat least 2047<\/td>\nat least 16384<\/td>\n<\/tr>\n
Size of the stack segment of the process<\/td>\nstack<\/td>\nat least 10240 KB<\/td>\nat least 10240 KB, and at most 32768 KB<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n

Check the soft and hard limits for the file descriptor setting. Ensure that the result is in the recommended range. For example:
\n$ ulimit -Sn
\n4096
\n$ ulimit -Hn
\n65536<\/p>\n

Check the soft and hard limits for the number of processes available to a user. Ensure that the result is in the recommended range. For example:
\n$ ulimit -Su
\n2047
\n$ ulimit -Hu
\n16384<\/p>\n

Check the soft limit for the stack setting. Ensure that the result is in the recommended range. For example:
\n$ ulimit -Ss
\n10240
\n$ ulimit -Hs
\n32768<\/p>\n

\/etc\/security\/limits.conf:
\noracle soft nproc 2047
\noracle hard nproc 16384
\noracle soft nofile 1024
\noracle hard nofile 65536
\noracle soft stack 10240<\/p>\n

Add the following line to the \/etc\/pam.d\/login file, if it does not already exist:
\nsession required pam_limits.so<\/p>\n

For the Bourne, Bash, or Korn shell, add the following lines to the \/etc\/profile<\/tt> file:<\/p>\n\n\n\n
\n
if [ $USER = \"oracle\" ]; then\r\n  if [ $SHELL = \"\/bin\/ksh\" ]; then\r\n    ulimit -p 16384\r\n    ulimit -n 65536\r\n  else\r\n    ulimit -u 16384 -n 65536\r\n  fi\r\nfi<\/pre>\n<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n
For the C shell (csh or tcsh), add the following lines to the \/etc\/csh.login<\/tt> file:<\/p>\n\n\n\n
\n
if ( $USER == \"oracle\" ) then \r\n  limit maxproc 16384\r\n  limit descriptors 65536\r\nendif<\/pre>\n<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n
Package Requirements:<\/strong><\/p>\n
binutils-2.20.51.0.2
\ncompat-libcap1-1.10
\ncompat-libcap1-1.10 (32-bit)
\ncompat-libstdc++-33-3.2.3
\ncompat-libstdc++-33-3.2.3 (32 bit)
\nelfutils-libelf-0.148
\nelfutils-libelf-devel-0.148
\ngcc-4.4.4
\ngcc-c++-4.4.4
\nglibc-2.12-1
\nglibc-2.12-1 (32 bit)
\nglibc-common-2.12
\nglibc-devel-2.12
\nglibc-devel-2.12 (32 bit)
\nglibc-headers-2.12
\nksh-20100621
\nlibaio-0.3.107
\nlibaio-0.3.107 (32 bit)
\nlibaio-devel-0.3.107
\nlibaio-devel-0.3.107 (32 bit)
\nlibgcc-4.4.4
\nlibgcc-4.4.4 (32 bit)
\nlibstdc++-4.4.4
\nlibstdc++-4.4.4 (32 bit)
\nlibstdc++-devel-4.4.4
\nlibstdc++-devel-4.4.4 (32 bit)
\nmake-3.81
\nnumactl-devel-2.0.3
\nsysstat-9.0.4
\nunixODBC-2.2.14
\nunixODBC-2.2.14 (32 bit)
\nunixODBC-devel-2.2.14
\nunixODBC-devel-2.2.14 (32 bit)<\/p>\n
yum install xterm binutils-2*x86_64* compat-libcap1*x86_64* compat-libcap1*i686* compat-libstdc++-33*x86_64* compat-libstdc++-33*i686* elfutils-libelf-0*x86_64* elfutils-libelf-devel-0*x86_64* gcc-4*x86_64* gcc-c++-4*x86_64* glibc-2*x86_64* glibc-2*i686* glibc-devel-2*x86_64* glibc-devel-2*i686* glibc-common-2*x86_64* glibc-headers*x86_64* ksh-*x86_64* libaio-0*x86_64* libaio-0*i686* libaio-devel-0*x86_64* libaio-devel-0*i686* libgcc-4*x86_64* libgcc-4*i686* libstdc++-4*x86_64* libstdc++-4*i686* libstdc++-devel-4*x86_64* libstdc++-devel-4*i686* make-3*x86_64* numactl-devel-2*x86_64* sysstat-9*x86_64* xorg-x11-utils<\/p>\n
yum install unixODBC*x86_64* unixODBC*i686* unixODBC-devel*x86_64* unixODBC-devel*i686*<\/p>\n
Memory<\/h2>\n
The minimum required RAM for Oracle Database 11g<\/i> Release 2 running on the Linux platform is 1 GB (although 2 GB or more of RAM is highly recommended).<\/p>\n
Use the following command to check the amount of installed RAM on the system:<\/p>\n\n\n\n
\n
[root@testnode1 ~]# cat \/proc\/meminfo | grep MemTotal<\/b>\r\nMemTotal:        4020892 kB<\/pre>\n<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n
If the size of the installed RAM is less than the required size, then you must install more memory before continuing.<\/p>\n
Swap Space<\/h2>\n
The following table describes the relationship between installed RAM and the configured swap space recommendation.<\/p>\n\n\n\n\n\n\n\n
Available RAM<\/th>\nSwap Space Required<\/th>\n<\/tr>\n<\/thead>\n
Between 1 GB and 2 GB<\/td>\n1.5 times the size of RAM<\/td>\n<\/tr>\n
Between 2 GB and 16 GB<\/td>\nEqual to the size of RAM<\/td>\n<\/tr>\n
More than 16 GB<\/td>\n16 GB<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n
Use the following command to determine the size of the configured swap space:<\/p>\n\n\n\n
\n
[root@testnode1 ~]# grep SwapTotal \/proc\/meminfo<\/b>\r\nSwapTotal:       6258680 kB<\/pre>\n<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n
 <\/p>\n","protected":false},"excerpt":{"rendered":"
Kernel Parameters: Parameter Minimum Value File semmsl 250 \/proc\/sys\/kernel\/sem semopm 100 semmni 128 semm 32000 shmall 2097152 \/proc\/sys\/kernel\/shmall shmmax Minimum: 536870912; Maximum: A value that is 1 byte less than the physical memory Recommended: More than half the physical memory See My Oracle Support Note 567506.1 for additional information about configuring shmmax. \/proc\/sys\/kernel\/shmmax shmmni 4096 […]<\/p>\n","protected":false},"author":2,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":[],"categories":[231],"tags":[32,162,86,28,14,11],"aioseo_notices":[],"_links":{"self":[{"href":"https:\/\/trichev.com\/blog\/wp-json\/wp\/v2\/posts\/595"}],"collection":[{"href":"https:\/\/trichev.com\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/trichev.com\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/trichev.com\/blog\/wp-json\/wp\/v2\/users\/2"}],"replies":[{"embeddable":true,"href":"https:\/\/trichev.com\/blog\/wp-json\/wp\/v2\/comments?post=595"}],"version-history":[{"count":18,"href":"https:\/\/trichev.com\/blog\/wp-json\/wp\/v2\/posts\/595\/revisions"}],"predecessor-version":[{"id":604,"href":"https:\/\/trichev.com\/blog\/wp-json\/wp\/v2\/posts\/595\/revisions\/604"}],"wp:attachment":[{"href":"https:\/\/trichev.com\/blog\/wp-json\/wp\/v2\/media?parent=595"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/trichev.com\/blog\/wp-json\/wp\/v2\/categories?post=595"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/trichev.com\/blog\/wp-json\/wp\/v2\/tags?post=595"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}