Install > Oracle setup for the model repository > System requirements for Oracle database

System requirements for Oracle database

The following sections list the system requirements for Oracle 11g and 12c. The SA Installer performs an automated check to ensure that these requirements are met on the Oracle host.

The system requirements and configurations listed in this section apply both to the SA-supplied Oracle RDBMS software as well as to non-SA-supplied Oracle RDBMS and software installations.

Note: If you create the database using the Oracle Universal Installer rather than the SA Installer, you must check for these packages and patches manually.
Note: The Oracle database must be installed either on its own host or on a server that has the SA Infrastructure Component bundle installed.

Database server time requirements

Database servers must meet the following requirements. These time requirements do not apply to Managed Servers.

  • All SA database servers must have their time zone set to Coordinated Universal Time (UTC).
  • All SA database servers must maintain synchronized system clocks. Typically, you will synchronize the system clocks through an external server that uses NTP (Network Time Protocol) services.

Linux time configuration

To configure the time zone on a Linux server, copy or link /usr/share/zoneinfo/UTC to /etc/localtime and ensure that the /etc/sysconfig/clock file contains the following lines:

ZONE="UTC"

UTC=true

Hostname setup

  1. You must be able to ping the database server host name. To verify this, enter the following command:

    # ping <hostname>

  2. Check that the database server name is FQDN by using the following command:

    # hostname -f

If the host name is not configured correctly, Oracle will not start and you will encounter the following error:

ORA-00600: internal error code, arguments: [keltnfy-ldmInit], [46], [1], [], [], [], [], []

Hardware requirements

The server that will host the Oracle database for the Model Repository must meet the hardware requirements listed in this section.

  • Linux requirements

    The following are hardware requirements for running Oracle 11g and 12c under Linux.

    For detailed Linux requirements, see the Oracle® Database Quick Installation Guide11g Release 2 (11.2) for Linux x86-64 (Part Number E24326-02) and Oracle® Database Quick Installation Guide12c Release 1 (12.1) for Linux x86-64 (Part Number E17718-09) available at: http://docs.oracle.com

    • Determine the processor type to verify that the processor’s architecture matches the Oracle software release you will install. Use the following command to check system architecture:

      # uname -m

    • The recommended physical memory is 32 GB or more of RAM and 12 CPUs. If the machine running the Oracle database is a virtual machine, then the amount of RAM should be fully allocated to that machine. An SA-supplied Oracle installation will use a minimum of 2 GB memory. The Oracle SGA memory can be increased after database installation. You can use the following command to check memory status:

      grep MemTotal /proc/meminfo

    • Required available swap space is shown below:

      Required available RAM Swap Space

      RAM

      Available Swap Space

      4 GB and 16 GB

      Equal to the size of RAM

      More than 16 GB

      16 GB

      You can use the following command to check swap space:

      grep SwapTotal /proc/meminfo

    • As of Oracle 11g, Automatic Memory Management (AMM) requires more shared memory (/dev/shm) and file descriptors. Shared memory should be sized to be at least the greater of MEMORY_MAX_TARGET and MEMORY_TARGET for each Oracle instance on a database server. You can use the following command to check available shared memory:

      df -h /dev/shm/

    • Free tmp space should be 1GB or more of /tmp directory space. You can use the following command to check tmp space:

      df -h /tmp

  • Solaris requirements

    See Oracle Sun Solaris equirements and HP-UX and IBM AIX version and package requirements.

  • HP-UX and IBM

    Refer to the Checking the Hardware Requirements section in the following Oracle documents:

    • Database Quick Installation Guide for HP-UX Itanium

    • Database Quick Installation Guide for IBM AIX on POWER Systems (64-Bit)

  • Oracle Sun Solaris

    The following are hardware requirements for running Oracle 11g under Oracle Sun Solaris:

    For detailed Solaris requirements, see the Oracle® Database Quick Installation Guide 11g Release 2 (11.2) for Oracle Solaris on SPARC (64-Bit), Part Number E24349-03 and Oracle® Database Quick Installation Guide 12c Release 1 (12.1) for Oracle Solaris on SPARC (64-Bit), Part Number E17756-08 available from http://docs.oracle.com.

    • Determine the processor type to verify that the processor architecture matches the Oracle software release you will install. Use the following command to check system architecture:

      # /bin/isainfo -kv

    • The recommended physical memory is 32 GB or more of RAM. An SA-supplied Oracle installation will use around 2 GB of memory. The Oracle SGA memory can be increased after database installation.

      You can use the following command to check the physical memory:

      /usr/sbin/prtconf | grep "Memory"

  • Solaris operating system-specific patches

    • The following patches for Oracle Sun Solaris 10 must be installed:
      • 120753-06: SunOS 5.10: Microtasking libraries (libmtsk) patch
      • 139574-03: SunOS 5.10
      • 141444-09
      • 141414-02
    • To determine that an operating system patch is installed, enter the following command:

      # /usr/sbin/patchadd -p | grep patch_number(without version number)

    • Required available swap space is shown below:

      Required available swap space

      RAM

      Available Swap Space

      4 GB and 16 GB

      Equal to the size of the RAM

      More than 16 GB

      16 GB

      You can use the following command to check the swap space:

      /usr/sbin/swap -l

    • Free tmp space should be 1GB /tmp directory space.

      You can use the following command to check tmp space:

      df -k /tmp | grep / | awk '{ print $3 }'

    • Required operating system version is: 5.10

      You can use the following command to check the operating system version:

      uname -r

    • To determine the update level of Oracle Solaris installed:

      $ cat /etc/release

  • Model repository (Database) disk space requirements

    Additional disk space is required for the Oracle software and the Model Repository data files. Keep in mind that storage requirements for the database grow as the number of managed servers and database activity grows.

    As a benchmark figure, you should allow an additional 3.5 GB of database storage for every 1,000 servers in the facility that SA manages. When sizing the tablespaces, follow the general guidelines described in the table below. If you need to determine a more precise tablespace sizing, contact your technical support representative.

    Tablespace sizes

    Tablespace

    MB/1000

    Recommended minimum tablespace size

    AAA_DATA

    256 MB

    2000 MB

    AAA_INDX

    256 MB

    2000 MB

    AUDIT_DATA

    256 MB

    2000 MB

    AUDIT_INDX

    256 MB

    2000 MB

    LCREP_DATA

    3000 MB

    8000 MB

    LCREP_INDX

    2000 MB

    8000 MB

    TRUTH_DATA

    1500 MB

    4000 MB

    TRUTH_INDX

    500 MB

    4000 MB

    STRG_DATA

    1300 MB

    2000 MB

    STRG_INDX

    400 MB

    2000 MB

Software requirements

This section lists the requirements for running Oracle 11g and 12c under Red Hat Enterprise Linux, Oracle Enterprise Linux and SUSE Linux Enterprise Server.

  • Linux requirements

    The following are software requirements for running Oracle 11g and 12c under Red Hat Enterprise Linux, Oracle Enterprise Linux and SUSE Linux Enterprise Server:

    • Required operating system version for 11g:
      • Oracle Linux 5 Update 2 (with Red Hat Compatible Kernel)
      • Red Hat Enterprise Linux 5 Update 2
      • Red Hat Enterprise Linux 6
      • SUSE Linux Enterprise Server 10 SP2 (for customer supplied oracle database only)
      • SUSE Linux Enterprise Server 11 (for customer supplied oracle database only)
    • Required operating system version for 12c:
      • Oracle Linux 5 Update 6 (with Red Hat Compatible Kernel)
      • Oracle Linux 6 (with Red Hat Compatible Kernel)
      • Red Hat Enterprise Linux 5 Update 6
      • Red Hat Enterprise Linux 6
      • Red Hat Enterprise Linux 7 (supported only starting with Oracle 12.1.0.2)
      • SUSE Linux Enterprise Server 11 SP2

      You can use the following command to determine the distribution and version of Linux installed:

      # cat /proc/version

    • Required Kernel version for Oracle Database 11g Release 2 (11.2):

      • Oracle Linux 5 Update 2

        2.6.18 or later (with Red Hat Compatible Kernel)

      • Oracle Linux 6

        2.6.32-71.el6.x86_64 or later (with Red Hat Compatible Kernel)

      • Red Hat Enterprise Linux 6

        2.6.32-71.el6.x86_64 or later

      • Red Hat Enterprise Linux 5 Update 2

        2.6.18 or later

      • SUSE Linux Enterprise Server 10 (for customer supplied oracle database only)

        2.6.16.21 or later

      • SUSE Linux Enterprise Server 11 (for customer supplied oracle database only)

        2.6.27.19 or later

    • Required Kernel version for Oracle Database 12c Release 1 (12.1):

      • Oracle Linux 5 Update 6

        2.6.18-238.0.0.0.1.el5 or later

      • Oracle Linux 6 (with Red Hat Compatible Kernel)

        2.6.32-71.el6.x86_64 or later

      • Red Hat Enterprise Linux 5 Update 6

        2.6.18-238.0.0.0.1.el5 or later

      • Red Hat Enterprise Linux 6

        2.6.32-71.el6.x86_64 or later

      • Red Hat Enterprise Linux 7

        3.10.0-54.0.1.el7.x86_64 or later

      • SUSE Linux Enterprise Server 11 SP2 (for customer supplied oracle database only)

        3.0.13-0.27 or later

      You can use the following command to check the kernel versions:

      uname -r

      You can use the following command to check the platform:

      uname -mi

      You can use the following command to check the processor type:

      grep "model name" /proc/cpuinfo

  • Linux package requirements
    • Red Hat Enterprise Linux 5 and Oracle Enterprise Linux 5 for Oracle 11g

      The following or later package versions for Red Hat Enterprise Linux 5 and Oracle Enterprise Linux 5 (with Red Hat compatible kernel) must be installed (shaded rows indicate 32-bit packages):

      Note: Starting with Oracle Database 11g Release 2 (11.2.0.2), all the 32-bit packages, excepting gcc-32bit-4.3, listed in the following table are no longer required for installing a database on Linux x86-64. Only the 64-bit packages are required. However, for any Oracle Database 11g release before 11.2.0.2, both the 32-bit and 64-bit packages listed in the following table are required.

      Required Packages for Red Hat Enterprise Linux 5 and Oracle Enterprise Linux 5 for Oracle 11g

      Required Packages

      Version

      bcNA

      binutils

      2.17.50.0.6

      compat-libstdc++

      33-3.2.3

      compat-libstdc++

      33-3.2.3 (32-bit)

      elfutils-libelf

      0.125

      elfutils-libelf-devel

      0.125

      gcc

      4.1.2

      gcc-c++

      4.1.2

      glibc

      2.5-24

      glibc

      2.5-24 (32-bit)

      glibc-common

      2.5

      glibc-devel

      2.5

      glibc-devel

      2.5 (32-bit)

      glibc-headers

      2.5

      ksh

      NA

      libaio

      0.3.106

      libaio

      0.3.106 (32-bit)

      libaio-devel

      0.3.106

      libaio-devel

      0.3.106 (32-bit)

      libgcc

      4.1.2

      libgcc

      4.1.2 (32-bit)

      libstdc++

      4.1.2

      libstdc++

      4.1.2 (32-bit)

      libstdc++-devel

      4.1.2

      make

      3.81

      sysstat

      7.0.2

    • Red Hat Enterprise Linux 5 and Oracle Enterprise Linux 5 for Oracle 12c

      The following or later package versions for Red Hat Enterprise Linux 5 and Oracle Enterprise Linux 5 (with Red Hat compatible kernel) must be installed (shaded rows indicate 32-bit packages):

      Required Packages for Red Hat Enterprise Linux 5 and Oracle Enterprise Linux 5 for Oracle 12c

      Required Packages

      Version

      bcNA

      binutils

      2.17.50.0.6

      compat-libstdc++

      33-3.2.3

      compat-libstdc++

      33-3.2.3 (32-bit)

      gcc

      4.1.2

      gcc-c++

      4.1.2

      glibc

      2.5-58

      glibc

      2.5-58 (32-bit)

      glibc-common

      2.5

      glibc-devel

      2.5-58

      glibc-devel

      2.5-58 (32-bit)

      ksh

      NA

      libaio

      0.3.106

      libaio

      0.3.106 (32-bit)

      libaio-devel

      0.3.106

      libaio-devel

      0.3.106 (32-bit)

      libgcc

      4.1.2

      libgcc

      4.1.2 (32-bit)

      libstdc++

      4.1.2

      libstdc++

      4.1.2 (32-bit)

      libstdc++-devel

      4.1.2

      libXext

      1.0.1

      libXext

      1.0.1 (32-bit)

      libXtst

      1.0.1

      libXtst

      1.0.1 (32-bit)

      libX11

      1.0.3

      libX11

      1.0.3 (32-bit)

      libXau

      1.0.1

      libXau

      1.0.1 (32-bit)

      libXi

      1.0.1

      libXi

      1.0.1 (32-bit)

      make

      3.81

      sysstat

      7.0.2

    • Red Hat Enterprise Linux 6 and Oracle Enterprise Linux 6 for Oracle 11g

      The following or later package versions for Red Hat Enterprise Linux 6 and Oracle Enterprise Linux 6 (with Red Hat compatible kernel) must be installed:

      Required Packages for Red Hat Enterprise Linux 6 and Oracle Enterprise Linux 6 for Oracle 11g

      Required Packages

      Version

      bcNA

      binutils

      2.20.51.0.2-5.11.el6 (x86_64)

      compat-libcap1

      1-1.10-1 (x86_64)

      compat-libstdc++

      33-3.2.3-69.el6 (x86_64)

      compat-libstdc++

      33-3.2.3-69.el6.i686

      gcc

      4.4.4-13.el6 (x86_64)

      gcc-c++

      4.4.4-13.el6 (x86_64)

      glibc

      2.12-1.7.el6 (x86_64)

      glibc

      2.12-1.7.el6 (i686)

      glibc-devel

      2.12-1.7.el6 (x86_64)

      glibc-devel

      2.12-1.7.el6.i686

      ksh

      NA

      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

      libgcc

      4.4.4-13.el6 (x86_64)

      libgcc

      4.4.4-13.el6 (i686)

      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

      make

      3.81-19.el6

      sysstat

      9.0.4-11.el6 (x86_64)

    • Red Hat Enterprise Linux 6 and Oracle Enterprise Linux 6 for Oracle 12c

      The following or later package versions for Red Hat Enterprise Linux 6 and Oracle Enterprise Linux 6 (with Red Hat compatible kernel) must be installed:

      Required Packages for Red Hat Enterprise Linux 6 and Oracle Enterprise Linux 6 for Oracle 12c

      Required Packages

      Version

      bcNA

      binutils

      2.20.51.0.2-5.11.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)

      gcc

      4.4.4-13.el6 (x86_64)

      gcc-c++

      4.4.4-13.el6 (x86_64)

      glibc

      2.12-1.7.el6 (x86_64)

      glibc

      2.12-1.7.el6 (i686)

      glibc-devel

      2.12-1.7.el6 (x86_64)

      glibc-devel

      2.12-1.7.el6 (i686)

      ksh

      NA

      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)

      libgcc

      4.4.4-13.el6 (x86_64)

      libgcc

      4.4.4-13.el6 (i686)

      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)

      make

      3.81-19.el6

      sysstat

      9.0.4-11.el6 (x86_64)

    • Red Hat Enterprise Linux 7 for Oracle 12c

      The following package versions or later for Red Hat Enterprise Linux 7 must be installed:

      Required Packages for Red Hat Enterprise Linux 7 for Oracle 12c

      Required Packages

      Version

      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.x86_64 (*this requirement can be ignored - Oracle bug 21151912)

      gcc

      4.8.2-3.el7.x86_64

      gcc-c++

      4.8.2-3.el7.x86_64

      glibc

      2.17-36.el7.x86_64

      glibc

      2.17-36.el7.i686

      glibc-devel

      2.17-36.el7.x86_64

      glibc-devel

      2.17-36.el7.i686

      ksh

      NA

      libaio

      0.3.109-9.el7.x86_64

      libaio

      0.3.109-9.el7.i686

      libaio-devel

      0.3.109-9.el7.x86_64

      libaio-devel

      0.3.109-9.el7.i686

      libgcc

      4.8.2-3.el7.x86_64

      libgcc

      4.8.2-3.el7.i686

      libstdc++

      4.8.2-3.el7.x86_64

      libstdc++

      4.8.2-3.el7.i686

      libstdc++-devel

      4.8.2-3.el7.x86_64

      libstdc++-devel

      4.8.2-3.el7.i686

      libXi1.7.2-1.el7.x86_64
      libXi1.7.2-1.el7.i686
      libXtst1.2.2-1.el7.x86_64
      libXtst1.2.2-1.el7.i686

      make

      3.82-19.el7.x86_64

      sysstat

      10.1.5-1.el7.x86_64

    • SUSE Linux Enterprise Server 10 for Oracle 11g

      The following or later package versions for SUSE Linux Enterprise Server 10 must be installed:

      Required Packages for SUSE Linux Enterprise Server 10 for Oracle 11g

      Required Packages

      Version

      bcNA

      binutils

      2.16.91.0.5

      compat-libstdc++

      5.0.7

      gcc

      4.1.0

      gcc-c++

      4.1.2

      glibc

      4.1.2

      glibc-devel

      2.4-31.63

      glibc-devel

      2.4-31.63 (32-bit)

      ksh

      93r-12.9

      libaio

      0.3.104

      libaio

      0.3.104 (32-bit)

      libaio-devel

      0.3.104

      libaio-devel

      0.3.104 (32-bit)

      libelf

      0.8.5

      libgcc

      4.1.2

      libstdc++

      4.1.2

      libstdc++-devel

      4.1.2

      make

      3.80

      numactl

      0.9.6.x86_64

      sysstat

      8.0.4

    • SUSE Linux Enterprise Server 11 for Oracle 11g (for customer supplied oracle database only)

      The following or later package versions for SUSE Linux Enterprise Server 11 must be installed:

      Required Packages for SUSE Linux Enterprise Server 11for Oracle 11g

      Required Packages

      Version

      bcNA

      binutils

      2.19

      gcc

      4.3

      gcc

      4.3 (32-bit)

      gcc-c++

      4.3

      glibc

      2.9

      glibc

      2.9 (32-bit)

      glibc-devel

      2.9

      glibc-devel

      2.9 (32-bit)

      ksh

      93t

      libaio

      0.3.104

      libaio

      0.3.104 (32-bit)

      libaio-devel

      0.3.104

      libaio-devel

      0.3.104 (32-bit)

      libgcc43

      4.3.3_20081022

      libstdc++-devel

      4.3

      libstdc++33

      3.3.3

      libstdc++33

      3.3.3 (32-bit)

      libstdc++43

      4.3.3_20081022

      libstdc++43

      4.3.3_20081022 (32-bit)

      libstdc++43-devel

      4.3.3_20081022

      libstdc++43-devel

      4.3.3_20081022 (32-bit)

      make

      3.81

      sysstat

      8.1.5

    • SUSE Linux Enterprise Server 11 for Oracle 12c(for customer supplied oracle database only)

      The following or later package versions for SUSE Linux Enterprise Server 11 must be installed:

      Required Packages for SUSE Linux Enterprise Server 11 for Oracle 12c

      Required Packages

      Version

      bcNA

      binutils

      2.21.1-0.7.25

      gcc

      4.3-62.198

      gcc-c++

      4.3-62.198

      glibc

      2.11.3-17.31.1

      glibc-devel

      2.11.3-17.31.1

      ksh

      93u-0.6.1

      libaio

      0.3.109-0.1.46

      libaio-devel

      0.3.109-0.1.46

      libcap1

      1.10-6.10

      libgcc46

      4.6.1_20110701-0.13.9

      libstdc++33

      3.3.3-11.9

      libstdc++33

      3.3.3-11.9 (32-bit)

      libstdc++43-devel

      4.3.4_20091019-0.22.17

      libstdc++46

      4.6.1_20110701-0.13.9

      make

      3.81

      sysstat

      8.1.5-7.32.1

      xorg-x11-libs

      7.4 (x86_64)

      xorg-x11-libs

      7.4 (32-bit)

      xorg-x11-libX11

      7.4 (x86_64)

      xorg-x11-libX11

      7.4 (32-bit)

      xorg-x11-libXau

      7.4 (x86_64)

      xorg-x11-libXau

      7.4 (32-bit)

      xorg-x11-libxcb

      7.4 (x86_64)

      xorg-x11-libxcb

      7.4 (32-bit)

      xorg-x11-libXext

      7.4 (x86_64)

      xorg-x11-libXext

      7.4 (32-bit)

