Searching the Help
To search for information in the Help, type a word or phrase in the Search box. When you enter a group of words, OR is inferred. You can use Boolean operators to refine your search.
Results returned are case insensitive. However, results ranking takes case into account and assigns higher scores to case matches. Therefore, a search for "cats" followed by a search for "Cats" would return the same number of Help topics, but the order in which the topics are listed would be different.
Search for | Example | Results |
---|---|---|
A single word | cat
|
Topics that contain the word "cat". You will also find its grammatical variations, such as "cats". |
A phrase. You can specify that the search results contain a specific phrase. |
"cat food" (quotation marks) |
Topics that contain the literal phrase "cat food" and all its grammatical variations. Without the quotation marks, the query is equivalent to specifying an OR operator, which finds topics with one of the individual words instead of the phrase. |
Search for | Operator | Example |
---|---|---|
Two or more words in the same topic |
|
|
Either word in a topic |
|
|
Topics that do not contain a specific word or phrase |
|
|
Topics that contain one string and do not contain another | ^ (caret) |
cat ^ mouse
|
A combination of search types | ( ) parentheses |
|
- Oracle setup for the model repository
- Supported Oracle versions and operating systems
- System requirements for Oracle database
- Non-SA-supplied Oracle software and database setup
- SA-supplied Oracle RDBMS software and database setup
- Oracle RAC support
- Garbage collection
- Database monitoring strategy
- Oracle database backup methods
- Troubleshoot system diagnosis errors
- Useful SQL
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.
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
- You must be able to ping the database server host name. To verify this, enter the following command:
# ping <hostname>
- 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:
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 ofMEMORY_MAX_TARGET
andMEMORY_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 checktmp
space:df -h /tmp
-
-
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
- 120753-06: SunOS 5.10: Microtasking libraries (
-
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:
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
- The following patches for Oracle Sun Solaris 10 must be installed:
-
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
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.
-
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
-
- Required operating system version for 11g:
- 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, exceptinggcc-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
bc NA 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
bc NA 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
bc NA 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
bc NA 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
libXi 1.7.2-1.el7.x86_64 libXi 1.7.2-1.el7.i686 libXtst 1.2.2-1.el7.x86_64 libXtst 1.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
bc NA 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
bc NA 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
bc NA 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)
- Required operating system version:
-
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
-
-
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.
We welcome your comments!
To open the configured email client on this computer, open an email window.
Otherwise, copy the information below to a web mail client, and send this email to hpe_sa_docs@hpe.com.
Help Topic ID:
Product:
Topic Title:
Feedback: