About DATABASE

I. Hardware:
===========
  1. Minimum Hardware Requirements
    a.) At least 1.0 Gb (1024 MB) of physical RAM
    b.) Swap disk space proportional to the system's physical memory as follows: 

         RAM                                Swap Space
         1024 Mb to 2048 Mb      1.5 x RAM
         2049 Mb to 16 Gb           1 x RAM 
         greater than 16 Gb            16 Gb

    c.) 1024 Mb of disk space (and less than 2Tb of disk space) in the /tmp directory.
    d.) 3.8 Gb of local disk space for the database software.
    e.) 1.7 Gb of disk space for a preconfigured database that uses file system storage (optional)


II. Software:
============
  1. As is specified in section 1.3.1 of the Oracle Database Installation Guide for 11gR2 on Linux (part number E10840-01), Oracle recommends that you install the Linux operating system with the default software packages (RPMs) and do not customize the RPMs during installation. For additional information on "default-RPMs", please see Note 376183.1, "Defining a "default RPMs" installation of the RHEL OS"

  2. Red Hat Enterprise Linux AS/ES 4 update 7 (or greater), which is Kernel 2.6.9-78.EL or newer.

  3. Required OS Components (per Release Notes, and Install Guide)
    a.) The exact version number details of this list are based upon 64-bit (x86-64) RHEL AS 4 update 7. When a newer "update" level is used, the RPM release numbers (such as 2.6.9-78) may be slightly higher (such as 2.6.9-83 or 2.6.9-95). Since RHEL AS/ES 4 "update" levels of "update 7" and beyond are certified, this is fine so long as you are still using 64-bit Linux (x86-64) RHEL AS/ES 4 RPMs.
    b.) Some of the Install Guide requirements will already be present from the "default-RPMs" foundation of Linux that you started with:
        1.) binutils-2.15.92.0.2-25 (x86_64)
        2.) compat-libstdc++-33-3.2.3-47.3 (x86_64) << both ARCH's are required. See next line.
        3.) compat-libstdc++-33-3.2.3-47.3 (i386) << both ARCH's are required. See previous line.
        4.) elfutils-libelf-0.97.1-5 (x86_64)
        5.) expat-1.95.7-4 (x86_64)
        6.) glibc-2.3.4-2.41 (x86_64) << both ARCH's are required. See next line.
        7.) glibc-2.3.4-2.41 (i686) << both ARCH's are required. See previous line.
        8.) glibc-common-2.3.4-2.41 (x86_64)
        9.) libaio-0.3.105-2 (i386) << both ARCH's are required. See next section.
        10.) libgcc-3.4.6-10 (x86_64) << both ARCH's are required. See next line.
        11.) libgcc-3.4.6-10 (i386) << both ARCH's are required. See previous line.
        12.) libstdc++-3.4.6-10 (x86_64) << both ARCH's are required. See next line.
        13.) libstdc++-3.4.6-10 (i386) << both ARCH's are required. See previous line.
        14.) make-3.80-7.EL4 (x86_64)
        15.) pdksh-5.2.14-30.6 (x86_64)
        16.) unixODBC-2.2.11-1.RHEL4.1 (x86_64) << both ARCH's are required. See next line.
        17.) unixODBC-2.2.11-1.RHEL4.1 (i386) << both ARCH's are required. See previous line.


    c.) The remaining Install Guide requirements will have to be installed:
        1.) elfutils-libelf-devel-0.97.1-5.x86_64.rpm
        2.) glibc-headers-2.3.4-2.41.x86_64.rpm will be required as a prerequisite
            a.) glibc-kernheaders-2.4-9.1.103.EL.x86_64.rpm will be required as a prerequisite
        3.) glibc-devel-2.3.4-2.41.x86_64.rpm << both ARCH's are required. See next section.
        4.) gcc-3.4.6-10.x86_64.rpm
        5.) libaio-0.3.105-2.x86_64.rpm << both ARCH's are required. See previous section.
        6.) libaio-devel-0.3.105-2.x86_64.rpm << both ARCH's are required. See next line.
        7.) libaio-devel-0.3.105-2.i386.rpm << both ARCH's are required. See previous line.
        8.) libstdc++-devel-3.4.6-10.x86_64.rpm
        9.) gcc-c++-3.4.6-10.x86_64.rpm 
      10.) sysstat-5.0.5-19.el4.x86_64.rpm
      11.) unixODBC-devel-2.2.11-1.RHEL4.1.x86_64.rpm << both ARCH's are required. See next line.
      12.) unixODBC-devel-2.2.11-1.RHEL4.1.i386.rpm << both ARCH's are required. See previous line.

  4. Additional Required OS Components (per the runInstaller OUI)
    a.) intentionally blank

  5. Additional Required OS Components (per this NOTE)
    a.) Please do not rush, skip, or minimize this critical step. This list is based upon a "default-RPMs" installation of 64-bit (x86-64) RHEL AS/ES 4. Additional RPMs (beyond anything known to Oracle) may be needed if a "less-than-default-RPMs" installation of 64-bit (x86-64) RHEL AS/ES 4 is performed. For more information, please refer to Note 376183.1, "Defining a "default RPMs" installation of the RHEL OS"
    b.) glibc-devel-2.3.4-2.41.i386.rpm << both ARCH's are required. See previous section.
    c.) Several RPMs will be required as prerequisites to those listed in section II.3.c:
        1.) glibc-kernheaders-2.4-9.1.103.EL.x86_64.rpm
        2.) itentionally blank

  6. Oracle Global Customer Support has noticed a recent trend with install problems that originates from installing too many RPMs. For example:
    a.) installing your own JDK version (prior to beginning the Oracle Software “runInstaller”) is not needed on Linux, and is not recommended on Linux. A pre-existing JDK often interferes with the correct JDK that the Linux Oracle Software “runInstaller” will place and use.
    b.) installing more than the required version of the gcc / g++ RPMs often leads to accidentally using (aka enabling or activating) the incorrect one. If you have multiple RDBMS versions installed on the same Linux machine, then you will likely have to manage multiple versions of gcc /g++ . For more information, please see Note 444084.1, "Multiple gcc / g++ Versions in Linux"

  7. All of the RPMs in section II. are on the Red Hat Enterprise Linux AS/ES 4 64-bit (x86-64) distribution media.

III. Environment:
================
  1. Modify your kernel settings in /etc/sysctl.conf (RedHat) as follows. If the current value for any parameter is higher than the value listed in this table, do not change the value of that parameter. Range values (such as net.ipv4.ip_local_port_range) must match exactly.
    kernel.shmall = physical RAM size / pagesize For most systems, this will be the value 2097152. See Note 301830.1 for more information.
    kernel.shmmax = 1/2 of physical RAM, but not greater than 4GB. This would be the value 2147483648 for a system with 4Gb of physical RAM.
    kernel.shmmni = 4096
    kernel.sem = 250 32000 100 128
    fs.file-max = 512 x processes (for example 6815744 for 13312 processes)
    fs.aio-max-nr = 1048576
    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 

  2. To activate these new settings into the running kernel space, run the “sysctl –p” command

  3. The gcc and g++ RPM items above will ensure that the correct gcc / g++ versions are installed. It is also required that you ensure that these correct gcc / g++ versions are active, and in-use. Ensure that the commands "gcc --version" and "g++ --version" each return "3.4.x".

  4. Set Shell Limits for the oracle User. Assuming that the "oracle" Unix user will perform the installation, do the following:

    a.) Add the following settings to /etc/security/limits.conf
         oracle soft nproc 2047
         oracle hard nproc 16384
         oracle soft nofile 1024
         oracle hard nofile 65536

    b.) Add or edit the following line in the /etc/pam.d/login file, if it does not already exist:
         session required pam_limits.so

    c.) Add the following lines to /etc/profile:
         if [ $USER = "oracle" ]; then 
            if [ $SHELL = "/bin/ksh" ]; then
               ulimit -p 16384
               ulimit -n 65536
            else
               ulimit -u 16384 -n 65536
            fi
         fi


  5. The hostname command should return the fully qualified hostname as shown
below:
      % hostname 
          hostname.domainname

  6. If any Java packages are installed on the system, unset the Java environment variables, for example JAVA_HOME.

  7. The oracle account used to install Oracle 11.2.0.1, should not have the Oracle install related variables set by default. For example setting ORACLE_HOME, PATH, LD_LIBRARY_PATH to include Oracle binaries in .profile, .login file and /etc/profile.d should be completely avoided.
    a.) Setting $ORACLE_BASE (not $ORACLE_HOME) is recommended, since it eases a few prompts in the OUI runInstaller tool.
    b.) following the succesful install, it is recommended to set $ORACLE_HOME, and to set $PATH to include the Oracle binaries ($ORACLE_HOME/bin) as the first location.

  8. Log in as Oracle user and start the installation as follows:
     ./runInstaller

    a.) When performing the 11.2.0.1 installation, make sure to use the "runInstaller" version that comes with 11.2.0.1 software. 
    b.) When performing any subsequent 11.2.0.x patchset, make sure to use the "runInstaller" version that comes with the patchset. 
    c.) it is best practice not to use any form of "su" to start the runInstaller, in order to avoid potential display-related problems



ADDITIONAL NOTES
----------------
1. Supported distributions of the 32-bit (x86) Linux OS can run on on AMD64/EM64T and Intel Processor Chips that adhere to the x86_64 architecture
  a.) Oracle 32-bit running on AMD64/EM64T with 32-bit OS is supported, but is NOT covered by this NOTE.
  b.) Oracle 32-bit running on AMD64/EM64T with 64-bit OS is not certified and is not supported.

2. Asynchronous I/O on ext2 and ext3 file systems is supported if your scsi/fc driver supports that functionality.

3. No extra patch is required for the DIRECTIO support for x86-64.

4. No LD_ASSUME_KERNEL value should be used with the 11gR2 product.

5. Following rpm command can be used to distinguish between a 32-bit or 64-bit package.
    #rpm -qa --queryformat "%{NAME}-%{VERSION}-%{RELEASE} (%{ARCH})\n" | grep glibc-devel
     glibc-devel-2.3.4-2.41 (i386)
     glibc-devel-2.3.4-2.41 (x86_64)