|
Oracle Database (RDBMS) on Unix AIX,HP-UX,Linux,Solaris and MS Windows Operating Systems Installation and Configuration Requirements Quick Reference (12.1/12.2/18c/19c) (Doc ID 1587357.1)
In this Document
APPLIES TO:
OracleDatabase Cloud Schema Service - Version N/A and later
Gen 1 Exadata Cloud at Customer (Oracle ExadataDatabase Cloud Machine) - Version N/A and later
Oracle Database Exadata Express Cloud Service -Version N/A and later
Oracle Cloud Infrastructure - Database Service -Version N/A and later
Oracle Database Backup Service - Version N/A andlater
Generic UNIX
Generic Windows
Generic Linux
PURPOSE
Thisbulletin is produced to provide a central source for all the primaryinstallation settings for the various mainstream unix platforms, e.g. IBM AIX,HP-UX, Oracle Solaris, Tru64, and Linux.
Careful comparison of the Installation Guide and the applicable release notefor an OS/Oracle version has been done to ensure that this bulletin providesthe most complete source of data in hopes that it will save time for eachresearching analyst.
Keeping the OS kernel current helps stabilize the system. Production systemsshould never run an out dated OS kernel version. As a best practice, Oraclerecommends the OS kernel version be maintained to within 6 months of current.Please contact the OS vendor directly for more information, risk exposure, andpatching recommendations.
NOTE 1: As of now ,12.1Database is released only for Linux & Solaris ,hence the note has theinformation only for these platforms.
NOTE 2: Pre-compilers requirements are no longer addressed in this note,for a single source note
that addresses Pre-compiler/Compiler requirements, please refer to:
Note 43208.1 CertifiedCompilers
SCOPE
This focus of thisbulletin is on assisting the Oracle Unix installation community in resolvinginstallation issues of the RDBMS.
This bulletin places in one document all the pertinent information related toinstallations that has been extracted from three different documents(Installation Guides, Release Notes, and SRNs)
DETAILS
DISCLAIMER
Whenever acontradiction arises between this document and My Oracle Support(MOS)-Certification, My Oracle Support (MOS)-Certification is the Certificationauthority. Users of this bulletin are obligated to provide real-timecorrections/updates in the form of My Oracle Support (MOS) "Feedback"submissions to ensure the accuracy and up-to-date status of this bulletin.
PRE-INSTALLATION SCRIPTS
The RemoteDiagnostic Agent RDA ( Note 314422.1 for more info on RDA) has the capabilityto run a Pre-Installation check on several Unix Platforms.
Please refer to ( Note 250262.1 RDA - Health Check / Validation EngineGuide ) for specifics on how to run these Pre-Install scripts on yourserver.
OPatch FAQ
To apply one-offpatches and Critical Patch Updates (CPUs) or Patch Set Update (PSU) ,you haveto use the patching utility, OPatch. Oracle Support requests you always use thelatest version before applying any patches to your server, to get the latestversion,
For 12.1 Patch6880880
Master Note For OPatch Note293369.1
OPatch - Where CanI Find the Latest Version of OPatch? [Video] ( Note 224346.1)
12.1.x
Common Requirements
- JDK 1.6 is installed with this release.
- On Solaris 10 - JDK 7 (Java SE Development Kit release 1.7.0) is supported
- RAM – Minimum - 1 GB of RAM. Recommended: 2GB of RAM or more
- Swap - 1.5 times the size of RAM
- - Between 2 GB and 16 GB of RAM - Equal to the size of RAM
- - More than 16 GB RAM – 16 GB
- Disk space - ~ 6.5 GB -Database Software Files. + additional at least 2 GB for preconfigured db, 1.0GB /tmp
Oracle Linux 5 / RHEL 5
OS Version / Kernel version Patches/Packages Kernel settings
Oracle Linux 5 Update 6 with the Unbreakable Enterprise kernel: 2.6.32-100.0.19 or later Oracle Linux 5 Update 6 with the Red Hat compatible kernel: 2.6.18-238.0.0.0.1.el5 or later Red Hat Enterprise Linux 5 Update 6 2.6.18-238.0.0.0.1.el5 or later Red Hat Enterprise Linux 5 Update 6 with the Unbreakable Enterprise Kernel: 2.6.32-100.0.19 or later Reference : binutils-2.17.50.0.6 (x86_64)
compat-libstdc++-33-3.2.3 (x86_64)
glibc-2.5-58 (x86_64)
ksh <== any version of ksh is acceptable
libaio-0.3.106 (x86_64)
libgcc-4.1.2 (x86_64)
libstdc++-4.1.2 (x86_64)
libXext-1.0.1 (x86_64)
libXtst-1.0.1 (x86_64)
libX11-1.0.3 (x86_64)
libXau-1.0.1 (x86_64)
libXi-1.0.1 (x86_64)
make-3.81 (x86_64)
gcc-4.1.2 (x86_64)
gcc-c++-4.1.2 (x86_64)
glibc-devel-2.5-58 (x86_64)
libaio-devel-0.3.106 (x86_64)
libstdc++-devel-4.1.2 (x86_64)
sysstat-7.0.2 (x86_64) 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
Oracle Linux 6 / RHEL 6
| 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 |
Oracle Linux 7 / RHEL 7
| 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 |
SLES 11
| 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 |
SLES 12
| 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
- system to read the /etc/sysctl.conf file when it restarts
/sbin/chkconfig boot.sysctl on ;
- echo 501 > /proc/sys/vm/hugetlb_shm_group ;
GID of the oinstall group (in this example GID=500). Grants members of oinstall a group permission to create shared memory segments
- Change this line in /etc/sysctl.conf
vm.hugetlb_shm_group=501 ; |
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 : | 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) |
Solaris 11
| 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) |
AIX 6.1/7.1
| 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.
|
AIX 7.2
| AIX7.2 | | | | 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. |
HP-UX (Itanium)
| 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 |
MS Windows
| 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 - |
12.2.x
Common Requirements
- JDK 8 (64-bit 8.0.0.0 or later) with the JNDI extension with Oracle Java Database Connectivity and Oracle Call Interface drivers. Note: This is not a mandatory requirements for database installation.
- On Solaris 10 - JDK 7 (Java SE Development Kit release 1.7.0) is supported
- RAM – Minimum - 1 GB of RAM. Recommended: 2GB of RAM or more
- Swap - 1.5 times the size of RAM
- - Between 2 GB and 16 GB of RAM - Equal to the size of RAM
- - More than 16 GB RAM – 16 GB
- Disk space - 11 GB -Database Software Files. + additional at least 2 GB for preconfigured db, 1.0GB /tmp
AIX 6.1/7.1
| 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 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.
|
AIX 7.2
| AIX7.2 | | | | 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 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
| SLES 12 | | | | SUSE Linux Enterprise Server 12 SP1: 3.12.49-11.1 or later | 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
| Solaris 11 | | | | 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
| Solaris 10 | | | | 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
| 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
| 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
| 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 |
MS Windows
| 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 - |
18.3.x
Common Requirements
- JDK 8 (Java SE Development Kit) is installed with this release.
- RAM – Minimum - 1 GB of RAM. Recommended: 2GB of RAM or more. 8 GB RAM for Oracle Grid Infrastructure installations.
- Swap - 1.5 times the size of RAM
- - Between 2 GB and 16 GB of RAM - Equal to the size of RAM
- - More than 16 GB RAM – 16 GB
Note: If youenable HugePages for your Linux servers, then you should deduct the memoryallocated to HugePages from the available RAM before calculating swapspace. Configure swap for your expected system loads. This installationguide provides minimum values for installation only.
- Disk space - ~ 10 GB (a general requirement considering for all platforms. For individual requirement refer to Oracle documentation) - Database Software Files. + additional at least 2 GB for preconfigured db, 1.0GB /tmp
Note: Oracle recommendsthat you allocate approximately 100 GB to allow additional space for applyingany future patches on top of the existing Oracle home. For specificpatch-related disk space requirements, please refer to your patchdocumentation.
Oracle Linux 6
| Oracle Linux 6 | | | | 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 | 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:
- Unless otherwise specified, the kernel parameter and shell limit values shown in the following table are minimum values only. For production database systems, Oracle recommends that you tune these values to optimize the performance of the system. See the operating system documentation for more information about tuning kernel parameters.
- If the current value for any parameter is greater than the value listed in this table, then the Fixup scripts do not change the value of that parameter.
|
Oracle Linux 7
| Oracle Linux 7 | | | | 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 | 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:
- Unless otherwise specified, the kernel parameter and shell limit values shown in the following table are minimum values only. For production database systems, Oracle recommends that you tune these values to optimize the performance of the system. See the operating system documentation for more information about tuning kernel parameters.
- If the current value for any parameter is greater than the value listed in this table, then the Fixup scripts do not change the value of that parameter.
|
RHEL 6
| RHEL 6 | | | | Red Hat Enterprise Linux 6.4: 2.6.32-358.el6.x86_64 or later | 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:
- Unless otherwise specified, the kernel parameter and shell limit values shown in the following table are minimum values only. For production database systems, Oracle recommends that you tune these values to optimize the performance of the system. See the operating system documentation for more information about tuning kernel parameters.
- If the current value for any parameter is greater than the value listed in this table, then the Fixup scripts do not change the value of that parameter.
|
RHEL 7
| RHEL 7 | | | | Red Hat Enterprise Linux 7: 3.10.0-123.el7.x86_64 or later | 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:
- Unless otherwise specified, the kernel parameter and shell limit values shown in the following table are minimum values only. For production database systems, Oracle recommends that you tune these values to optimize the performance of the system. See the operating system documentation for more information about tuning kernel parameters.
- If the current value for any parameter is greater than the value listed in this table, then the Fixup scripts do not change the value of that parameter.
|
Solaris 10
| Solaris 10 | | | | 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.htmlEnsure 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
| Solaris 11 | | | | 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
|
AIX 6.1/7.1
| 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.
|
AIX 7.2
| AIX7.2 | | | | 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 |
SLES 12
| 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
- system to read the /etc/sysctl.conf file when it restarts
/sbin/chkconfig boot.sysctl on ;
- echo 501 > /proc/sys/vm/hugetlb_shm_group ;
GID of the oinstall group (in this example GID=500). Grants members of oinstall a group permission to create shared memory segments
- Change this line in /etc/sysctl.conf
vm.hugetlb_shm_group=501 ; |
HP-UX
| 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. |
19c
Common Requirements
- RAM – Minimum - 1 GB of RAM. Recommended: 2GB of RAM or more
- Swap - 1.5 times the size of RAM
- - Between 2 GB and 16 GB of RAM - Equal to the size of RAM
- - More than 16 GB RAM – 16 GB
- Disk space - 11 GB -Database Software Files. + additional at least 2 GB for preconfigured db, 1.0GB /tmp
Oracle Linux 7
| Oracle Linux 7 | | | | 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 | 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.htmlFor 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:
- Unless otherwise specified, the kernel parameter and shell limit values shown in the following table are minimum values only. For production database systems, Oracle recommends that you tune these values to optimize the performance of the system. See the operating system documentation for more information about tuning kernel parameters.
- If the current value for any parameter is greater than the value listed in this table, then the Fixup scripts do not change the value of that parameter.
- Oracle recommends that you disable Transparent HugePages before you start installation.
Transparent HugePages memory differs from standard HugePages memory because the kernel khugepaged thread allocates memory dynamically during runtime. Standard HugePages memory is pre-allocated at startup, and does not change during runtime.
|
RHEL 7
| RHEL 7 | | | | Red Hat Enterprise Linux 7.5: 3.10.0-862.11.6.el7.x86_64 or later | 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:
- Unless otherwise specified, the kernel parameter and shell limit values shown in the following table are minimum values only. For production database systems, Oracle recommends that you tune these values to optimize the performance of the system. See the operating system documentation for more information about tuning kernel parameters.
- If the current value for any parameter is greater than the value listed in this table, then the Fixup scripts do not change the value of that parameter.
- Oracle recommends that you disable Transparent HugePages before you start installation.
Transparent HugePages memory differs from standard HugePages memory because the kernel khugepaged thread allocates memory dynamically during runtime. Standard HugePages memory is pre-allocated at startup, and does not change during runtime.
|
SLES 12
| SLES 12 | | | | 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:
- Unless otherwise specified, the kernel parameter and shell limit values shown in the following table are minimum values only. For production database systems, Oracle recommends that you tune these values to optimize the performance of the system. See the operating system documentation for more information about tuning kernel parameters.
- If the current value for any parameter is greater than the value listed in this table, then the Fixup scripts do not change the value of that parameter.
- Oracle recommends that you disable Transparent HugePages before you start installation.
Transparent HugePages memory differs from standard HugePages memory because the kernel khugepaged thread allocates memory dynamically during runtime. Standard HugePages memory is pre-allocated at startup, and does not change during runtime.
|
SLES 15
| SLES 15 | | | | 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:
- Unless otherwise specified, the kernel parameter and shell limit values shown in the following table are minimum values only. For production database systems, Oracle recommends that you tune these values to optimize the performance of the system. See the operating system documentation for more information about tuning kernel parameters.
- If the current value for any parameter is greater than the value listed in this table, then the Fixup scripts do not change the value of that parameter.
- Oracle recommends that you disable Transparent HugePages before you start installation.
Transparent HugePages memory differs from standard HugePages memory because the kernel khugepaged thread allocates memory dynamically during runtime. Standard HugePages memory is pre-allocated at startup, and does not change during runtime.
|
AIX 7.1
| AIX7.1 | | | | 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 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) |
AIX 7.2
| AIX7.2 | | | | 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 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) |
HP-UX
| 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. |
Solaris 11
| 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 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
|
Engineered Systems
Exadata DatabaseMachine and Exadata Storage Server Supported Versions - Note 888828.1
Oracle Database Appliance - 12.1.2 and 2.X Supported ODA Versions & KnownIssues - Note 888888.1
Oracle SuperCluster Supported Software Versions - All Hardware Types - Note 1567979.1
Note: Engineeredsystems have specific requirements that are different then the standard OS
Linux OS Handy references
Solaris handy references
AIX handy reference
/usr/sbin/no -a |fgrep ephemeral ; to check udp/tcp kernel parameters
oslevel -s ; to verify osversion and TLs
lslpp -l ; To determine if the required filesets are installed and committed
/usr/sbin/instfix -i -k "<APAR Number>" ; To determine if anAPAR is installed
ioo –o aio_maxreqs ; to check current Sysnchronous Input Output value
smit chgsys ; to set Maximum number of processes
getconf KERNEL_BITMODE ; determine the supported kernel mode,
12.1.x.x - Installation documentation for AIX https://docs.oracle.com/database/121/AXDBI/toc.htm
HP-UX handy reference
To verify if thesystem meets the minimum patch bundle requirements, use the following command:
# /usr/sbin/swlist -l bundle |grep QPK
To determine if a patch is installed, enter a command similar to the following:
# /usr/sbin/swlist -l patch | more
To determine the compiler installed, enter the following command:
# /usr/sbin/swlist -l product | grep -i compiler
To view the sharedmemory kernel parameters (shmmni, shmseg, and shmmax) and determine if anychanges are necessary for your system., run the following command:
# kctune -v shmmni# kctune -v shmseg
# kctune -v shmmax
12.1.x.x - Installation documentation for HP-UX Itanium https://docs.oracle.com/database/121/HPDBI/toc.htm
MS Windows reference
Orachk reference
Download andinstall orachk utility refer - ORAchk - Health Checks for the OracleStack (Doc ID 1268927.2)
To Run orachkexecute
./orachk
in silent mode
./orachk -s
Orachkdocumentation can be accessed here.
|
|手机版|小黑屋|重庆思庄Oracle、Redhat认证学习论坛
( 渝ICP备12004239号-4 )
发表于 2020-8-25 09:28:13
QQ好友和群
QQ空间
腾讯微博
腾讯朋友
收藏
支持
反对