RDBMS on Unix AIX..OS Install and Config Require Quick Refere(12.1)-1587357.1

rongshiyuan發表於2013-12-23


Oracle Database (RDBMS) on Unix AIX,HP-UX,Linux,Solaris Operating Systems Installation and Configuration Requirements Quick Reference (12.1) (Doc 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
  SLES 11
  Solaris 10
  Solaris 11
  AIX
  HP-UX
  Linux OS Handy references
  Solaris handy references
References

Applies to: 

Oracle Database - Enterprise Edition - Version 12.1.0.1 and later
Generic 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 :

Note 1529433.1

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 = 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    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 :

Note 1529864.1

 

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 = 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    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 :

Note 1519770.1

 

 

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 = 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    1024
oracle   hard   nofile    65536
oracle   soft    stack    10240
oracle   hard   stack    10240

 

Solaris 10

OS Version

Patches/Packages

Kernel settings

Oracle Solaris 10 Update 10 (Oracle Solaris 10 8/11 s10s_u10wos_17b) or later.

Reference :

Note 1517948.1

 

 

SUNWarc
SUNWbtool
SUNWcsl
SUNWdtrc
SUNWhea
SUNWi1cs (ISO8859-1)
SUNWi15cs (ISO8859-15)
SUNWi1of
SUNWlibC
SUNWlibm
SUNWlibms
SUNWsprot
SUNWtoo
SUNWxwfnt

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

Reference :

Note 1525614.1

 

 

SUNWdtrc
/x11/diagnostic/x11-info-clients
/developer/build/make
system/xopen/xcu4

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 least 10240 (soft limit), at least 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

For release information refer to "Release Schedule of Current Database Releases (Doc ID 742060.1)"

HP-UX

For release information refer to "Release Schedule of Current Database Releases (Doc ID 742060.1)"

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

 

來自 “ ITPUB部落格 ” ,連結:http://blog.itpub.net/17252115/viewspace-1064022/,如需轉載,請註明出處,否則將追究法律責任。

相關文章