|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
OS Version | Patches/Packages | Kernel settings |
Oracle Linux 6 with the Unbreakable Enterprise kernel: 2.6.39-200.24.1.el6uek.x86_64 or later Oracle Linux 6 with the Red Hat Compatible kernel: 2.6.32-71.el6.x86_64 or later Red Hat Enterprise Linux 6: 2.6.32-71.el6.x86_64 or later Red Hat Enterprise Linux 6 with the Unbreakable Enterprise Kernel: 2.6.32-100.28.5.el6.x86_64 or later Reference : | binutils-2.20.51.0.2-5.11.el6 (x86_64) glibc-2.12-1.7.el6 (x86_64) libgcc-4.4.4-13.el6 (x86_64) libstdc++-4.4.4-13.el6 (x86_64) libaio-0.3.107-10.el6 (x86_64) libXext-1.1 (x86_64) libXtst-1.0.99.2 (x86_64) libX11-1.3 (x86_64) libXau-1.0.5 (x86_64) libxcb-1.5 (x86_64) libXi-1.3 (x86_64) make-3.81-19.el6 sysstat-9.0.4-11.el6 (x86_64) compat-libcap1-1.10-1 (x86_64) compat-libstdc++-33-3.2.3-69.el6 (x86_64) gcc-4.4.4-13.el6 (x86_64) gcc-c++-4.4.4-13.el6 (x86_64) glibc-devel-2.12-1.7.el6 (x86_64) ksh <== any version of ksh is acceptable libstdc++-devel-4.4.4-13.el6 (x86_64) libaio-devel-0.3.107-10.el6 (x86_64) Some depended RPMS for above listed packages cloog-ppl.x86_64 0:0.15.7-1.2.el6 cpp.x86_64 0:4.4.6-4.el6 glibc-headers.x86_64 0:2.12-1.80.el6 kernel-headers.x86_64 0:2.6.32-279.el6 mpfr.x86_64 0:2.4.1-6.el6 ppl.x86_64 0:0.10.2-11.el6 | kernel.shmmni = 4096 kernel.sem = 250 32000 100 128 fs.file-max = 6815744 fs.aio-max-nr = 3145728 Note: This value limits concurrent outstanding requests and should be set to avoid I/O subsystem failures. 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 = 1048576 /etc/security/limits.conf oracle soft nproc 16384 (as per unpublished Bug 15971421) oracle hard nproc 16384 oracle soft nofile 1024 oracle hard nofile 65536 oracle soft stack 10240 oracle hard stack 10240 |
OS Version | Patches/Packages | Kernel settings |
Oracle Linux 7 with the Unbreakable Enterprise kernel: 3.8.13-33.el7uek.x86_64 or later Oracle Linux 7 with the Red Hat Compatible kernel: 3.10.0-54.0.1.el7.x86_64 or later Red Hat Enterprise Linux 7: 3.10.0-54.0.1.el7.x86_64 or later Reference : | binutils-2.23.52.0.1-12.el7.x86_64 compat-libcap1-1.10-3.el7.x86_64 gcc-4.8.2-3.el7.x86_64 gcc-c++-4.8.2-3.el7.x86_64 glibc-2.17-36.el7.i686 glibc-2.17-36.el7.x86_64 glibc-devel-2.17-36.el7.i686 glibc-devel-2.17-36.el7.x86_64 ksh libaio-0.3.109-9.el7.i686 libaio-0.3.109-9.el7.x86_64 libaio-devel-0.3.109-9.el7.i686 libaio-devel-0.3.109-9.el7.x86_64 libgcc-4.8.2-3.el7.i686 libgcc-4.8.2-3.el7.x86_64 libstdc++-4.8.2-3.el7.i686 libstdc++-4.8.2-3.el7.x86_64 libstdc++-devel-4.8.2-3.el7.i686 libstdc++-devel-4.8.2-3.el7.x86_64 libXi-1.7.2-1.el7.i686 libXi-1.7.2-1.el7.x86_64 libXtst-1.2.2-1.el7.i686 libXtst-1.2.2-1.el7.x86_64 make-3.82-19.el7.x86_64 sysstat-10.1.5-1.el7.x86_64 | kernel.shmall=2097152 kernle.shmmax=536870912 (Minimum) - Refer Note 567506.1 for more information kernel.sem = 250 32000 100 128 fs.file-max = 6815744 fs.aio-max-nr = 3145728 Note: This value limits concurrent outstanding requests and should be set to avoid I/O subsystem failures. 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=1048576 /etc/security/limits.conf oracle soft nproc 2047 oracle hard nproc 16384 oracle soft nofile 1024 oracle hard nofile 65536 oracle soft stack 10240 oracle hard stack 10240 |
OS Version | Patches/Packages | Kernel settings |
SUSE Linux Enterprise Server 11 SP2: 3.0.13-0.27 or later Reference : | binutils-2.21.1-0.7.25 (x86_64) glibc-2.11.3-17.31.1 (x86_64) ksh-93u-0.6.1 (x86_64) libaio-0.3.109-0.1.46 (x86_64) libstdc++33-3.3.3-11.9 (x86_64) libstdc++33-32bit-3.3.3-11.9 (x86_64) libstdc++46-4.6.1_20110701-0.13.9 (x86_64) libgcc46-4.6.1_20110701-0.13.9 (x86_64) make-3.81 (x86_64) gcc-4.3-62.198 (x86_64) gcc-c++-4.3-62.198 (x86_64) glibc-devel-2.11.3-17.31.1 (x86_64) libaio-devel-0.3.109-0.1.46 (x86_64) libstdc++43-devel-4.3.4_20091019-0.22.17 (x86_64) sysstat-8.1.5-7.32.1 (x86_64) libcap1-1.10-6.10 (x86_64) Some depended RPMS for above listed packages libstdc++-devel-4.3 (x86_64) | kernel.shmall = half the size of physical memory in pages (If the server supports multiple databases, or uses a large SGA, then set this parameter to a value that is equal to the total amount of shared memory, in 4K pages, that the system can use at one time.) kernel.shmmax = 1/2 of physical RAM in bytes. This would be the value 2147483648 for a system with 4Gb of physical RAM. (refer Note 567506.1 for additional information about configuring shmmax.) kernel.shmmni = 4096 kernel.sem = 250 32000 100 128 fs.file-max = 6815744 fs.aio-max-nr = 3145728 Note: This value limits concurrent outstanding requests and should be set to avoid I/O subsystem failures. 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 = 1048576 /etc/security/limits.conf oracle soft nproc 2047 oracle hard nproc 16384 oracle soft nofile 1024 oracle hard nofile 65536 oracle soft stack 10240 oracle hard stack 10240 |
OS Version | Patches/Packages | Kernel settings |
SUSE Linux Enterprise Server 12 SP1: 3.12.49-11 or later Reference : | binutils-2.25.0-13.1 gcc-4.8-6.189 gcc48-4.8.5-24.1 glibc-2.19-31.9 glibc-32bit-2.19-31.9 glibc-devel-2.19-31.9.x86_64 glibc-devel-32bit-2.19-31.9.x86_64 mksh-50-2.13 libaio1-0.3.109-17.15 libaio-devel-0.3.109-17.15 libcap1-1.10-59.61 libstdc++48-devel-4.8.5-24.1.x86_64 libstdc++48-devel-32bit-4.8.5-24.1.x86_64 libstdc++6-5.2.1+r226025-4.1.x86_64 libstdc++6-32bit-5.2.1+r226025-4.1.x86_64 libstdc++-devel-4.8-6.189.x86_64 libstdc++-devel-32bit-4.8-6.189.x86_64 libgcc_s1-5.2.1+r226025-4.1.x86_64 libgcc_s1-32bit-5.2.1+r226025-4.1.x86_64 make-4.0-4.1.x86_64 sysstat-10.2.1-3.1.x86_64 xorg-x11-driver-video-7.6_1-14.30.x86_64 xorg-x11-server-7.6_1.15.2-36.21.x86_64 xorg-x11-essentials-7.6_1-14.17.noarch xorg-x11-Xvnc-1.4.3-7.2.x86_64 xorg-x11-fonts-core-7.6-29.45.noarch xorg-x11-7.6_1-14.17.noarch xorg-x11-server-extra-7.6_1.15.2-36.21.x86_64 xorg-x11-libs-7.6-45.14.noarch xorg-x11-fonts-7.6-29.45.noarch | kernel.shmall = half the size of physical memory in pages (If the server supports multiple databases, or uses a large SGA, then set this parameter to a value that is equal to the total amount of shared memory, in 4K pages, that the system can use at one time.) kernel.shmmax = 1/2 of physical RAM in bytes. This would be the value 2147483648 for a system with 4Gb of physical RAM. (refer Note 567506.1 for additional information about configuring shmmax.) kernel.shmmni = 4096 kernel.sem = 250 32000 100 128 fs.file-max = 6815744 fs.aio-max-nr = 3145728 Note: This value limits concurrent outstanding requests and should be set to avoid I/O subsystem failures. 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 = 1048576 /etc/security/limits.conf oracle soft nproc 2047 oracle hard nproc 16384 oracle soft nofile 1024 oracle hard nofile 65536 oracle soft stack 10240 oracle hard stack 10240
/sbin/chkconfig boot.sysctl on ;
GID of the oinstall group (in this example GID=500). Grants members of oinstall a group permission to create shared memory segments
vm.hugetlb_shm_group=501 ; |
OS Version | Patches/Packages | Kernel settings |
Oracle Solaris 10 Update 11 (Oracle Solaris 10 1/13 s10s_u11wos_24a) or later updates Reference : | SUNWarc SUNWbtool SUNWcsl SUNWdtrc SUNWeu8os SUNWhea SUNWi1cs (ISO8859-1) SUNWi15cs (ISO8859-15) SUNWi1of SUNWlibC SUNWlibm SUNWlibms SUNWsprot SUNWtoo SUNWxwfnt 147440-25 147441-25 For Oracle C++, Oracle C++ Call Interface, Pro*C/C++, Oracle XML Developer's Kit (XDK) -- Oracle Solaris Studio 12 (formerly Sun Studio) September 2007 Release. For Pro*COBOL -- Micro Focus Server Express 5. For Pro*FORTRAN -- Oracle Solaris Studio 12 (Fortran 95) | project.max-sem-ids 100 process.max-sem-nsems 256 project.max-shm-memory - This value varies according to the RAM size project.max-shm-ids 100 tcp_smallest_anon_port 9000 tcp_largest_anon_port 65500 udp_smallest_anon_port 9000 udp_largest_anon_port 65500 Please note that "project.max-shm-memory" represent the maximum shared memory available for a project, so the value for this parameter should be greater than sum of all SGA sizes. Shell limits STACK at most 10240 (soft limit), at most 32768 (hard limit) NOFILES at least 1024 (soft limit), at least 65536 (hard limit) MAXUPRC or MAXPROC at least 2047 (soft limit), at least 16384 (hard limit) |
OS Version | Patches/Packages | Kernel settings |
Oracle Solaris 11 operating system. Oracle Solaris 11 SRU 7.5 or later SRUs and updates (for Oracle database 12.1.0.1.0) Oracle Solaris 11 operating system. Oracle Solaris 11 SRU 14.5 or later SRUs and updates (for Oracle databse 12.1.0.2.0) Reference : | pkg://solaris/system/dtrace pkg://solaris/developer/assembler pkg://solaris/developer/build/make pkg://solaris/system/xopen/xcu4 (if not already installed as part of standard Oracle Solaris 11 installation) pkg://solaris/x11/diagnostic/x11-info-clients pkg://solaris/compress/unzip For Oracle C++, Oracle C++ Call Interface, Pro*C/C++, Oracle XML Developer's Kit (XDK) -- Oracle Solaris Studio 12 (formerly Sun Studio) September 2007 Release. For Pro*COBOL -- Micro Focus Server Express 5. For Pro*FORTRAN -- Oracle Solaris Studio 12 (Fortran 95) | project.max-sem-ids 100 process.max-sem-nsems 256 project.max-shm-memory - This value varies according to the RAM size project.max-shm-ids 100 tcp_smallest_anon_port 9000 tcp_largest_anon_port 65500 udp_smallest_anon_port 9000 udp_largest_anon_port 65500 Please note that "project.max-shm-memory" represent the maximum shared memory available for a project, so the value for this parameter should be greater than sum of all SGA sizes. Shell limits STACK at most 10240 (soft limit), at most 32768 (hard limit) NOFILES at least 1024 (soft limit), at least 65536 (hard limit) MAXUPRC or MAXPROC at least 2047 (soft limit), at least 16384 (hard limit) |
OS Version | Patches/Packages | Kernel settings |
AIX 6.1 Technology Level 7 Service Pack 3 ("6100-07-03-1207") or later, 64-bit kernel Note: You can install on AIX 6.1 Technology Level 7, but Oracle recommends that you install on AIX 6.1 Technology Level 9 or later. AIX 7.1 Technology Level 1 Service Pack 3 ("7100-01-03-1207") or later, 64-bit kernel Note: You can install on AIX 7.1 Technology Level 1, but Oracle recommends that you install on AIX 7.1 Technology Level 3 or later. | bos.adt.base bos.adt.lib bos.adt.libm bos.perf.libperfstat bos.perf.perfstat bos.perf.proctools xlC.aix61.rte:11.1.0.4 or later xlC.rte.11.1.0.4 or later If you are using the minimum operating system TL level for AIX 6.1 listed above, then install all the following AIX APAR fixes: IV16716, IV20880, IV21128, IV28319, IV30712, IV33433, IV34685, IV39104, IV45072, IV45073 If you are using the minimum operating system TL level for AIX 7.1 listed above, then install all the following AIX APAR fixes: IV16737, IV21116, IV21235, IV28925, IV34869, IV35057, IV39136, IV41415, IV45072, IV45073 Note: APAR number may vary according to TL / SP level, please contact IBM for exact APAR number for your OS TL/SP version. For Oracle C++, Oracle C++ Call Interface, Pro*C/C++, Oracle XML Developer's Kit (XDK) – Install IBM XL C/C++ Enterprise Edition for AIX, V11.1 (11.1.0.9) January 2012 PTF. IBM XL C++ Runtime for AIX, V11.1 (11.1.0.4) November 2011. For Pro*COBOL - IBM COBOL for AIX Version 4.1.1 (March 2012 PTF), Micro Focus Server Express 5.1 For Pro*FORTRAN - IBM XL Fortran Runtime for AIX, Version 13.1, January 2012 PTF For ADA - OC Systems PowerAda 5.5 | Set the port range high enough to avoid reserved ports for any applications you may intend to use. If the lower value of the range you have is greater than 9000, and the range is large enough for your anticipated workload, then you can ignore OUI warnings regarding the ephemeral port range. tcp_ephemeral_low = 32768 tcp_ephemeral_high = 65535 udp_ephemeral_low = 32768 udp_ephemeral_high = 65535 Shell limits Soft File Descriptors at least 1024 Hard File Descriptors at least 65536 Soft FILE size -1 (Unlimited) Soft CPU time -1 (Unlimited) Soft DATA segment -1 (Unlimited) Soft STACK size -1 (Unlimited) Soft Real Memory size -1 (Unlimited) Processes (per user) -1 (Unlimited) Note: This limit is available only in AIX 6.1 or later. maxuprocs 16384 ncargs 128 IOCP : On IBM AIX on POWER Systems (64-Bit), enable I/O completion ports (IOCP) to ensure successful database and grid infrastructure installation. Use smitty iocp to change the characteristics to "Available". After modifying this parameter reboot the system. |
AIX7.2 | ||
OS Version | Patches/Packages | Kernel settings |
AIX 7.2 Technology Level 0 Service Pack 1 ("7200-00-01") or later, 64-bit kernel Note: Service Pack 1 is mandatory. | The following operating system filesets are required: bos.adt.base bos.adt.lib bos.adt.libm bos.perf.libperfstat bos.perf.perfstat bos.perf.proctools xlC.aix61.rte.13.1.2.0 or later xlC.rte.13.1.2.0 or later The following, or later, patches are required: If you are using the minimum operating system TL level for AIX 7.2 listed above, then install all the following AIX APAR fixes: IV79639 - after live update ifix state may be left as Q; rebooth required IV79848 - mirrorvg/syncvg on minimal and migration install fails IV80412 - system crash application sets signal mask Note: Install IV80412m1a as it includes the required fix for IV79441 - possible system crash using procfs to read 32bit process map fil. Oracle C++ Oracle C++ Call Interface Pro*C/C++ Oracle XML Developer's Kit (XDK) - Install IBM XL C/C++ Enterprise Edition for AIX, V11.1 (11.1.0.9) January 2012 PTF. IBM XL C++ Runtime for AIX, V11.1 (11.1.0.4) November 201 Pro*COBOL - IBM COBOL for AIX Version 4.1.1 (March 2012 PTF) Micro Focus Server Express 5.1 Pro*FORTRAN - IBM XL Fortran Runtime for AIX, Version 13.1, January 2012 PTF ADA - OC Systems PowerAda 5.5 For more information about OC Systems and PowerAda, go to: | tcp_ephemeral_low = 32768 tcp_ephemeral_high = 65500 udp_ephemeral_low = 32768 udp_ephemeral_high = 65500 Shell limits Soft File Descriptors at least 1024 Hard File Descriptors at least 65536 Number of processes (Soft) at least 2047 Number of processes (Hard) at least 16384 Soft STACK size at least 10240 KB Hard STACK size at least 10240 KB; at most 32768 KB Soft FILE size unlimited Soft CPU time unlimited Note: This is the default value. Soft DATA segment unlimited Soft Real Memory size unlimited maxuprocs 16384 ncargs 128 On IBM AIX on POWER Systems (64-Bit), enable I/O completion ports (IOCP) to ensure successful database and grid infrastructure installation. |
OS Version | Patches/Packages | Kernel settings |
HP-UX 11i V3 patch Bundle Sep/ 2008 (B.11.31.0809.326a) or higher | The following patches for HP-UX 11.31 must be installed : PHCO_43503, PHKL_38038, PHKL_38938, PHKL_40941, PHSS_36354, PHSS_37042, PHSS_37959, PHSS_38141, PHSS_39094, PHSS_39100, PHSS_39102 Oracle ODBC driver on HP-UX Itanium is certified with ODBC Driver Manager 2.3.1. To use ODBC, you must also install gcc 4.2.3 or later. Download and install the ODBC Driver from the following website: For Oracle C++, Oracle C++ Call Interface, Pro*C/C++, Oracle XML Developer's Kit (XDK) – Install Compiler Version: A.06.20 (HP C/aC++ Swlist Bundle - C.11.31.04) - Sep 2008. Patch for HP-UX 11i V3 (11.31) on HP-UX Itanium: PHSS_39824, PHSS_39826 Additional patches may be needed depending on applications you deploy. For Pro*COBOL - Micro Focus Server Express 5.1 For Pro*FORTRAN - HP FORTRAN/90 - Sep 2008 - release If you have VERITAS File System then install PHKL_39773 | Fixup scripts are provide during installation, these scripts checks and sets the kernel parameter to required values for successful installation. In case if you cannot execute fix up script you need to set to vaules greater than or equal to minimum values given here executable_stack 0 ksi_alloc_max 32768 max_thread_proc 1024 maxdsiz 1073741824 (1 GB) maxdsiz_64bit 2147483648 (2 GB) maxfiles 1024 maxfiles_lim 32767 maxssiz 134217728 (128 MB) maxssiz_64bit 1073741824 (1 GB) maxuprc 3686 msgmni 4096 msgtql 4096 ncsize 35840 nflocks 4096 ninode 34816 nkthread 7184 nproc 4096 semmni 4096 semmns 8192 semmnu 4092 semvmx 32767 shmmax 1073741824 shmmni 4096 shmseg 512 tcp_largest_anon_port 65500 udp_largest_anon_port 65500 The following kernel parameters are obsolete on HP-UX 11.31. Do not specify values for these parameters: tcp_smallest_anon_port udp_smallest_anon_port msgmap msgseg |
OS Version | Patches/Packages | Kernel settings |
Oracle Database for Windows x64 is supported on the following operating systems: Windows Server 2008 x64 and Windows Server 2008 R2 x64 - Standard, Enterprise, Datacenter, Web, and Foundation editions. Windows Server 2012 x64 - Standard, Datacenter, Essentials, and Foundation editions Windows 7 x64 - Professional, Enterprise, and Ultimate editions Windows 8 x64 - Pro and Enterprise editions | Pro*COBOL has been tested and certified with Net Express 5.1. The following components are supported with the Microsoft Visual C++ 2010 SP1 and Intel 12.1 C compilers: Oracle Call Interface External callouts Pro*C/C++ XDK Oracle C++ Call Interface is supported with Microsoft Visual C++ 2010 SP1 Intel 12.1 C compilers with Microsoft Visual Studio 2010 STLs Microsoft Visual C++ 2012 - OCCI libraries are installed under ORACLE_HOME\oci\lib\msvc\vc11. When developing OCCI applications with MSVC++ 2012, ensure that the OCCI libraries are correctly selected from this directory for linking and executing. The Oracle Net foundation layer uses Oracle protocol support to communicate with the following industry-standard network protocols: TCP/IP TCP/IP with SSL Named Pipes | - NA - |
OS Version | Patches/Packages | Kernel settings |
AIX 6.1 Technology Level 9 Service Pack 4 ("6100-09-04-1441") or later, 64-bit kernel AIX 7.1 Technology Level 3 Service Pack 4 ("7100-03-04-1441") or later, 64-bit kernel | bos.adt.base bos.adt.lib bos.adt.libm bos.perf.libperfstat bos.perf.perfstat bos.perf.proctools security.pkcs11 7.1.4.30 xlC.aix61.rte:13.1.0.1 or later xlC.rte:13.1.0.1 or later Download and install the APAR that matches your AIX versions and Technology Levels from the IBM fix central website at the following URL: https://www.ibm.com/ For Oracle C++, Oracle C++ Call Interface, Pro*C/C++, Oracle XML Developer's Kit (XDK) install IBM XL C++ Runtime for AIX v13.1 (13.1.0.0) IBM XL C/C++ for AIX v13.1 (13.1.0.1) December 2014 PTF Download this software from the following URLs: http://www-01.ibm.com/support/docview.wss?uid=swg24031864 http://www-01.ibm.com/support/docview.wss?uid=swg24031426 For Pro*COBOL - IBM COBOL for AIX version 4.1.1, Fix Pack 12, (October 2014 PTF) Micro Focus Server Express 5.1 Micro Focus Visual COBOL for Eclipse 2.2 - Update 2 For Pro*FORTRAN - IBM XL Fortran Runtime for AIX, Version 15.1, September 2014 PTF IBM XL Fortran for AIX, Version 15.1, September 2014 PTF | Ensure that the lower range is set to at least 9000 or higher, to avoid Well Known ports, and to avoid ports in the Registered Ports range commonly used by Oracle and other server ports. Set the port range high enough to avoid reserved ports for any applications you may intend to use. If the lower value of the range you have is greater than 9000, and the range is large enough for your anticipated workload, then you can ignore OUI warnings regarding the ephemeral port range. tcp_ephemeral_low = 32768 tcp_ephemeral_high = 65500 udp_ephemeral_low = 32768 udp_ephemeral_high = 65500 Shell limits Soft File Descriptors at least 1024 Hard File Descriptors at least 65536 Soft FILE size -1 (Unlimited) Soft CPU time -1 (Unlimited) Soft DATA segment -1 (Unlimited) Soft STACK size at least 10240 KB Hard STACK size at least 10240 KB; at most 32768 KB Soft Real Memory size -1 (Unlimited) Number of processes (Soft) at least 2047 Number of processes (Hard) at least 16384 maxuprocs 16384 ncargs 128 IOCP : On IBM AIX on POWER Systems (64-Bit), enable I/O completion ports (IOCP) to ensure successful database and grid infrastructure installation. Use smitty iocp to change the characteristics to "Available". After modifying this parameter reboot the system. |
AIX7.2 | ||
OS Version | Patches/Packages | Kernel settings |
AIX 7.2 Technology Level 0 Service Pack 1 ("7200-00-00-0000") or later, 64-bit kernel | The following operating system filesets are required: bos.adt.base bos.adt.lib bos.adt.libm bos.perf.libperfstat bos.perf.perfstat bos.perf.proctools xlC.aix61.rte:13.1.0.1 or later xlC.rte:13.1.0.1 or later Download and install the APAR that matches your AIX versions and Technology Levels from the IBM fix central website at the following URL: https://www.ibm.com/ For Oracle C++, Oracle C++ Call Interface, Pro*C/C++, Oracle XML Developer's Kit (XDK) install IBM XL C++ Runtime for AIX v13.1 (13.1.0.0) IBM XL C/C++ for AIX v13.1 (13.1.0.1) December 2014 PTF Download this software from the following URLs: http://www-01.ibm.com/support/docview.wss?uid=swg24031864 http://www-01.ibm.com/support/docview.wss?uid=swg24031426 For Pro*COBOL - IBM COBOL for AIX version 4.1.1, Fix Pack 12, (October 2014 PTF) Micro Focus Server Express 5.1 Micro Focus Visual COBOL for Eclipse 2.2 - Update 2 For Pro*FORTRAN - IBM XL Fortran Runtime for AIX, Version 15.1, September 2014 PTF IBM XL Fortran for AIX, Version 15.1, September 2014 PTF | Ensure that the lower range is set to at least 9000 or higher, to avoid Well Known ports, and to avoid ports in the Registered Ports range commonly used by Oracle and other server ports. Set the port range high enough to avoid reserved ports for any applications you may intend to use. If the lower value of the range you have is greater than 9000, and the range is large enough for your anticipated workload, then you can ignore OUI warnings regarding the ephemeral port range. tcp_ephemeral_low = 32768 tcp_ephemeral_high = 65500 udp_ephemeral_low = 32768 udp_ephemeral_high = 65500 Shell limits Soft File Descriptors at least 1024 Hard File Descriptors at least 65536 Soft FILE size -1 (Unlimited) Soft CPU time -1 (Unlimited) Soft DATA segment -1 (Unlimited) Soft STACK size at least 10240 KB Hard STACK size at least 10240 KB; at most 32768 KB Soft Real Memory size -1 (Unlimited) Number of processes (Soft) at least 2047 Number of processes (Hard) at least 16384 maxuprocs 16384 ncargs 128 IOCP : On IBM AIX on POWER Systems (64-Bit), enable I/O completion ports (IOCP) to ensure successful database and grid infrastructure installation. Use smitty iocp to change the characteristics to "Available". After modifying this parameter reboot the system. |
SLES 12 | ||
OS Version | Patches/Packages | Kernel settings |
The following operating system filesets are required: binutils-2.24-2.165.x86_64 gcc-c++-32bit-4.8-6.189.x86_64 gcc-c++-4.8-6.189.x86_64 gcc48-c++-4.8.3+r212056-6.3.x86_64 gcc-32bit-4.8-6.189.x86_64 gcc-4.8-6.189.x86_64 gcc-info-4.8-6.189.x86_64 gcc-locale-4.8-6.189.x86_64 gcc48-32bit-4.8.3+r212056-6.3.x86_64 gcc48-4.8.3+r212056-6.3.x86_64 gcc48-info-4.8.3+r212056-6.3.noarch gcc48-locale-4.8.3+r212056-6.3.x86_64 glibc-2.19-17.72.x86_64 glibc-devel-2.19-17.72.x86_64 libaio-devel-0.3.109-17.15.x86_64 libaio1-0.3.109-17.15.x86_64 libaio1-32bit-0.3.109-17.15.x86_64 libgfortran3-4.8.3+r212056-6.3.x86_64 libX11-6-1.6.2-4.12.x86_64 libX11-6-32bit-1.6.2-4.12.x86_64 libXau6-1.0.8-4.58.x86_64 libXau6-32bit-1.0.8-4.58.x86_64 libXtst6-1.2.2-3.60.x86_64 libXtst6-32bit-1.2.1-2.4.1.x86_64 libcap-ng-utils-0.7.3-4.125.x86_64 libcap-ng0-0.7.3-4.125.x86_64 libcap-ng0-32bit-0.7.3-4.125.x86_64 libcap-progs-2.22-11.709.x86_64 libcap1-1.10-59.61.x86_64 libcap1-32bit-1.10-59.61.x86_64 libcap2-2.22-11.709.x86_64 libcap2-32bit-2.22-11.709.x86_64 libgcc_s1-32bit-4.8.3+r212056-6.3.x86_64 libgcc_s1-4.8.3+r212056-6.3.x86_64 libpcap1-1.5.3-2.18.x86_64 libstdc++6-32bit-4.8.3+r212056-6.3.x86_64 libstdc++6-4.8.3+r212056-6.3.x86_64 make-4.0-2.107.x86_64 mksh-50-2.13.x86_64 net-tools-1.60-764.185.x86_64 (for Oracle RAC and Oracle Clusterware) nfs-kernel-server-1.3.0-6.9.x86_64 (for Oracle ACFS) smartmontools-6.2-4.33.x86_64 sysstat-8.1.5-7.32.1.x86_64 xorg-x11-libs-7.6-45.14 Ensure that OpenSSH is installed on your servers. OpenSSH is the required SSH software. For Oracle C++, Pro*C/C++, Oracle C++ Call Interface, Oracle XML Developer's Kit (XDK) - Intel C/C++ Compiler 12.0.5 or later, and the version of GNU C and C++ compilers listed in the software requirements section in this document for your platform. - Oracle C++ Call Interface (OCCI) applications can be built only with Intel C++ Compiler 12.0.5 used with the standard template libraries of the gcc versions listed in the software requirements section in this document for your platform. For Pro*COBOL Micro Focus Server Express 5.1 Micro Focus Visual COBOL for Eclipse 2.2 - Update 2 | Add following lines in /etc/sysctl.conf file fs.aio-max-nr = 1048576 fs.file-max = 6815744 kernel.shmall = 2097152 kernel.shmmax = 4294967295 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 = 1048576 Additional kernel parameter settings configuration is required on SUSE Linux Enterprise Server systems. Enter the following command to enable the system to read the /etc/sysctl.conf file when it restarts: # /sbin/chkconfig boot.sysctl on Enter the GID of the oinstall group as the value for the parameter /proc/sys/vm/hugetlb_shm_group. For example, where the oinstall group GID is 501: # echo 501 > /proc/sys/vm/hugetlb_shm_group Use vi to add the following text to /etc/sysctl.conf, and enable the boot.sysctl script to run on system restart: vm.hugetlb_shm_group=501 Shell limits Soft File Descriptors at least 1024 Hard File Descriptors at least 65536 Soft FILE size -1 (Unlimited) Soft CPU time -1 (Unlimited) Soft DATA segment -1 (Unlimited) Soft STACK size -1 (Unlimited) Number of processes (Soft) at least 2047 Number of processes (Hard) at least 16384 maxuprocs 16384 |
Solaris 11 | ||
OS Version | Patches/Packages | Kernel settings |
Oracle Solaris 11.2 SRU 5.5 (Oracle Solaris 11.2.5.5.0) or later SRUs and updates Reference: | The following operating system packages are required: pkg://solaris/system/library/openmp pkg://solaris/compress/unzip pkg://solaris/developer/assembler pkg://solaris/developer/build/make pkg://solaris/system/dtrace pkg://solaris/system/header pkg://solaris/system/kernel/oracka (Only for Oracle Real Application Clusters installations) pkg://solaris/system/library pkg://solaris/system/linker pkg://solaris/system/xopen/xcu4 (If not already installed as part of standard Oracle Solaris 11 installation) pkg://solaris/x11/diagnostic/x11-info-clients Note: Starting with Oracle Solaris 11.2, if you have installed the Oracle Database prerequisites group package oracle-rdbms-server-12-1-preinstall, then you do not have to install these packages, as oracle-rdbms-server-12-1-preinstall installs them for you. Secure Shell is configured at installation for Oracle Solaris. For Oracle C++, Pro*C/C++, Oracle C++ Call Interface, Oracle XML Developer's Kit (XDK) - Oracle Solaris Studio 12.4 (formerly Sun Studio) PSE 4/15/2015. - 124863-12 C++ 5.9 compiler. - 124864-12 C++ 5.9 Compiler Download Oracle Solaris Studio from the following URL: C Compiler Patches 118683-14 Oracle Solaris Studio 12.4 patch for Oracle Solaris on SPARC 119961-15 Oracle Solaris Studio 12.4 patch for Oracle Solaris on x86-64 (64-bit) 124861-15 Compiler Common patch for Sun C C++ F77 F95 126498-15 Compiler Common patch for Sun C C++ F77 F95 124867-11 C 5.9 Compiler 124868-10 C 5.9 Compiler 126495 Debuginfo Handling 126496-02 Debuginfo Handling 139556-08 For Pro*COBOL Micro Focus Server Express 5.1 Micro Focus Visual COBOL for Eclipse 2.2 - Update 2 Pro*FORTRAN Oracle Solaris Studio 12 (Fortran 95) | Default values smallest_anon_port 32768-65535 largest_anon_port 65500-65535 If necessary for your anticipated workload or number of servers , update the UDP and TCP ephemeral port range to a broader range. smallest_anon_port=9000 tcp largest_anon_port=65500 tcp smallest_anon_port=9000 udp largest_anon_port=65500 udp Shell limits STACK at most 10240(Soft limit) at most 32768 (Hard limit) NOFILES at least 1024 (Soft limit) at least 65536(Hard limit) MAXUPRC or MAXPROC at least 2047(Soft limit) at least 16384 (Hard limit) |
Solaris 10 | ||
OS Version | Patches/Packages | Kernel settings |
Oracle Solaris 10 Update 11 (Oracle Solaris 10 1/13 s10s_u11wos_24a) or later updates | The following operating system packages are required: SUNWdtrc SUNWeu8os SUNWi1cs (ISO8859-1) SUNWi15cs (ISO8859-15) 118683-13 119963-33 120753-14 147440-25 148506-12 148917-06 Note: You may also require additional font packages for Java, depending on your locale. Refer to the following URL: Secure Shell is configured at installation for Oracle Solaris. For Oracle C++, Pro*C/C++, Oracle C++ Call Interface, Oracle XML Developer's Kit (XDK) - Oracle Solaris Studio 12.4 (formerly Sun Studio) PSE 4/15/2015. - 124863-12 C++ 5.9 compiler. - 124864-12 C++ 5.9 Compiler Download Oracle Solaris Studio from the following URL: C Compiler Patches 118683-14 Oracle Solaris Studio 12.4 patch for Oracle Solaris on SPARC 119961-15 Oracle Solaris Studio 12.4 patch for Oracle Solaris on x86-64 (64-bit) 124861-15 Compiler Common patch for Sun C C++ F77 F95 126498-15 Compiler Common patch for Sun C C++ F77 F95 124867-11 C 5.9 Compiler 124868-10 C 5.9 Compiler 126495 Debuginfo Handling 126496-02 Debuginfo Handling 139556-08 For Pro*COBOL Micro Focus Server Express 5.1 Micro Focus Visual COBOL for Eclipse 2.2 - Update 2 Pro*FORTRAN Oracle Solaris Studio 12 (Fortran 95) | Default values tcp_smallest_anon_port 32768 tcp_largest_anon_port 65535 If necessary for your anticipated workload or number of servers , update the UDP and TCP ephemeral port range to a broader range. tcp_smallest_anon_port 9000 tcp_largest_anon_port 65500 udp_smallest_anon_port 9000 udp_largest_anon_port 65500 Shell limits STACK - at most 10240(Soft limit) at most 32768 (Hard limit) NOFILES - at least 1024 (Soft limit) at least 65536(Hard limit) MAXUPRC or MAXPROC - at least 2047(Soft limit) at least 16384 (Hard limit) |
Oracle Linux 7/RHEL 7 | ||
OS Version | Patches/Packages | Kernel settings |
Oracle Linux 7 with the Unbreakable Enterprise Kernel 3: 3.8.13-35.3.1.el7uek.x86_64 or later Oracle Linux 7.2 with the Unbreakable Enterprise Kernel 4: 4.1.12-32.2.3.el7uek.x86_64 or later Oracle Linux 7 with the Red Hat Compatible kernel: 3.10.0-123.el7.x86_64 or later Red Hat Enterprise Linux 7: 3.10.0-123.el7.x86_64 or later Reference : | binutils-2.23.52.0.1-12.el7 (x86_64) compat-libcap1-1.10-3.el7 (x86_64) compat-libstdc++-33-3.2.3-71.el7 (i686) compat-libstdc++-33-3.2.3-71.el7 (x86_64) glibc-2.17-36.el7 (i686) glibc-2.17-36.el7 (x86_64) glibc-devel-2.17-36.el7 (i686) glibc-devel-2.17-36.el7 (x86_64) ksh libaio-0.3.109-9.el7 (i686) libaio-0.3.109-9.el7 (x86_64) libaio-devel-0.3.109-9.el7 (i686) libaio-devel-0.3.109-9.el7 (x86_64) libX11-1.6.0-2.1.el7 (i686) libX11-1.6.0-2.1.el7 (x86_64) libXau-1.0.8-2.1.el7 (i686) libXau-1.0.8-2.1.el7 (x86_64) libXi-1.7.2-1.el7 (i686) libXi-1.7.2-1.el7 (x86_64) libXtst-1.2.2-1.el7 (i686) libXtst-1.2.2-1.el7 (x86_64) libgcc-4.8.2-3.el7 (i686) libgcc-4.8.2-3.el7 (x86_64) libstdc++-4.8.2-3.el7 (i686) libstdc++-4.8.2-3.el7 (x86_64) libstdc++-devel-4.8.2-3.el7 (i686) libstdc++-devel-4.8.2-3.el7 (x86_64) libxcb-1.9-5.el7 (i686) libxcb-1.9-5.el7 (x86_64) make-3.82-19.el7 (x86_64) nfs-utils-1.3.0-0.21.el7.x86_64 (for Oracle ACFS) net-tools-2.0-0.17.20131004git.el7 (x86_64) (for Oracle RAC and Oracle Clusterware) smartmontools-6.2-4.el7 (x86_64) sysstat-10.1.5-1.el7 (x86_64) Ensure that OpenSSH is installed on your servers. OpenSSH is the required SSH software. | semmsl 250 semmns 32000 semopm 100 semmni 128 shmall 40 percent of the size of physical memory in pages shmmax Half the size of physical memory in bytes shmmni 4096 panic_on_oops 1 file-max 6815744 aio-max-nr 1048576 ip_local_port_range Minimum: 9000 Maximum: 65500 rmem_default 262144 rmem_max 4194304 wmem_default 262144 wmem_max 1048576 ip_local_port_range 32768 61000 /etc/security/limits.conf oracle soft nproc 2047 (at least) oracle hard nproc 16384 (at least) oracle soft nofile 1024 (at least) oracle hard nofile 65536 (at least) oracle soft stack 10240 KB (at least) oracle hard stack 32768 KB (at most) memlock Soft: at least 90 percent of the current RAM when HugePages memory is enabled and at least 3145728 KB (3 GB) when HugePages memory is disabled hard: at least 90 percent of the current RAM when HugePages memory is enabled and at least 3145728 KB (3 GB) when HugePages memory is disabled |
Oracle Linux 6/RHEL 6 | ||
OS Version | Patches/Packages | Kernel settings |
Oracle Linux 6.4 with the Unbreakable Enterprise Kernel 2: 2.6.39-400.211.1.el6uek.x86_64 or later Oracle Linux 6.6 with the Unbreakable Enterprise Kernel 3: 3.8.13-44.1.1.el6uek.x86_64 or later Oracle Linux 6.8 with the Unbreakable Enterprise Kernel 4: 4.1.12-37.6.2.el6uek.x86_64 or later Oracle Linux 6.4 with the Red Hat Compatible kernel: 2.6.32-358.el6.x86_64 or later Red Hat Enterprise Linux 6.4: 2.6.32-358.el6.x86_64 or later Reference : | binutils-2.20.51.0.2-5.36.el6 (x86_64) compat-libcap1-1.10-1 (x86_64) compat-libstdc++-33-3.2.3-69.el6 (x86_64) compat-libstdc++-33-3.2.3-69.el6 (i686) e2fsprogs-1.41.12-14.el6 (x86_64) e2fsprogs-libs-1.41.12-14.el6 (x86_64) glibc-2.12-1.7.el6 (i686) glibc-2.12-1.7.el6 (x86_64) glibc-devel-2.12-1.7.el6 (x86_64) glibc-devel-2.12-1.7.el6 (i686) ksh libgcc-4.4.4-13.el6 (i686) libgcc-4.4.4-13.el6 (x86_64) libstdc++-4.4.4-13.el6 (x86_64) libstdc++-4.4.4-13.el6 (i686) libstdc++-devel-4.4.4-13.el6 (x86_64) libstdc++-devel-4.4.4-13.el6 (i686) libaio-0.3.107-10.el6 (x86_64) libaio-0.3.107-10.el6 (i686) libaio-devel-0.3.107-10.el6 (x86_64) libaio-devel-0.3.107-10.el6 (i686) libXtst-1.0.99.2 (x86_64) libXtst-1.0.99.2 (i686) libX11-1.5.0-4.el6 (i686) libX11-1.5.0-4.el6 (x86_64) libXau-1.0.6-4.el6 (i686) libXau-1.0.6-4.el6 (x86_64) libxcb-1.8.1-1.el6 (i686) libxcb-1.8.1-1.el6 (x86_64) libXi-1.3 (x86_64) libXi-1.3 (i686) make-3.81-19.el6 net-tools-1.60-110.el6_2.x86_64 (for Oracle RAC and Oracle Clusterware) nfs-utils-1.2.3-15.0.1 (for Oracle ACFS) sysstat-9.0.4-11.el6 (x86_64) smartmontools-5.43-1.el6.x86_64 For RHEL 6 you need have following RPM version along with the with metioned above libgcc-4.4.7-3.el6 (i686) libgcc-4.4.7-3.el6 (x86_64) libstdc++-4.4.7-3.el6 (i686) libstdc++-4.4.7-3.el6 (x86_64) libstdc++-devel-4.4.7-3.el6 (i686) libstdc++-devel-4.4.7-3.el6 (x86_64) Ensure that OpenSSH is installed on your servers. OpenSSH is the required SSH software. | semmsl 250 semmns 32000 semopm 100 semmni 128 shmall 40 percent of the size of physical memory in pages shmmax Half the size of physical memory in bytes shmmni 4096 panic_on_oops 1 file-max 6815744 aio-max-nr 1048576 ip_local_port_range Minimum: 9000 Maximum: 65500 rmem_default 262144 rmem_max 4194304 wmem_default 262144 wmem_max 1048576 ip_local_port_range 32768 61000 /etc/security/limits.conf oracle soft nproc 2047 (at least) oracle hard nproc 16384 (at least) oracle soft nofile 1024 (at least) oracle hard nofile 65536 (at least) oracle soft stack 10240 KB (at least) oracle hard stack 32768 KB (at most) memlock Soft: at least 90 percent of the current RAM when HugePages memory is enabled and at least 3145728 KB (3 GB) when HugePages memory is disabled hard: at least 90 percent of the current RAM when HugePages memory is enabled and at least 3145728 KB (3 GB) when HugePages memory is disabled |
HP-UX Itanium | ||
OS Version | Patches/Packages | Kernel settings |
HP-UX 11.31 September 2014 B.11.31.1409 or later. Reference : Note 2331139.1 | The following patches must be installed: PHCO_43503 - 11.31 diskowner(1M) cumulative patch PHKL_40941 - 11.31 scheduler cumulative patch PHKL_42916 - 11.31 SCSI cumulative I/O patch PHKL_42996 - 11.31 scheduler cumulative patch PHKL_43775 - 11.31 vm cumulative patch PHKL_44199 - 11.31 VRTS 5.0 MP1P13 VRTSvxfs Kernel Patch PHKL_44248 - 11.31 SCSI cumulative I/O patch PHKL_44417 - 11.31 vm cumulative patch PHKL_44565 - 11.31 vm cumulative patch PHSS_37042 - 11.31 hppac PHSS_39094 - 11.31 linker + fdp cumulative patch PHSS_39102 - 11.31 Integrity Unwind Library PHSS_40631 - 11.31 HP C/aC++ Compiler (A.06.24) PHSS_40633 - 11.31 u2comp/be/plugin (C.06.24) PHSS_42686 - 11.31 assembler patch PHSS_43205 - 11.31 Math Library Cumulative Patch PHSS_43291 - 11.31 X/Motif runtime patch PHSS_43733 - 11.31 LIBCL patch PHSS_43740 - 11.31 Integrity Unwind Library PHSS_43741 - 11.31 aC++ Runtime (IA: A.06.28, PA: A.03.90) PHSS_44164 - 11.31 linker + fdp cumulative patch PHSS_44402 - 11.31 linker + fdp cumulative patch Oracle ODBC driver on HP-UX Itanium is certified with ODBC Driver Manager 2.3.1 or later. To use ODBC, you must also install gcc 4.2.3 or later. Download and install the ODBC Driver from the following website: | executable_stack 0 ksi_alloc_max 32768 max_thread_proc 1024 maxdsiz 1073741824 (1 GB) maxdsiz_64bit 2147483648 (2 GB) maxfiles 1024 maxfiles_lim 63488 maxssiz 134217728 (128 MB) maxssiz_64bit 1073741824 (1 GB) maxuprc 3686 msgmni 4096 msgtql 4096 ncsize 35840 nflocks 4096 ninode 34816 nkthread 7184 nproc 4096 semmni 4096 semmns 8192 semmnu 4092 semvmx 32767 shmmax 1073741824 shmmni 4096 shmseg 512 tcp_largest_anon_port 65500 udp_largest_anon_port 65500 |
OS Version | Patches/Packages | Kernel settings |
Oracle Database for Windows x64 is supported on the following operating system versions: Windows 7 x64 - Professional, Enterprise, and Ultimate editions Windows 8 x64 and Windows 8.1 x64 - Pro and Enterprise editions Windows 8.1 x64 - Pro and Enterprise editions Windows 10 x64 - Pro, Enterprise, and Education editions Windows Server 2012 x64 - Standard, Datacenter, Essentials, and Foundation editions Windows Server 2012 R2 x64 - Standard, Datacenter, Essentials, and Foundation editions Windows Server 2016 x64 - Standard, Datacenter, and Essentials editions | The following components are supported with the Microsoft Visual C++ 2013 Update 4, Microsoft Visual C++ 2015 Update 3, and Intel 14.0 C compilers: Oracle Call Interface External callouts Pro*C/C++ Oracle XML Developer's Kit (XDK) Oracle C++ Call Interface supports: Microsoft Visual C++ 2013 Update 4 Microsoft Visual C++ 2015 Update 3 - OCCI libraries are installed under ORACLE_HOME\oci\lib\msvc\vc14. When developing OCCI applications with MSVC++ 2015, ensure that the OCCI libraries are correctly selected from this directory for linking and executing. Intel 14.0 C compilers with Microsoft Visual Studio 2013 STLs Pro*COBOL supports: Micro Focus Visual COBOL 2.2 - Update 2 The Oracle Net foundation layer uses Oracle protocol support to communicate with the following industry-standard network protocols: TCP/IP TCP/IP with SSL Named Pipes | - NA - |
Oracle Linux 6 | ||
OS Version | Patches/Packages | Kernel settings |
Oracle Linux 6.4 with the Unbreakable Enterprise Kernel 2: 2.6.39-400.211.1.el6uek.x86_64or later Oracle Linux 6.6 with the Unbreakable Enterprise Kernel 3: 3.8.13-44.1.1.el6uek.x86_64 or later Oracle Linux 6.8 with the Unbreakable Enterprise Kernel 4: 4.1.12-37.6.2.el6uek.x86_64 or later Oracle Linux 6.4 with the Red Hat Compatible kernel: 2.6.32-358.el6.x86_64 or later Reference: 2426831.1 | The following operating system filesets are required for Oracle Linux 6.4 with UEK2: bc binutils-2.20.51.0.2-5.36.el6 (x86_64) compat-libcap1-1.10-1 (x86_64) compat-libstdc++-33-3.2.3-69.el6 (x86_64) compat-libstdc++-33-3.2.3-69.el6 (i686) e2fsprogs-1.41.12-14.el6 (x86_64) e2fsprogs-libs-1.41.12-14.el6 (x86_64) glibc-2.12-1.7.el6 (i686) glibc-2.12-1.7.el6 (x86_64) glibc-devel-2.12-1.7.el6 (x86_64) glibc-devel-2.12-1.7.el6 (i686) ksh libaio-0.3.107-10.el6 (x86_64) libaio-0.3.107-10.el6 (i686) libaio-devel-0.3.107-10.el6 (x86_64) libaio-devel-0.3.107-10.el6 (i686) libX11-1.5.0-4.el6 (i686) libX11-1.5.0-4.el6 (x86_64) libXau-1.0.6-4.el6 (i686) libXau-1.0.6-4.el6 (x86_64) libXi-1.3 (i686) libXi-1.3 (x86_64) libXtst-1.0.99.2 (i686) libXtst-1.0.99.2 (x86_64) libXrender (i686) libXrender (x86_64) libXrender-devel (i686) libXrender-devel (x86_64) libgcc-4.4.4-13.el6 (i686) libgcc-4.4.4-13.el6 (x86_64) libstdc++-4.4.4-13.el6 (x86_64) libstdc++-4.4.4-13.el6 (i686) libstdc++-devel-4.4.4-13.el6 (x86_64) libstdc++-devel-4.4.4-13.el6 (i686) libxcb-1.8.1-1.el6 (i686) libxcb-1.8.1-1.el6 (x86_64) make-3.81-19.el6 (x86_64) net-tools-1.60-110.el6_2 (x86_64) (for Oracle RAC and Oracle Clusterware) nfs-utils-1.2.3-15.0.1 (for Oracle ACFS) smartmontools-5.43-1.el6 (x86_64) sysstat-9.0.4-11.el6 (x86_64) The following operating system filesets are required for Oracle Linux 6.6 with UEK3: bc binutils-2.20.51.0.2-5.42.el6.x86_64 compat-libcap1-1.10-1.x86_64 compat-libstdc++-33-3.2.3-69.el6 compat-libstdc++-33-3.2.3-69.el6.i686 glibc-2.12-1.149.el6.i686 glibc-2.12-1.149.el6.x86_64 glibc-devel-2.12-1.149.el6.i686 glibc-devel-2.12-1.149.el6.x86_64 ksh-20120801-21.el6.x86_64 libaio-0.3.107-10.el6.x86_64 libaio-0.3.107-10.el6.i686 libaio-devel-0.3.107-10.el6.x86_64 libaio-devel-0.3.107-10.el6.i686 libX11-1.5.0-4.el6.i686 libX11-1.5.0-4.el6.x86_64 libXau-1.0.6-4.el6.i686 libXau-1.0.6-4.el6.x86_64 libXi-1.7.2-2.2.el6.i686 libXi-1.7.2-2.2.el6.x86_64 libXtst-1.2.2-2.1.el6.i686 libXtst-1.2.2-2.1.el6.x86_64 libXrender (i686) libXrender (x86_64) libXrender-devel (i686) libXrender-devel (x86_64) libgcc-4.4.7-11.el6.i686 libgcc-4.4.7-11.el6.x86_64 libstdc++-4.4.7-11.el6.i686 libstdc++-4.4.7-11.el6.x86_64 libstdc++-devel-4.4.7-11.el6.i686 libstdc++-devel-4.4.7-11.el6.x86_64 libxcb-1.8.1-1.el6.i686 libxcb-1.8.1-1.el6.x86_64 make-3.81-20.el6.x86_64 nfs-utils-1.2.3-54.el6.x86_64 sysstat-9.0.4-27.el6.x86_64 The following operating system filesets are required for Oracle Linux 6.8 with UEK 4: bc binutils-2.20.51.0.2-5.44.el6.x86_64 compat-libcap1-1.10-1.x86_64 compat-libstdc++-33-3.2.3-69.el6.x86_64 compat-libstdc++-33-3.2.3-69.el6.i686 glibc-2.12-1.192.el6.i686 glibc-2.12-1.192.el6.x86_64 glibc-devel-2.12-1.192.el6.i686 glibc-devel-2.12-1.192.el6.x86_64 ksh-20120801-33.el6.x86_64 libaio-0.3.107-10.el6.x86_64 libaio-0.3.107-10.el6.i686 libaio-devel-0.3.107-10.el6.x86_64 libaio-devel-0.3.107-10.el6.i686 libX11-1.6.3-2.el6.i686 libX11-1.6.3-2.el6.x86_64 libXau-1.0.6-4.el6.i686 libXau-1.0.6-4.el6.x86_64 libXi-1.7.4-1.el6.i686 libXi-1.7.4-1.el6.x86_64 libXtst-1.2.2-2.1.el6.i686 libXtst-1.2.2-2.1.el6.x86_64 libgcc-4.4.7-17.el6.i686 libgcc-4.4.7-17.el6.x86_64 libstdc++-4.4.7-17.el6.i686 libstdc++-4.4.7-17.el6.x86_64 libstdc++-devel-4.4.7-17.el6.i686 libstdc++-devel-4.4.7-17.el6.x86_64 libxcb-1.11-2.el6.i686 libxcb-1.11-2.el6.x86_64 libXrender (i686) libXrender (x86_64) libXrender-devel (i686) libXrender-devel (x86_64) make-3.81-23.el6.x86_64 nfs-utils-1.2.3-70.0.1.el6.x86_64 sysstat-9.0.4-31.el6.x86_64 The following operating system filesets are required for Oracle Linux 6.4 with RHEL Compatible Kernel: bc binutils-2.20.51.0.2-5.36.el6.x86_64 compat-libcap1-1.10-1 (x86_64) compat-libstdc++-33-3.2.3-69.el6 (x86_64) compat-libstdc++-33-3.2.3-69.el6.i686 e2fsprogs-1.41.12-14.el6.x86_64 e2fsprogs-libs-1.41.12-14.el6.x86_64 glibc-2.12-1.107.el6.i686 glibc-2.12-1.107.el6.x86_64 glibc-devel-2.12-1.107.el6.i686 glibc-devel-2.12-1.107.el6.x86_64 ksh libaio-0.3.107-10.el6 (x86_64) libaio-0.3.107-10.el6.i686 libaio-devel-0.3.107-10.el6 (x86_64) libaio-devel-0.3.107-10.el6.i686 libX11-1.5.0-4.el6.i686 libX11-1.5.0-4.el6.x86_64 libXau-1.0.6-4.el6.i686 libXau-1.0.6-4.el6.x86_64 libXi-1.6.1-3.el6.i686 libXi-1.6.1-3.el6.x86_64 libXtst-1.2.1-2.el6.i686 libXtst-1.2.1-2.el6.x86_64 libXrender (i686) libXrender (x86_64) libXrender-devel (i686) libXrender-devel (x86_64) libgcc-4.4.7-3.el6.i686 libgcc-4.4.7-3.el6.x86_64 libstdc++-4.4.7-3.el6.i686 libstdc++-4.4.7-3.el6.x86_64 libstdc++-devel-4.4.7-3.el6.i686 libstdc++-devel-4.4.7-3.el6.x86_64 libxcb-1.8.1-1.el6.i686 libxcb-1.8.1-1.el6.x86_64 make-3.81-20.el6.x86_64 net-tools-1.60-110.el6_2.x86_64 (for Oracle RAC and Oracle Clusterware) nfs-utils-1.2.3-36.el6.x86_64 (for Oracle ACFS) smartmontools-5.43-1.el6.x86_64 sysstat-9.0.4-20.el6.x86_64 Ensure that OpenSSH is installed on your servers. OpenSSH is the required SSH software. For Oracle C++, Pro*C/C++, Oracle C++ Call Interface, Oracle XML Developer's Kit (XDK) - Intel C/C++ Compiler 14.0.3 or later, or the version of GNU C and C++ compilers listed in the software requirements section in this document for your platform. - Oracle C++ Call Interface (OCCI) applications can be built only with Intel C++ Compiler 14.0.3 used with the standard template libraries of the gcc versions listed in the software requirements section in this document for your platform. - Oracle XML Developer's Kit is supported with the same compilers as OCCI. For Pro*COBOL Micro Focus Server Express 5.1 Micro Focus Visual COBOL for Eclipse 2.2 - Update 2 | semmsl 250 semmns 32000 semopm 100 semmni 128 shmall Greater than or equal to the value of shmmax, in pages. shmmax Half the size of physical memory in bytes shmmni 4096 panic_on_oops 1 file-max 6815744 aio-max-nr 1048576 Note: This value limits concurrent outstanding requests and should be set to avoid I/O subsystem failures. ip_local_port_range Minimum: 9000 Maximum: 65500 rmem_default 262144 rmem_max 4194304 wmem_default 262144 wmem_max 1048576 Set values in the /etc/sysctl.d/97-oracle-database-sysctl.conf fs.aio-max-nr = 1048576 fs.file-max = 6815744 kernel.shmall = 2097152 kernel.shmmax = 4294967295 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 = 1048576 To change the current values of the kernel parameters: # /sbin/sysctl --system Note:
|
Oracle Linux 7 | ||
OS Version | Patches/Packages | Kernel settings |
Oracle Linux 7 with the Unbreakable Enterprise Kernel 3: 3.8.13-35.3.1.el7uek.x86_64 or later Oracle Linux 7.2 with the Unbreakable Enterprise Kernel 4: 4.1.12-32.2.3.el7uek.x86_64 or later Oracle Linux 7 with the Red Hat Compatible kernel: 3.10.0-123.el7.x86_64 or later Reference: 2426806.1 | The following operating system filesets are required for Oracle Linux 7 with UEK3: bc binutils-2.23.52.0.1-12.el7.x86_64 compat-libcap1-1.10-3.el7.x86_64 compat-libstdc++-33-3.2.3-71.el7.i686 compat-libstdc++-33-3.2.3-71.el7.x86_64 fontconfig-devel-2.10.95-7.el7.x86_64 ksh libX11-1.6.0-2.1.el7.i686 libX11-1.6.0-2.1.el7.x86_64 libXau-1.0.8-2.1.el7.i686 libXau-1.0.8-2.1.el7.x86_64 libXi-1.7.2-1.el7.i686 libXi-1.7.2-1.el7.x86_64 libXtst-1.2.2-1.el7.i686 libXtst-1.2.2-1.el7.x86_64 libXrender-devel-0.9.10-1.el7.i686 libXrender-devel-0.9.10-1.el7.x86_64 libXrender-0.9.10-1.el7.i686 libXrender-0.9.10-1.el7.x86_64 libgcc-4.8.2-3.el7.i686 libgcc-4.8.2-3.el7.x86_64 libstdc++-4.8.2-3.el7.i686 libstdc++-4.8.2-3.el7.x86_64 libstdc++-devel-4.8.2-3.el7.i686 libstdc++-devel-4.8.2-3.el7.x86_64 libxcb-1.9-5.el7.i686 libxcb-1.9-5.el7.x86_64 make-3.82-19.el7.x86_64 net-tools-2.0-0.17.20131004git.el7 (x86_64) (for Oracle RAC and Oracle Clusterware) nfs-utils-1.3.0-0.21.el7.x86_64 python-2.7.5-34.0.1.el7 (x86_64) (for Oracle ACFS Remote) python-configshell-1.1.fb18-1.el7.noarch (for Oracle ACFS Remote) python-rtslib-2.1.fb57-3.el7.noarch (for Oracle ACFS Remote) python-six-1.9.0-2.el7.noarch (for Oracle ACFS Remote) smartmontools-6.2-4.el7.x86_64 sysstat-10.1.5-1.el7.x86_64 targetcli-2.1.fb41-3.el7.noarch (for Oracle ACFS Remote) The following operating system filesets are required for Oracle Linux 7.2 with UEK4: bc binutils-2.23.52.0.1-55.el7.x86_64 compat-libcap1-1.10-3.el7.x86_64 compat-libstdc++-33-3.2.3-71.el7.i686 compat-libstdc++-33-3.2.3-71.el7.x86_64 elfutils-libelf-0.163-3.el7.i686 elfutils-libelf-0.163-3.el7.x86_64 elfutils-libelf-devel-0.163-3.el7.i686 elfutils-libelf-devel-0.163-3.el7.x86_64 fontconfig-devel-2.10.95-7.el7.x86_64 glibc-2.17-106.0.1.el7_2.6.i686 glibc-2.17-106.0.1.el7_2.6.x86_64 glibc-devel-2.17-106.0.1.el7_2.6.i686 glibc-devel-2.17-106.0.1.el7_2.6.x86_64 ksh libaio-0.3.109-13.el7.i686 libaio-0.3.109-13.el7.x86_64 libaio-devel-0.3.109-13.el7.i686 libaio-devel-0.3.109-13.el7.x86_64 libX11-1.6.3-2.el7.i686 libX11-1.6.3-2.el7.x86_64 libXau-1.0.8-2.1.el7.i686 libXau-1.0.8-2.1.el7.x86_64 libXi-1.7.4-2.el7.i686 libXi-1.7.4-2.el7.x86_64 libXtst-1.2.2-2.1.el7.i686 libXtst-1.2.2-2.1.el7.x86_64 libXrender-devel-0.9.10-1.el7.i686 libXrender-devel-0.9.10-1.el7.x86_64 libXrender-0.9.10-1.el7.i686 libXrender-0.9.10-1.el7.x86_64 libgcc-4.8.5-4.el7.i686 libgcc-4.8.5-4.el7.x86_64 librdmacm-devel-1.0.21-1.el7.i686 librdmacm-devel-1.0.21-1.el7.x86_64 libstdc++-4.8.5-4.el7.i686 libstdc++-4.8.5-4.el7.x86_64 libstdc++-devel-4.8.5-4.el7.i686 libstdc++-devel-4.8.5-4.el7.x86_64 libxcb-1.11-4.el7.i686 libxcb-1.11-4.el7.x86_64 make-3.82-21.el7.x86_64 nfs-utils-1.3.0-0.21.el7.x86_64 (for Oracle ACFS) net-tools-2.0-0.17.20131004git.el7 (x86_64) (for Oracle RAC and Oracle Clusterware) python-2.7.5-34.0.1.el7 (x86_64) (for Oracle ACFS Remote) python-configshell-1.1.fb18-1.el7.noarch (for Oracle ACFS Remote) python-rtslib-2.1.fb57-3.el7.noarch (for Oracle ACFS Remote) python-six-1.9.0-2.el7.noarch (for Oracle ACFS Remote) smartmontools-6.2-4.el7.x86_64 sysstat-10.1.5-7.el7.x86_64 targetcli-2.1.fb41-3.el7.noarch (for Oracle ACFS Remote) The following operating system filesets are required for Oracle Linux 7 with RHEL Compatible Kernel: bc binutils-2.23.52.0.1-12.el7.x86_64 compat-libcap1-1.10-3.el7.x86_64 compat-libstdc++-33-3.2.3-71.el7.i686 compat-libstdc++-33-3.2.3-71.el7.x86_64 glibc-2.17-36.el7.i686 glibc-2.17-36.el7.x86_64 glibc-devel-2.17-36.el7.i686 glibc-devel-2.17-36.el7.x86_64 ksh libaio-0.3.109-9.el7.i686 libaio-0.3.109-9.el7.x86_64 libaio-devel-0.3.109-9.el7.i686 libaio-devel-0.3.109-9.el7.x86_64 libX11-1.6.0-2.1.el7.i686 libX11-1.6.0-2.1.el7.x86_64 libXau-1.0.8-2.1.el7.i686 libXau-1.0.8-2.1.el7.x86_64 libXi-1.7.2-1.el7.i686 libXi-1.7.2-1.el7.x86_64 libXtst-1.2.2-1.el7.i686 libXtst-1.2.2-1.el7.x86_64 libXrender-devel-0.9.10-1.el7.i686 libXrender-devel-0.9.10-1.el7.x86_64 libXrender-0.9.10-1.el7.i686 libXrender-0.9.10-1.el7.x86_64 libgcc-4.8.2-3.el7.i686 libgcc-4.8.2-3.el7.x86_64 libstdc++-4.8.2-3.el7.i686 libstdc++-4.8.2-3.el7.x86_64 libstdc++-devel-4.8.2-3.el7.i686 libstdc++-devel-4.8.2-3.el7.x86_64 libxcb-1.9-5.el7.i686 libxcb-1.9-5.el7.x86_64 make-3.82-19.el7.x86_64 make-3.82-19.el7.x86_64 nfs-utils-1.3.0-0.21.el7.x86_64 (for Oracle ACFS) net-tools-2.0-0.17.20131004git.el7 (x86_64) (for Oracle RAC and Oracle Clusterware) python-2.7.5-34.0.1.el7 (x86_64) (for Oracle ACFS Remote) python-configshell-1.1.fb18-1.el7.noarch (for Oracle ACFS Remote) python-rtslib-2.1.fb57-3.el7.noarch (for Oracle ACFS Remote) python-six-1.9.0-2.el7.noarch (for Oracle ACFS Remote) smartmontools-6.2-4.el7.x86_64 sysstat-10.1.5-1.el7.x86_64 targetcli-2.1.fb41-3.el7.noarch (for Oracle ACFS Remote) Ensure that OpenSSH is installed on your servers. OpenSSH is the required SSH software. For Oracle C++, Pro*C/C++, Oracle C++ Call Interface, Oracle XML Developer's Kit (XDK) - Intel C/C++ Compiler 14.0.3 or later, or the version of GNU C and C++ compilers listed in the software requirements section in this document for your platform. - Oracle C++ Call Interface (OCCI) applications can be built only with Intel C++ Compiler 14.0.3 used with the standard template libraries of the gcc versions listed in the software requirements section in this document for your platform. - Oracle XML Developer's Kit is supported with the same compilers as OCCI. For Pro*COBOL Micro Focus Server Express 5.1 Micro Focus Visual COBOL for Eclipse 2.2 - Update 2 | semmsl 250 semmns 32000 semopm 100 semmni 128 shmall Greater than or equal to the value of shmmax, in pages. shmmax Half the size of physical memory in bytes shmmni 4096 panic_on_oops 1 file-max 6815744 aio-max-nr 1048576 Note: This value limits concurrent outstanding requests and should be set to avoid I/O subsystem failures. ip_local_port_range Minimum: 9000 Maximum: 65500 rmem_default 262144 rmem_max 4194304 wmem_default 262144 wmem_max 1048576 Set values in the /etc/sysctl.d/97-oracle-database-sysctl.conf fs.aio-max-nr = 1048576 fs.file-max = 6815744 kernel.shmall = 2097152 kernel.shmmax = 4294967295 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 = 1048576 To change the current values of the kernel parameters: # /sbin/sysctl --system Note:
|
RHEL 6 | ||
OS Version | Patches/Packages | Kernel settings |
The following operating system filesets are required : bc binutils-2.20.51.0.2-5.36.el6.x86_64 compat-libcap1-1.10-1 (x86_64) compat-libstdc++-33-3.2.3-69.el6 (x86_64) compat-libstdc++-33-3.2.3-69.el6.i686 e2fsprogs-1.41.12-14.el6.x86_64 e2fsprogs-libs-1.41.12-14.el6.x86_64 glibc-2.12-1.107.el6.i686 glibc-2.12-1.107.el6.x86_64 glibc-devel-2.12-1.107.el6.i686 glibc-devel-2.12-1.107.el6.x86_64 ksh libaio-0.3.107-10.el6 (x86_64) libaio-0.3.107-10.el6.i686 libaio-devel-0.3.107-10.el6 (x86_64) libaio-devel-0.3.107-10.el6.i686 libX11-1.5.0-4.el6.i686 libX11-1.5.0-4.el6.x86_64 libXau-1.0.6-4.el6.i686 libXau-1.0.6-4.el6.x86_64 libXi-1.6.1-3.el6.i686 libXi-1.6.1-3.el6.x86_64 libXtst-1.2.1-2.el6.i686 libXtst-1.2.1-2.el6.x86_64 libXrender (i686) libXrender (x86_64) libXrender-devel (i686) libXrender-devel (x86_64) libgcc-4.4.7-3.el6.i686 libgcc-4.4.7-3.el6.x86_64 libstdc++-4.4.7-3.el6.i686 libstdc++-4.4.7-3.el6.x86_64 libstdc++-devel-4.4.7-3.el6.i686 libstdc++-devel-4.4.7-3.el6.x86_64 libxcb-1.8.1-1.el6.i686 libxcb-1.8.1-1.el6.x86_64 make-3.81-20.el6.x86_64 net-tools-1.60-110.el6_2.x86_64 (for Oracle RAC and Oracle Clusterware) nfs-utils-1.2.3-36.el6.x86_64 (for Oracle ACFS) smartmontools-5.43-1.el6.x86_64 sysstat-9.0.4-20.el6.x86_64 Ensure that OpenSSH is installed on your servers. OpenSSH is the required SSH software. For Oracle C++, Pro*C/C++, Oracle C++ Call Interface, Oracle XML Developer's Kit (XDK) - Intel C/C++ Compiler 14.0.3 or later, or the version of GNU C and C++ compilers listed in the software requirements section in this document for your platform. - Oracle C++ Call Interface (OCCI) applications can be built only with Intel C++ Compiler 14.0.3 used with the standard template libraries of the gcc versions listed in the software requirements section in this document for your platform. - Oracle XML Developer's Kit is supported with the same compilers as OCCI. For Pro*COBOL Micro Focus Server Express 5.1 Micro Focus Visual COBOL for Eclipse 2.2 - Update 2 | semmsl 250 semmns 32000 semopm 100 semmni 128 shmall Greater than or equal to the value of shmmax, in pages. shmmax Half the size of physical memory in bytes shmmni 4096 panic_on_oops 1 file-max 6815744 aio-max-nr 1048576 Note: This value limits concurrent outstanding requests and should be set to avoid I/O subsystem failures. ip_local_port_range Minimum: 9000 Maximum: 65500 rmem_default 262144 rmem_max 4194304 wmem_default 262144 wmem_max 1048576 Set values in the /etc/sysctl.d/97-oracle-database-sysctl.conf fs.aio-max-nr = 1048576 fs.file-max = 6815744 kernel.shmall = 2097152 kernel.shmmax = 4294967295 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 = 1048576 To change the current values of the kernel parameters: # /sbin/sysctl --system Note:
|
RHEL 7 | ||
OS Version | Patches/Packages | Kernel settings |
The following operating system filesets are required : bc binutils-2.23.52.0.1-12.el7.x86_64 compat-libcap1-1.10-3.el7.x86_64 compat-libstdc++-33-3.2.3-71.el7.i686 compat-libstdc++-33-3.2.3-71.el7.x86_64 glibc-2.17-36.el7.i686 glibc-2.17-36.el7.x86_64 glibc-devel-2.17-36.el7.i686 glibc-devel-2.17-36.el7.x86_64 ksh libaio-0.3.109-9.el7.i686 libaio-0.3.109-9.el7.x86_64 libaio-devel-0.3.109-9.el7.i686 libaio-devel-0.3.109-9.el7.x86_64 libX11-1.6.0-2.1.el7.i686 libX11-1.6.0-2.1.el7.x86_64 libXau-1.0.8-2.1.el7.i686 libXau-1.0.8-2.1.el7.x86_64 libXi-1.7.2-1.el7.i686 libXi-1.7.2-1.el7.x86_64 libXtst-1.2.2-1.el7.i686 libXtst-1.2.2-1.el7.x86_64 libXrender-devel-0.9.10-1.el7.i686 libXrender-devel-0.9.10-1.el7.x86_64 libXrender-0.9.10-1.el7.i686 libXrender-0.9.10-1.el7.x86_64 libgcc-4.8.2-3.el7.i686 libgcc-4.8.2-3.el7.x86_64 libstdc++-4.8.2-3.el7.i686 libstdc++-4.8.2-3.el7.x86_64 libstdc++-devel-4.8.2-3.el7.i686 libstdc++-devel-4.8.2-3.el7.x86_64 libxcb-1.9-5.el7.i686 libxcb-1.9-5.el7.x86_64 make-3.82-19.el7.x86_64 make-3.82-19.el7.x86_64 nfs-utils-1.3.0-0.21.el7.x86_64 (for Oracle ACFS) net-tools-2.0-0.17.20131004git.el7 (x86_64) (for Oracle RAC and Oracle Clusterware) python-2.7.5-34.0.1.el7 (x86_64) (for Oracle ACFS Remote) python-configshell-1.1.fb18-1.el7.noarch (for Oracle ACFS Remote) python-rtslib-2.1.fb57-3.el7.noarch (for Oracle ACFS Remote) python-six-1.9.0-2.el7.noarch (for Oracle ACFS Remote) smartmontools-6.2-4.el7.x86_64 sysstat-10.1.5-1.el7.x86_64 targetcli-2.1.fb41-3.el7.noarch (for Oracle ACFS Remote) Ensure that OpenSSH is installed on your servers. OpenSSH is the required SSH software. For Oracle C++, Pro*C/C++, Oracle C++ Call Interface, Oracle XML Developer's Kit (XDK) - Intel C/C++ Compiler 14.0.3 or later, or the version of GNU C and C++ compilers listed in the software requirements section in this document for your platform. - Oracle C++ Call Interface (OCCI) applications can be built only with Intel C++ Compiler 14.0.3 used with the standard template libraries of the gcc versions listed in the software requirements section in this document for your platform. - Oracle XML Developer's Kit is supported with the same compilers as OCCI. For Pro*COBOL Micro Focus Server Express 5.1 Micro Focus Visual COBOL for Eclipse 2.2 - Update 2 | semmsl 250 semmns 32000 semopm 100 semmni 128 shmall Greater than or equal to the value of shmmax, in pages. shmmax Half the size of physical memory in bytes shmmni 4096 panic_on_oops 1 file-max 6815744 aio-max-nr 1048576 Note: This value limits concurrent outstanding requests and should be set to avoid I/O subsystem failures. ip_local_port_range Minimum: 9000 Maximum: 65500 rmem_default 262144 rmem_max 4194304 wmem_default 262144 wmem_max 1048576 Set values in the /etc/sysctl.d/97-oracle-database-sysctl.conf fs.aio-max-nr = 1048576 fs.file-max = 6815744 kernel.shmall = 2097152 kernel.shmmax = 4294967295 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 = 1048576 To change the current values of the kernel parameters: # /sbin/sysctl --system Note:
|
Solaris 10 | ||
OS Version | Patches/Packages | Kernel settings |
Oracle Solaris 10 Update 11 (Oracle Solaris 10 1/13 s10s_u11wos_24a) or later updates Reference: 2429072.1 | The following packages and patches (or later versions) must be installed: SUNWdtrc SUNWeu8os SUNWi1cs (ISO8859-1) SUNWi15cs (ISO8859-15) 118683-13 119963-33 120753-14 147440-25 Note: You may also require additional font packages for Java, depending on your locale. Refer to the following URL: http://www.oracle.com/technetwor ... rements-142758.html Ensure that OpenSSH is installed on your servers. OpenSSH is the required SSH software. For Oracle C++, Pro*C/C++, Oracle C++ Call Interface, Oracle XML Developer's Kit (XDK) Oracle C++ - Oracle Solaris Studio 12.4 (formerly Sun Studio) PSE 4/15/2015 Oracle C++ Call Interface - 124863-12 C++ 5.9 compiler Pro*C/C++ - 124864-12 C++ 5.9 Compiler Oracle XML Developer's Kit (XDK) - Download Oracle Solaris Studio from the following URL: http://www.oracle.com/technetwor ... overview/index.html For Pro*COBOL Micro Focus Server Express 5.1 Micro Focus Visual COBOL for Eclipse 2.2 - Update 2 C Compiler Patches 118683-14 Oracle Solaris Studio 12.4 patch for Oracle Solaris on SPARC 119961-15 Oracle Solaris Studio 12.4 patch for Oracle Solaris on x86-64 (64-bit) 148506-12 Oracle Solaris Studio 12.3 C++ Compiler patch for Oracle Solaris on SPARC 148917-06 Oracle Solaris Studio 12.3 C Compiler patch for Oracle Solaris on SPARC 124861-15 Compiler Common patch for Sun C C++ F77 F95 126498-15 Compiler Common patch for Sun C C++ F77 F95 124867-11 C 5.9 Compiler 124868-10 C 5.9 Compiler 126495 Debuginfo Handling 126496-02 Debuginfo Handling 139556-08 Pro*FORTRAN - Oracle Solaris Studio 12 (Fortran 95) | project.max-sem-ids 100 process.max-sem-nsems 256 project.max-shm-memory This value varies according to the RAM size. 1 GB to 16 GB - Half the size of physical memory Greater than 16 GB - At least 8 GB project.max-shm-ids 100 Starting with 18c, on Oracle Solaris systems, Oracle Database uses a new method of sharing memory among a group of processes, also known as Managed Global Areas (MGA). The operating system memory allocation mechanism for this new method is Optimized Shared Memory (OSM). Oracle recommends that you configure the additional shared memory identifiers and increase the shared memory limits as follows: Additional number of MGA segments (project.max-shm-ids) = MGA memory size / granule size Where: MGA memory size is the cumulative MGA memory requirement size for all processes in an Oracle Database instance. Typically, 2MB per Oracle process. Minimum value of granule size is 4 MB. For large SGA, granule size may increase automatically upto 512 MB. Less than 1 GB - 4 MB Between 1 GB and 8 GB - 16 MB Between 8 GB and 16 GB - 32 MB Between 16 GB and 32 GB - 64 MB Between 32 GB and 64 GB - 128 MB Between 64 GB and 128 GB - 256 MB Greater than 128 GB - 512 MB tcp_smallest_anon_port - 9000 tcp_largest_anon_port - 65500 udp_smallest_anon_port - 9000 udp_largest_anon_port - 65500 |
Solaris 11 | ||
OS Version | Patches/Packages | Kernel settings |
Oracle Solaris 11.3 SRU 7.6 (Oracle Solaris 11.3.7.6.0) or later SRUs and updates Oracle Solaris 11.2 SRU 5.5 (Oracle Solaris 11.2.5.5.0) or later SRUs and updates Reference: 2429154.1 | The following operating system filesets are required : The following packages must be installed: pkg://solaris/system/library/openmp pkg://solaris/compress/unzip pkg://solaris/developer/assembler pkg://solaris/developer/build/make pkg://solaris/system/dtrace pkg://solaris/system/header pkg://solaris/system/kernel/oracka (Only for Oracle Real Application Clusters installations) pkg://solaris/system/library pkg://solaris/system/linker pkg://solaris/system/xopen/xcu4 (If not already installed as part of standard Oracle Solaris 11 installation) pkg://solaris/x11/diagnostic/x11-info-clients Note: Starting with Oracle Solaris 11.2, if you have performed a standard Oracle Solaris 11 installation, and installed the Oracle Database prerequisites group package oracle-rdbms-server-18c-preinstall, then you do not have to install these packages, as oracle-rdbms-server-18c-preinstall installs them for you. Ensure that OpenSSH is installed on your servers. OpenSSH is the required SSH software. For Oracle C++, Pro*C/C++, Oracle C++ Call Interface, Oracle XML Developer's Kit (XDK) Oracle C++ - Oracle Solaris Studio 12.4 (formerly Sun Studio) PSE 4/15/2015 Oracle C++ Call Interface - 124863-12 C++ 5.9 compiler Pro*C/C++ - 124864-12 C++ 5.9 Compiler Oracle XML Developer's Kit (XDK) - Download Oracle Solaris Studio from the following URL: http://www.oracle.com/technetwor ... overview/index.html For Pro*COBOL Micro Focus Server Express 5.1 Micro Focus Visual COBOL for Eclipse 2.2 - Update 2 C Compiler Patches 118683-14 Oracle Solaris Studio 12.4 patch for Oracle Solaris on SPARC 119961-15 Oracle Solaris Studio 12.4 patch for Oracle Solaris on x86-64 (64-bit) 148506-12 Oracle Solaris Studio 12.3 C++ Compiler patch for Oracle Solaris on SPARC 148917-06 Oracle Solaris Studio 12.3 C Compiler patch for Oracle Solaris on SPARC 124861-15 Compiler Common patch for Sun C C++ F77 F95 126498-15 Compiler Common patch for Sun C C++ F77 F95 124867-11 C 5.9 Compiler 124868-10 C 5.9 Compiler 126495 Debuginfo Handling 126496-02 Debuginfo Handling 139556-08 Pro*FORTRAN - Oracle Solaris Studio 12 (Fortran 95) | project.max-sem-ids 100 process.max-sem-nsems 256 project.max-shm-memory This value varies according to the RAM size. 1 GB to 16 GB - Half the size of physical memory Greater than 16 GB - At least 8 GB project.max-shm-ids 100 Starting with 18c, on Oracle Solaris systems, Oracle Database uses a new method of sharing memory among a group of processes, also known as Managed Global Areas (MGA). The operating system memory allocation mechanism for this new method is Optimized Shared Memory (OSM). Oracle recommends that you configure the additional shared memory identifiers and increase the shared memory limits as follows: Additional number of MGA segments (project.max-shm-ids) = MGA memory size / granule size Where: MGA memory size is the cumulative MGA memory requirement size for all processes in an Oracle Database instance. Typically, 2MB per Oracle process. Minimum value of granule size is 4 MB. For large SGA, granule size may increase automatically upto 512 MB. Less than 1 GB - 4 MB Between 1 GB and 8 GB - 16 MB Between 8 GB and 16 GB - 32 MB Between 16 GB and 32 GB - 64 MB Between 32 GB and 64 GB - 128 MB Between 64 GB and 128 GB - 256 MB Greater than 128 GB - 512 MB tcp_smallest_anon_port - 9000 tcp_largest_anon_port - 65500 udp_smallest_anon_port - 9000 udp_largest_anon_port - 65500 |
OS Version | Patches/Packages | Kernel settings |
AIX 6.1 Technology Level 9 Service Pack 10 (6100-09-10-1731) or later, 64-bit kernel AIX 7.1 Technology Level 5 Service Pack 1 (7100-05-01-1731) or later, 64-bit kernel | bos.adt.base bos.adt.lib bos.adt.libm bos.perf.libperfstat bos.perf.perfstat bos.perf.proctools security.pkcs11.6.1.9.200 or later (for AIX 6.1) xlC.aix61.rte:13.1.0.1 or later xlC.rte:13.1.0.1 or later security.pkcs11.7.1.3.15 or later (for AIX 7.1) The following filesets are required for Oracle Real Application Clusters (Oracle RAC) Installations only: • rsct.basic.rte • rsct.compat.clients.rte AIX APAR numbers are tied to AIX versions and technology levels. Download and install the APAR that matches your AIX versions and Technology Levels from the IBM fix central website at the following URL: https://www.ibm.com/ For Oracle C++, Oracle C++ Call Interface, Pro*C/C++, Oracle XML Developer's Kit (XDK) – IBM XL C/C++ Runtime for AIX, v13.1.3.3 Fix Pack (June 2017) For Pro*COBOL - IBM COBOL for AIX version 4.1.1, Fix Pack 12, (October 2014 PTF) Micro Focus Server Express 5.1 Micro Focus Visual COBOL for Eclipse 2.2 - Update 2 For Pro*FORTRAN - IBM XL Fortran Runtime for AIX, Version 15.1, September 2014 PTF IBM XL Fortran for AIX, Version 15.1, September 2014 PTF For ADA - OC Systems PowerAda 5.5 | Ensure that the lower range is set to at least 9000 or higher, to avoid Well Known ports, and to avoid ports in the Registered Ports range commonly used by Oracle and other server ports. Set the port range high enough to avoid reserved ports for any applications you may intend to use. If the lower value of the range you have is greater than 9000, and the range is large enough for your anticipated workload, then you can ignore OUI warnings regarding the ephemeral port range tcp_ephemeral_low = 32768 tcp_ephemeral_high = 65535 udp_ephemeral_low = 32768 udp_ephemeral_high = 65535 Shell limits Soft File Descriptors at least 1024 Hard File Descriptors at least 65536 Number of processes (Soft) at least 2047 Number of processes (Hard) at least 16384 Soft STACK size at least 10240 KB Hard STACK size at least 10240 KB; at most 32768 KB Soft FILE size unlimited Soft CPU time unlimited Soft DATA segment unlimited Soft Real Memory size unlimited maxuprocs 16384 ncargs 128 IOCP :To ensure successful database, client, and grid infrastructure installation, set IOCP to Available. |
AIX7.2 | ||
OS Version | Patches/Packages | Kernel settings |
AIX 7.2 Technology Level 2 Service Pack 1 (7200-02-01-1731) or later, 64-bit kernel | The following operating system filesets are required: bos.adt.base bos.adt.lib bos.adt.libm bos.perf.libperfstat bos.perf.perfstat bos.perf.proctools xlC.aix61.rte:13.1.0.1 or later xlC.rte:13.1.0.1 or later The following filesets are required for Oracle Real Application Clusters (Oracle RAC) Installations only: • rsct.basic.rte • rsct.compat.clients.rte AIX APAR numbers are tied to AIX versions and technology levels. Download and install the APAR that matches your AIX versions and Technology Levels from the IBM fix central website at the following URL: https://www.ibm.com/ Note: Install IV80412m1a as it includes the required fix for IV79441 - possible system crash using procfs to read 32bit process map fil. For Oracle C++, Oracle C++ Call Interface, Pro*C/C++, Oracle XML Developer's Kit (XDK) – IBM XL C/C++ Runtime for AIX, v13.1.3.3 Fix Pack (June 2017) For Pro*COBOL - IBM COBOL for AIX version 4.1.1, Fix Pack 12, (October 2014 PTF) Micro Focus Server Express 5.1 Micro Focus Visual COBOL for Eclipse 2.2 - Update 2 For Pro*FORTRAN - IBM XL Fortran Runtime for AIX, Version 15.1, September 2014 PTF IBM XL Fortran for AIX, Version 15.1, September 2014 PTF For ADA - OC Systems PowerAda 5.5 | Ensure that the lower range is set to at least 9000 or higher, to avoid Well Known ports, and to avoid ports in the Registered Ports range commonly used by Oracle and other server ports. Set the port range high enough to avoid reserved ports for any applications you may intend to use. If the lower value of the range you have is greater than 9000, and the range is large enough for your anticipated workload, then you can ignore OUI warnings regarding the ephemeral port range tcp_ephemeral_low = 32768 tcp_ephemeral_high = 65535 udp_ephemeral_low = 32768 udp_ephemeral_high = 65535 Shell limits Soft File Descriptors at least 1024 Hard File Descriptors at least 65536 Number of processes (Soft) at least 2047 Number of processes (Hard) at least 16384 Soft STACK size at least 10240 KB Hard STACK size at least 10240 KB; at most 32768 KB Soft FILE size unlimited Soft CPU time unlimited Soft DATA segment unlimited Soft Real Memory size unlimited maxuprocs 16384 ncargs 128 IOCP :To ensure successful database, client, and grid infrastructure installation, set IOCP to Available |
OS Version | Patches/Packages | Kernel settings |
SUSE Linux Enterprise Server 12 SP1: 3.12.49-11.1 or later Reference : | bc binutils-2.24-2.165.x86_64 gcc-c++-32bit-4.8-6.189.x86_64 gcc-c++-4.8-6.189.x86_64 gcc48-c++-4.8.3+r212056-6.3.x86_64 gcc-32bit-4.8-6.189.x86_64 gcc-4.8-6.189.x86_64 gcc-info-4.8-6.189.x86_64 gcc-locale-4.8-6.189.x86_64 gcc48-32bit-4.8.3+r212056-6.3.x86_64 gcc48-4.8.3+r212056-6.3.x86_64 gcc48-info-4.8.3+r212056-6.3.noarch gcc48-locale-4.8.3+r212056-6.3.x86_64 glibc-2.19-17.72.x86_64 glibc-devel-2.19-17.72.x86_64 libaio-devel-0.3.109-17.15.x86_64 libaio1-0.3.109-17.15.x86_64 libaio1-32bit-0.3.109-17.15.x86_64 libgfortran3-4.8.3+r212056-6.3.x86_64 libX11-6-1.6.2-4.12.x86_64 libX11-6-32bit-1.6.2-4.12.x86_64 libXau6-1.0.8-4.58.x86_64 libXau6-32bit-1.0.8-4.58.x86_64 libXtst6-1.2.2-3.60.x86_64 libXtst6-32bit-1.2.1-2.4.1.x86_64 libcap-ng-utils-0.7.3-4.125.x86_64 libcap-ng0-0.7.3-4.125.x86_64 libcap-ng0-32bit-0.7.3-4.125.x86_64 libcap-progs-2.22-11.709.x86_64 libcap1-1.10-59.61.x86_64 libcap1-32bit-1.10-59.61.x86_64 libcap2-2.22-11.709.x86_64 libcap2-32bit-2.22-11.709.x86_64 libgcc_s1-32bit-4.8.3+r212056-6.3.x86_64 libgcc_s1-4.8.3+r212056-6.3.x86_64 libpcap1-1.5.3-2.18.x86_64 libstdc++6-32bit-4.8.3+r212056-6.3.x86_64 libstdc++6-4.8.3+r212056-6.3.x86_64 libelf-devel-0.158-6.1.x86_64 libjpeg-turbo-1.3.1-30.3.x86_64 libpcre1-32bit-8.33-3.314.x86_64 libpcre1-8.33-3.314.x86_64 libpcre16-0-8.33-3.314.x86_64 libpng12-0-1.2.50-8.21.x86_64 libpng12-0-32bit-1.2.50-8.21.x86_64 libstdc++33-3.3.3-62.1.x86_64 libtiff5-4.0.4-12.2.x86_64 make-4.0-2.107.x86_64 mksh-50-2.13.x86_64 net-tools-1.60-764.185.x86_64 (for Oracle RAC and Oracle Clusterware) nfs-kernel-server-1.3.0-6.9.x86_64 (for Oracle ACFS) pixz-1.0.2-6.23.x86_64 smartmontools-6.2-4.33.x86_64 sysstat-8.1.5-7.32.1.x86_64 xorg-x11-libs-7.6-45.14 xz-5.0.5-4.852.x86_64 | kernel.shmall = Greater than or equal to the value of shmmax, in pages. kernel.shmmax = Half the size of physical memory in bytes See My Oracle Support Note 567506.1 for additional information about configuring shmmax. kernel.shmmni = 4096 kernel.sem = 250 32000 100 128 fs.file-max = 6815744 fs.aio-max-nr = 1048576 Note: This value limits concurrent outstanding requests and should be set to avoid I/O subsystem failures. 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 = 1048576 /etc/security/limits.conf oracle soft nproc 2047 oracle hard nproc 16384 oracle soft nofile 65535 oracle hard nofile 65536 oracle soft stack 10240 oracle hard stack 10240
/sbin/chkconfig boot.sysctl on ;
GID of the oinstall group (in this example GID=500). Grants members of oinstall a group permission to create shared memory segments
vm.hugetlb_shm_group=501 ; |
OS Version | Patches/Packages | Kernel settings |
HP-UX 11.31 September 2014 B.11.31.1409 or later. Reference : | PHCO_43503 - 11.31 diskowner(1M) cumulative patch PHKL_40941 - 11.31 scheduler cumulative patch PHKL_42916 - 11.31 SCSI cumulative I/O patch PHKL_42996 - 11.31 scheduler cumulative patch PHKL_43775 - 11.31 vm cumulative patch PHKL_44248 - 11.31 SCSI cumulative I/O patch PHKL_44417 - 11.31 vm cumulative patch PHKL_44565 - 11.31 vm cumulative patch PHSS_37042 - 11.31 hppac PHSS_39094 - 11.31 linker + fdp cumulative patch PHSS_39102 - 11.31 Integrity Unwind Library PHSS_42686 - 11.31 assembler patch PHSS_43205 - 11.31 Math Library Cumulative Patch PHSS_43291 - 11.31 X/Motif runtime patch PHSS_43733 - 11.31 LIBCL patch PHSS_43740 - 11.31 Integrity Unwind Library PHSS_44164 - 11.31 linker + fdp cumulative patch PHSS_44402 - 11.31 linker + fdp cumulative patch For Clusterware HP Serviceguard A.11.20 HP Serviceguard A.11.20 extension for RAC Note:HP Serviceguard is optional. It is required only if you want to use shared logical volumes for Oracle Clusterware or database files. Oracle C++, Oracle C++ Call Interface, Pro*C/C++, Oracle XML Developer's Kit (XDK): Compiler Version: A.06.28 Patch for HP-UX 11i V3 (11.31) on HP-UX Itanium: PHSS_40631 - 11.31 HP C/aC++ Compiler (A.06.24) PHSS_40633 - 11.31 u2comp/be/plugin (C.06.24) PHSS_43741 - 11.31 aC++ Runtime (IA: A.06.28, PA: A.03.90) Note:Additional patches may be needed depending on applications you deploy. Pro*COBOL Micro Focus Server Express 5.1 Micro Focus Visual COBOL for Eclipse 2.2 - Update 2 Pro*FORTRAN - HP FORTRAN/90 - Sep 2008 - release VERITAS File System - PHKL_44199 - 11.31 VRTS 5.0 MP1P13 VRTSvxfs Kernel Patch Note:The VERITAS file system is optional. This patch is required only if you want to use a VERITAS File System 5.0. HP Caliper and Gmake - HP Caliper 5.7, Gmake 3.81 gcc - gcc 4.2.3 | executable_stack 0 ksi_alloc_max 32768 max_thread_proc 1024 maxdsiz 1073741824 (1 GB) maxdsiz_64bit 2147483648 (2 GB) maxfiles 1024 maxfiles_lim 63488 maxssiz 134217728 (128 MB) maxssiz_64bit 1073741824 (1 GB) maxuprc 3686 msgmni 4096 msgtql 4096 ncsize 35840 nflocks 4096 ninode 34816 nkthread 7184 nproc 4096 semmni 4096 semmns 8192 semmnu 4092 semvmx 32767 shmmax 1073741824 shmmni 4096 shmseg 512 tcp_largest_anon_port 65500 udp_largest_anon_port 65500 Guidelines for Setting Kernel Parameter Values If the current value for any parameter is higher than the value listed in this table, then do not change the value of that parameter. Do not specify values for the following parameters as they are obsolete on HP-UX 11.31: msgmap msgseg If you do not use HFS, then retain the default ninode value. |
Oracle Linux 7 | ||
OS Version | Patches/Packages | Kernel settings |
Oracle Linux 7.4 with the Unbreakable Enterprise Kernel 4: 4.1.12-124.19.2.el7uek.x86_64 or later Oracle Linux 7.4 with the Unbreakable Enterprise Kernel 5: 4.14.35-1818.1.6.el7uek.x86_64 or later Oracle Linux 7.5 with the Red Hat Compatible kernel: 3.10.0-862.11.6.el7.x86_64 or later Reference: 2551169.1 | bc binutils compat-libcap1 compat-libstdc++ elfutils-libelf elfutils-libelf-devel fontconfig-devel glibc glibc-devel ksh libaio libaio-devel libXrender libXrender-devel libX11 libXau libXi libXtst libgcc libstdc++ libstdc++-devel libxcb make net-tools (for Oracle RAC and Oracle Clusterware) nfs-utils (for Oracle ACFS) python (for Oracle ACFS Remote) python-configshell (for Oracle ACFS Remote) python-rtslib (for Oracle ACFS Remote) python-six (for Oracle ACFS Remote) targetcli (for Oracle ACFS Remote) smartmontools sysstat Note:If you intend to use 32-bit client applications to access 64-bit servers, then you must also install (where available) the latest 32-bit versions of the packages listed in this table. Ensure that OpenSSH is installed on your servers. OpenSSH is the required SSH software. Kernel-based virtual machine (KVM), also known as KVM virtualization, is certified on Oracle Database 19c for all supported Oracle Linux 7 distributions. For more information on supported virtualization technologies for Oracle Database, refer to the virtualization matrix: https://www.oracle.com/database/ ... ization-matrix.html For Oracle C++, Pro*C/C++, Oracle C++ Call Interface, Oracle XML Developer's Kit (XDK) - Intel C/C++ Compiler 17.0.2.174 or later, or the GNU C and C++ compilers listed in this table. - Oracle C++ Call Interface (OCCI) applications can be built with g++ and Intel C++ Compiler 17.0.2.174 used with the standard template libraries of the gcc compilers - Install the latest released versions of the gcc packages listed here. gcc, gcc-c++, gcc-info, gcc-locale, gcc48, gcc48-info, gcc48-locale, gcc48-c++ - Oracle XML Developer's Kit is supported with the same compilers as OCCI. For Pro*COBOL Micro Focus Visual COBOL for Eclipse 2.3 - Update 2 Java Database Connectivity (JDBC) / JDBC Oracle Call Interface (JDBC OCI) JDK 8 (Java SE Development Kit) with the JNDI extension with Oracle Java Database Connectivity. | semmsl 250 semmns 32000 semopm 100 semmni 128 shmall Greater than or equal to the value of shmmax, in pages. shmmax Half the size of physical memory in bytes shmmni 4096 panic_on_oops 1 file-max 6815744 aio-max-nr 1048576 ip_local_port_range Minimum: 9000 Maximum: 65500 rmem_default 262144 rmem_max 4194304 wmem_default 262144 wmem_max 1048576 Set values in /etc/sysctl.d/97-oracle-database-sysctl.conf fs.aio-max-nr = 1048576 fs.file-max = 6815744 kernel.shmall = 2097152 kernel.shmmax = 4294967295 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 = 1048576 To change the current values of the kernel parameters: # /sbin/sysctl --system Note:
|
RHEL 7 | ||
OS Version | Patches/Packages | Kernel settings |
The following operating system filesets are required : bc binutils compat-libcap1 compat-libstdc++ elfutils-libelf elfutils-libelf-devel fontconfig-devel glibc glibc-devel ksh libaio libaio-devel libX11 libXau libXi libXtst libXrender libXrender-devel libgcc libstdc++ libstdc++-devel libxcb make net-tools (for Oracle RAC and Oracle Clusterware) nfs-utils (for Oracle ACFS) python (for Oracle ACFS Remote) python-configshell (for Oracle ACFS Remote) python-rtslib (for Oracle ACFS Remote) python-six (for Oracle ACFS Remote) targetcli (for Oracle ACFS Remote) smartmontools sysstat Ensure that OpenSSH is installed on your servers. OpenSSH is the required SSH software. Note:If you intend to use 32-bit client applications to access 64-bit servers, then you must also install (where available) the latest 32-bit versions of the packages listed in this table. For Oracle C++, Pro*C/C++, Oracle C++ Call Interface, Oracle XML Developer's Kit (XDK) - Intel C/C++ Compiler 17.0.2.174 or later, or the GNU C and C++ compilers. - Oracle C++ Call Interface (OCCI) applications can be built with g++ and Intel C++ Compiler 17.0.2.174 used with the standard template libraries of the gcc compilers. -Oracle XML Developer's Kit is supported with the same compilers as OCCI. For Pro*COBOL Micro Focus Visual COBOL for Eclipse 2.2 - Update 2 Java Database Connectivity (JDBC) / JDBC Oracle Call Interface (JDBC OCI) JDK 8 (Java SE Development Kit) with the JNDI extension with Oracle Java Database Connectivity. | semmsl 250 semmns 32000 semopm 100 semmni 128 shmall Greater than or equal to the value of shmmax, in pages. shmmax Half the size of physical memory in bytes shmmni 4096 panic_on_oops 1 file-max 6815744 aio-max-nr 1048576 ip_local_port_range Minimum: 9000 Maximum: 65500 rmem_default 262144 rmem_max 4194304 wmem_default 262144 wmem_max 1048576 Set values in /etc/sysctl.d/97-oracle-database-sysctl.conf fs.aio-max-nr = 1048576 fs.file-max = 6815744 kernel.shmall = 2097152 kernel.shmmax = 4294967295 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 = 1048576 To change the current values of the kernel parameters: # /sbin/sysctl --system Note:
|
SLES 12 | ||
OS Version | Patches/Packages | Kernel settings |
SUSE Linux Enterprise Server 12 SP3: 4.4.162-94.72-default or later | The following operating system filesets are required : bc binutils glibc glibc-devel libX11 libXau6 libXtst6 libcap-ng-utils libcap-ng0 libcap-progs libcap1 libcap2 libelf-devel libgcc_s1 libjpeg-turbo libjpeg62 libjpeg62-turbo libpcap1 libpcre1 libpcre16-0 libpng16-16 libstdc++6 libtiff5 libaio-devel libaio1 libXrender1 make mksh net-tools (for Oracle RAC and Oracle Clusterware) nfs-kernel-server ( for Oracle ACFS) pixz rdma-core rdma-core-devel smartmontools sysstat xorg-x11-libs xz Ensure that OpenSSH is installed on your servers. OpenSSH is the required SSH software. Note:If you intend to use 32-bit client applications to access 64-bit servers, then you must also install (where available) the latest 32-bit versions of the packages listed in this table. For Oracle C++, Pro*C/C++, Oracle C++ Call Interface, Oracle XML Developer's Kit (XDK) - Intel C/C++ Compiler 14.0.3 or later, or the version of GNU C and C++ compilers listed in the software requirements section in this document for your platform. - Oracle C++ Call Interface (OCCI) applications can be built only with Intel C++ Compiler 14.0.3 used with the standard template libraries of the gcc versions listed in the software requirements section in this document for your platform. - Oracle XML Developer's Kit is supported with the same compilers as OCCI. For Pro*COBOL Micro Focus Visual COBOL for Eclipse 2.2 - Update 2 Java Database Connectivity (JDBC) / JDBC Oracle Call Interface (JDBC OCI) JDK 8 (Java SE Development Kit) with the JNDI extension with Oracle Java Database Connectivity. | semmsl 250 semmns 32000 semopm 100 semmni 128 shmall Greater than or equal to the value of shmmax, in pages. shmmax Half the size of physical memory in bytes shmmni 4096 panic_on_oops 1 file-max 6815744 aio-max-nr 1048576 ip_local_port_range Minimum: 9000 Maximum: 65500 rmem_default 262144 rmem_max 4194304 wmem_default 262144 wmem_max 1048576 Set values in /etc/sysctl.d/97-oracle-database-sysctl.conf fs.aio-max-nr = 1048576 fs.file-max = 6815744 kernel.shmall = 2097152 kernel.shmmax = 4294967295 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 = 1048576 To change the current values of the kernel parameters: # /sbin/sysctl --system Note:
|
SLES 15 | ||
OS Version | Patches/Packages | Kernel settings |
SUSE Linux Enterprise Server 15: 4.12.14-23-default or later | The following operating system filesets are required : bc binutils glibc glibc-devel libaio-devel libaio1 libX11 libXau6 libXext-devel libXext6 libXi-devel libXi6 libXrender-devel libXrender1 libXtst6 libcap-ng-utils libcap-ng0 libcap-progs libcap1 libcap2 libelf1 libgcc_s1 libjpeg-turbo libjpeg62 libjpeg62-turbo libjpeg8 libpcap1 libpcre1 libpcre16-0 libpng16-16 libstdc++6 libtiff5 libgfortran4 mksh make net-tools (for Oracle RAC and Oracle Clusterware) nfs-kernel-server (for Oracle ACFS) pixz rdma-core rdma-core-devel smartmontools sysstat xorg-x11-libs xz Ensure that OpenSSH is installed on your servers. OpenSSH is the required SSH software. Note:If you intend to use 32-bit client applications to access 64-bit servers, then you must also install (where available) the latest 32-bit versions of the packages listed in this table. For Oracle C++, Pro*C/C++, Oracle C++ Call Interface, Oracle XML Developer's Kit (XDK) - Intel C/C++ Compiler 14.0.3 or later, or the version of GNU C and C++ compilers listed in the software requirements section in this document for your platform. - Oracle C++ Call Interface (OCCI) applications can be built only with Intel C++ Compiler 14.0.3 used with the standard template libraries of the gcc versions listed in the software requirements section in this document for your platform. - Oracle XML Developer's Kit is supported with the same compilers as OCCI. For Pro*COBOL Micro Focus Visual COBOL for Eclipse 2.2 - Update 2 Java Database Connectivity (JDBC) / JDBC Oracle Call Interface (JDBC OCI) JDK 8 (Java SE Development Kit) with the JNDI extension with Oracle Java Database Connectivity. | semmsl 250 semmns 32000 semopm 100 semmni 128 shmall Greater than or equal to the value of shmmax, in pages. shmmax Half the size of physical memory in bytes shmmni 4096 panic_on_oops 1 file-max 6815744 aio-max-nr 1048576 ip_local_port_range Minimum: 9000 Maximum: 65500 rmem_default 262144 rmem_max 4194304 wmem_default 262144 wmem_max 1048576 Set values in /etc/sysctl.d/97-oracle-database-sysctl.conf fs.aio-max-nr = 1048576 fs.file-max = 6815744 kernel.shmall = 2097152 kernel.shmmax = 4294967295 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 = 1048576 To change the current values of the kernel parameters: # /sbin/sysctl --system Note:
|
AIX7.1 | ||
OS Version | Patches/Packages | Kernel settings |
AIX 7.1 Technology Level 5 Service Pack 1 (7100-05-01-1731) or later, 64-bit kernel | bos.adt.base bos.adt.lib bos.adt.libm bos.perf.libperfstat bos.perf.perfstat bos.perf.proctools security.pkcs11.7.1.3.15 or later xlC.aix61.rte:13.1.0.1 or later xlC.rte:13.1.0.1 or later The following filesets are required for Oracle Real Application Clusters (Oracle RAC) Installations only: rsct.basic.rte rsct.compat.clients.rte AIX APAR numbers are tied to AIX versions and technology levels. Download and install the APAR that matches your AIX versions and Technology Levels from the IBM fix central website at the following URL: https://www.ibm.com/ Note: Install IV80412m1a as it includes the required fix for IV79441 - possible system crash using procfs to read 32bit process map file. For Oracle C++, Oracle C++ Call Interface, Pro*C/C++, Oracle XML Developer's Kit (XDK) – BM XL C/C++ Runtime for AIX, v13.1.3.3 Fix Pack (June 2017) Download this software from the following URLs: http://www-01.ibm.com/support/docview.wss?uid=swg24043829 For Pro*COBOL - IBM COBOL for AIX version 4.1.1, Fix Pack 12, (October 2014 PTF) Micro Focus Server Express 5.1 Micro Focus Visual COBOL for Eclipse 2.3 - Update 2 For Pro*FORTRAN - IBM XL Fortran Runtime for AIX, Version 15.1, September 2014 PTF IBM XL Fortran for AIX, Version 15.1, September 2014 PTF For ADA - OC Systems PowerAda 5.5 For more information about OC Systems and PowerAda, go to: PowerAda 5.5 | Ensure that the lower range is set to at least 9000 or higher, to avoid Well Known ports, and to avoid ports in the Registered Ports range commonly used by Oracle and other server ports. Set the port range high enough to avoid reserved ports for any applications you may intend to use. If the lower value of the range you have is greater than 9000, and the range is large enough for your anticipated workload, then you can ignore OUI warnings regarding the ephemeral port range tcp_ephemeral_low = 32768 tcp_ephemeral_high = 65500 udp_ephemeral_low = 32768 udp_ephemeral_high = 65500 Shell limits Soft File Descriptors at least 1024 Hard File Descriptors at least 65536 Number of processes (Soft) at least 2047 Number of processes (Hard) at least 16384 Soft STACK size at least 10240 KB Hard STACK size at least 10240 KB; at most 32768 KB Soft FILE size unlimited Soft CPU time unlimited Note:This is the default value. Soft DATA segment unlimited Soft Real Memory size unlimited maxuprocs 16384 ncargs 128 IOCP :To ensure successful database, client, and grid infrastructure installation, set IOCP to Available The recommended value for aio_maxreqs is 64k (65536) |
AIX7.2 | ||
OS Version | Patches/Packages | Kernel settings |
AIX 7.1 Technology Level 5 Service Pack 1 (7100-05-01-1731) or later, 64-bit kernel | The following operating system filesets are required: bos.adt.base bos.adt.lib bos.adt.libm bos.perf.libperfstat bos.perf.perfstat bos.perf.proctools xlC.aix61.rte:13.1.0.1 or later xlC.rte:13.1.0.1 or later The following filesets are required for Oracle Real Application Clusters (Oracle RAC) Installations only: rsct.basic.rte rsct.compat.clients.rte If you are using the minimum operating system TL level for AIX 7.2 listed above, then install the following AIX APAR fix: IJ06143 Note: If you are using a later TL level than the minimum level listed for this release, then contact IBM to determine if the required APARs listed in this section are included in the TL level that you have on your system. If they are included, then you do not have to install them. If they are not included, then you must install the equivalent APAR for the appropriate TL level. AIX APAR numbers are tied to AIX versions and technology levels. Download and install the APAR that matches your AIX versions and Technology Levels from the IBM fix central website at the following URL: https://www.ibm.com/ Install IV80412m1a as it includes the required fix for IV79441 - possible system crash using procfs to read 32bit process map file. For Oracle C++, Oracle C++ Call Interface, Pro*C/C++, Oracle XML Developer's Kit (XDK) – BM XL C/C++ Runtime for AIX, v13.1.3.3 Fix Pack (June 2017) Download this software from the following URLs: http://www-01.ibm.com/support/docview.wss?uid=swg24043829 For Pro*COBOL - IBM COBOL for AIX version 4.1.1, Fix Pack 12, (October 2014 PTF) Micro Focus Server Express 5.1 Micro Focus Visual COBOL for Eclipse 2.3 - Update 2 For Pro*FORTRAN - IBM XL Fortran Runtime for AIX, Version 15.1, September 2014 PTF IBM XL Fortran for AIX, Version 15.1, September 2014 PTF For ADA - OC Systems PowerAda 5.5 For more information about OC Systems and PowerAda, go to: PowerAda 5.5 | Ensure that the lower range is set to at least 9000 or higher, to avoid Well Known ports, and to avoid ports in the Registered Ports range commonly used by Oracle and other server ports. Set the port range high enough to avoid reserved ports for any applications you may intend to use. If the lower value of the range you have is greater than 9000, and the range is large enough for your anticipated workload, then you can ignore OUI warnings regarding the ephemeral port range tcp_ephemeral_low = 32768 tcp_ephemeral_high = 65500 udp_ephemeral_low = 32768 udp_ephemeral_high = 65500 Shell limits Soft File Descriptors at least 1024 Hard File Descriptors at least 65536 Number of processes (Soft) at least 2047 Number of processes (Hard) at least 16384 Soft STACK size at least 10240 KB Hard STACK size at least 10240 KB; at most 32768 KB Soft FILE size unlimited Soft CPU time unlimited Note:This is the default value. Soft DATA segment unlimited Soft Real Memory size unlimited maxuprocs 16384 ncargs 128 IOCP :To ensure successful database, client, and grid infrastructure installation, set IOCP to Available The recommended value for aio_maxreqs is 64k (65536) |
OS Version | Patches/Packages | Kernel settings |
HP-UX 11.31 September 2014 B.11.31.1409 or later. Reference : | PHCO_43503 - 11.31 diskowner(1M) cumulative patch PHKL_40941 - 11.31 scheduler cumulative patch PHKL_42916 - 11.31 SCSI cumulative I/O patch PHKL_42996 - 11.31 scheduler cumulative patch PHKL_43775 - 11.31 vm cumulative patch PHKL_44248 - 11.31 SCSI cumulative I/O patch PHKL_44417 - 11.31 vm cumulative patch PHKL_44565 - 11.31 vm cumulative patch PHSS_37042 - 11.31 hppac PHSS_39094 - 11.31 linker + fdp cumulative patch PHSS_39102 - 11.31 Integrity Unwind Library PHSS_42686 - 11.31 assembler patch PHSS_43205 - 11.31 Math Library Cumulative Patch PHSS_43291 - 11.31 X/Motif runtime patch PHSS_43733 - 11.31 LIBCL patch PHSS_43740 - 11.31 Integrity Unwind Library PHSS_44164 - 11.31 linker + fdp cumulative patch PHSS_44402 - 11.31 linker + fdp cumulative patch For Clusterware HP Serviceguard A.11.20 HP Serviceguard A.11.20 extension for RAC Note:HP Serviceguard is optional. It is required only if you want to use shared logical volumes for Oracle Clusterware or database files. Oracle C++, Oracle C++ Call Interface, Pro*C/C++, Oracle XML Developer's Kit (XDK): Compiler Version: A.06.28 Patch for HP-UX 11i V3 (11.31) on HP-UX Itanium: PHSS_40631 - 11.31 HP C/aC++ Compiler (A.06.24) PHSS_40633 - 11.31 u2comp/be/plugin (C.06.24) PHSS_43741 - 11.31 aC++ Runtime (IA: A.06.28, PA: A.03.90) Note:Additional patches may be needed depending on applications you deploy. Pro*COBOL Micro Focus Server Express 5.1 Micro Focus Visual COBOL for Eclipse 2.2 - Update 2 Pro*FORTRAN - HP FORTRAN/90 - Sep 2008 - release VERITAS File System - PHKL_44199 - 11.31 VRTS 5.0 MP1P13 VRTSvxfs Kernel Patch Note:The VERITAS file system is optional. This patch is required only if you want to use a VERITAS File System 5.0. HP Caliper and Gmake - HP Caliper 5.7, Gmake 3.81 gcc - gcc 4.2.3 | executable_stack 0 ksi_alloc_max 32768 max_thread_proc 1024 maxdsiz 1073741824 (1 GB) maxdsiz_64bit 2147483648 (2 GB) maxfiles 1024 maxfiles_lim 63488 maxssiz 134217728 (128 MB) maxssiz_64bit 1073741824 (1 GB) maxuprc 3686 msgmni 4096 msgtql 4096 ncsize 35840 nflocks 4096 ninode 34816 nkthread 7184 nproc 4096 semmni 4096 semmns 8192 semmnu 4092 semvmx 32767 shmmax 1073741824 shmmni 4096 shmseg 512 tcp_largest_anon_port 65500 udp_largest_anon_port 65500 Guidelines for Setting Kernel Parameter Values If the current value for any parameter is higher than the value listed in this table, then do not change the value of that parameter. Do not specify values for the following parameters as they are obsolete on HP-UX 11.31: msgmap msgseg If you do not use HFS, then retain the default ninode value. |
OS Version | Patches/Packages | Kernel settings |
Oracle Solaris 11.4 (Oracle Solaris 11.4.2.0.1.3.0) or later SRUs and updates Oracle Solaris 11.3 SRU 31 (Oracle Solaris 11.3.31.6.0) or later SRUs and updates Reference : | pkg://solaris/system/library/openmp pkg://solaris/compress/unzip pkg://solaris/developer/assembler pkg://solaris/developer/build/make pkg://solaris/system/dtrace pkg://solaris/system/header pkg://solaris/system/library pkg://solaris/system/linker pkg://solaris/system/xopen/xcu4 (If not already installed as part of standard Oracle Solaris 11 installation) pkg://solaris/x11/diagnostic/x11-info-clients pkg://solaris/system/kernel/oracka (Only for Oracle Real Application Clusters installations) Note: Starting with Oracle Solaris 11.2, if you have performed a standard Oracle Solaris 11 installation, and installed the Oracle Database prerequisites group package oracle-database-preinstall-19c, then you do not have to install these packages, as oracle-database-preinstall-19c installs them for you. For Clusterware Refer Oracle Solaris Cluster Compatibility Guide for more information Pro*COBOL Micro Focus Visual COBOL Development Hub 2.3 - Update 2 Pro*FORTRAN - Oracle Solaris Studio 12 (Fortran 95) VERITAS File System - PHKL_44199 - 11.31 VRTS 5.0 MP1P13 VRTSvxfs Kernel Patch Note:The VERITAS file system is optional. This patch is required only if you want to use a VERITAS File System 5.0. HP Caliper and Gmake - HP Caliper 5.7, Gmake 3.81 gcc - gcc 4.2.3 | project.max-sem-ids 100 process.max-sem-nsems 256 project.max-shm-memory This value varies according to the RAM size. See section “Requirements for Shared Memory Resources” for minimum values. project.max-shm-ids 100 See section “Configuring Additional Shared Memory Identifiers Limit”. tcp_smallest_anon_port 9000 tcp_largest_anon_port 65500 udp_smallest_anon_port 9000 udp_largest_anon_port 65500 Guidelines for Setting Resource Control Parameters Unless otherwise specified, the kernel parameter and shell limit values in the preceding table are minimum values only. Verify that the kernel parameters shown in the preceding table are set to values greater than or equal to the minimum value shown. For production database systems, Oracle recommends that you tune these values to optimize the performance of the system. See your operating system documentation for more information about kernel resource management. If the current value for any parameter is greater than the value listed in the preceding table, then the Fixup scripts do not change the value of that parameter. The project.max-shm-memory resource control value assumes that no other application is using the shared memory segment from this project other than the Oracle instances. If applications, other than the Oracle instances are using the shared memory segment, then you must add that shared memory usage to the project.max-shm-memory resource control value. project.max-shm-memory resource control = the cumulative sum of all shared memory allocated on each Oracle database instance started under the corresponding project. Ensure that memory_target or max_sga_size does not exceed process.max-address-space and project.max-shm-memory. For more information, see My Oracle Support Note 1370537.1. Resource Shell Limit Soft Limit Hard Limit STACK at least 10240 at most 32768 NOFILES at least 1024 at least 65536 MAXUPRC or MAXPROC at least 2047 at least 16384 |
欢迎光临 重庆思庄Oracle、Redhat认证学习论坛 (http://bbs.cqsztech.com/) | Powered by Discuz! X3.2 |