Verifying if packages are installed

To verify if RPMs are installed under Linux, enter the following command:

rpm -q --qf '%{NAME}-%{VERSION}-%{RELEASE} (%{ARCH})\n' <rpm_name>

  • Oracle Sun Solaris equirements

    This topic lists the requirements for running Oracle 11g under Oracle Sun Solaris.

    • Required operating system version:
      • Oracle Solaris 10 U6 (5.10-2008.10)
      • Oracle Solaris 11 11/11 SPARC (for Oracle 11.2.0.3 only)
  • You can use the following command to determine the distribution and version of Solaris installed:

    # uname -r

    • You can use the following to determine the update level of Oracle Solaris installed:

      $ cat /etc/release

  • Solaris package requirements

    The following packages (or later versions) are required for Oracle Database 11g Release 2 (11.2) on Oracle Solaris 10:

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

    To verify whether these packages are installed on the OS, enter the following command:

    # pkginfo -i SUNWarc SUNWbtool SUNWhea SUNWlibC SUNWlibms SUNWsprot \
      SUNWtoo SUNWi1of SUNWi1cs SUNWi15cs SUNWxwfnt

  • HP-UX and IBM AIX version and package requirements

    For HP-UX and IBM AIX operating system, compiler, patch and any additional software requirements, see the Checking the Software Requirements section in the Oracle® Database Quick Installation Guide for your operating system.