Oracle
Database (RDBMS) on Unix AIX,HP-UX,Linux,Solaris and MS Windows
Operating Systems Installation and Configuration Requirements Quick
Reference (12.1) (文档 ID 1587357.1)
In this Document
|
Purpose |
|
Scope |
|
Details |
DISCLAIMER |
PRE-INSTALLATION SCRIPTS |
OPatch FAQ |
12.1.x |
Common Requirements |
Oracle Linux 5 / RHEL 5 |
Oracle Linux 6 / RHEL 6 |
Oracle Linux 7 / RHEL 7 |
SLES 11 |
Solaris 10 |
Solaris 11 |
AIX 6.1/7.1 |
AIX 7.2 |
HP-UX (Itanium) |
MS Windows |
Engineered Systems |
Linux OS Handy references |
Solaris handy references |
AIX handy reference |
HP-UX handy reference |
MS Windows reference |
|
References |
Applies to:
Oracle Database - Enterprise Edition - Version 12.1.0.1 and laterGeneric UNIX
Generic Linux
Purpose
This
bulletin is produced to provide a central source for all the primary
installation 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 note for
an OS/Oracle version has been done to ensure that this bulletin
provides the most complete source of data in hopes that it will save
time for each researching analyst.
Keeping the OS kernel
current helps stabilize the system. Production systems should never run
an out dated OS kernel version. As a best practice, Oracle recommends
the OS kernel version be maintained to within 6 months of current.
Please contact the OS vendor directly for more information, risk
exposure, and patching recommendations.
NOTE 1:
As of now ,12.1 Database is released only for Linux & Solaris
,hence the note has the information 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 Certified Compilers
Scope
This focus of this bulletin is on assisting the Oracle Unix
installation community in resolving installation issues of the RDBMS.
This
bulletin places in one document all the pertinent information related
to installations that has been extracted from three different documents
(Installation Guides, Release Notes, and SRNs)
Details
DISCLAIMER
Whenever a contradiction arises between this document and My Oracle Support (MOS)-Certification, My Oracle Support (MOS)-Certification is the Certification authority. Users of this bulletin are obligated to provide real-time corrections/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 Remote Diagnostic Agent RDA (Note 314422.1 for more info on RDA) has the capability to run a Pre-Installation check on several Unix Platforms.
Please refer to (Note 250262.1 RDA - Health Check / Validation Engine Guide ) for specifics on how to run these Pre-Install scripts on your server.
OPatch FAQ
To apply one-off patches and Critical Patch Updates (CPUs) or Patch
Set Update (PSU) ,you have to use the patching utility, OPatch. Oracle
Support requests you always use the latest version before applying any
patches to your server, to get the latest version,
For 12.1 Patch 6880880
Master Note For OPatch Note 293369.1
OPatch - Where Can I 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.5.0_24) 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) |
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 65500net.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 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 65500net.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 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
|
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 Note: This value limits concurrent outstanding requests and should be set to avoid I/O subsystem failures. net.ipv4.ip_local_port_range=9000 65500net.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
|
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.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 |
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
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.
|
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
|
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 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++, For Pro*COBOL - IBM COBOL for AIX Version 4.1.1 (March 2012 PTF), Micro Focus Server Express 5.1
|
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 Shell limits
Soft File Descriptors at least 1024 KB
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
OS Version | Patches/Packages | Kernel settings |
AIX 7.2 Technology Level 0 Service Pack 1 ("7200-00-01") or later, 64-bit kernel Note: Service Pack 1 is mandatory. |
The following operating system filesets are required:
The following, or later, patches are required:
Oracle C++
Pro*COBOL - IBM COBOL for AIX Version 4.1.1 (March 2012 PTF)
Pro*FORTRAN - IBM XL Fortran Runtime for AIX, Version 13.1, January 2012 PTF |
tcp_ephemeral_low = 32768 Shell limits
Soft File Descriptors at least 1024 KB
maxuprocs 16384 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++, 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 0ksi_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_portudp_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 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/IPTCP/IP with SSL Named Pipes |
- NA -
|
Engineered Systems
Exadata Database Machine and Exadata Storage Server Supported Versions - Note 888828.1
Oracle Database Appliance - 12.1.2 and 2.X Supported ODA Versions & Known Issues - Note 888888.1
Oracle SuperCluster Supported Software Versions - All Hardware Types - Note 1567979.1
Note: Engineered systems have specific requirements that are different then the standard OS
Linux OS Handy references
How to Verify You Have an Oracle Supported Kernel. - Note 225710.1
Things to know about Linux. - Note 265262.1
Is It Mandatory To Install UEK Kernel Under RHEL? - Note 1508516.1
Maximum SHMMAX values for Linux x86 and x86-64. - Note 567506.1
12.1.x.x - Installation Documentation for Linux URL - http://docs.oracle.com/cd/E16655_01/install.121/e17720/toc.htm
Solaris handy references
How to Set the Ulimit Values for Solaris. - Note 1007442.1
Kernel setup for Solaris 10 and Solaris 11 using project files. - Note 429191.1
The Oracle Solaris 11 Package Branch Version Scheme. - Note 1378134.1
Configuring X-Server Display For Oracle Universal Installer (OUI) On Solaris 11 Platforms. - Note 1578758.1
Defining Solaris 11 Standard Installation. - Note 1557986.1
12.1.x.x - Installation Documentation for Solaris. URL - http://docs.oracle.com/cd/E16655_01/install.121/e17752/toc.htm
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 "
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 http://docs.oracle.com/cd/E16655_01/install.121/e18445/toc.htm
HP-UX handy reference
To verify if the system 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 shared memory kernel parameters (shmmni, shmseg, and
shmmax) and determine if any changes 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 http://docs.oracle.com/cd/E16655_01/install.121/e40020/toc.htm
MS Windows reference
12.1.x.x - Installation documentation for MS Windows URL http://docs.oracle.com/cd/E16655_01/install.121/e17735/toc.htm