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
- 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
- Troubleshooting system diagnosis errors
- Useful SQL
System requirements
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, perform the following tasks:
- Copy or link
/usr/share/zoneinfo/UTC
to
/etc/localtime
. - 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 hostname. 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 hostname 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.
- 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:
You can use the following command to check swap space:RAM
Available Swap Space
4 GB and 16 GB
Equal to the size of RAM
More than 16 GB
16 GB
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 spaceYou can use the following command to check
tmp
space:df -h /tmp
Solaris, HP-UX, and IBM requirements
See Oracle Sun Solaris, HP-UX, and IBM AIX version and package requirements 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:
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 |
MB/1000 |
Recommended minimum tablespace size |
---|---|---|
|
256 MB |
2000 MB |
|
256 MB |
2000 MB |
|
256 MB |
2000 MB |
|
256 MB |
2000 MB |
|
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)
- Oracle Linux 6 (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
- Oracle Linux 5 Update 2
- 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
- Oracle Linux 5 Update 6
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):
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 |
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 |
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 |
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 |
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 |
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 |
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 |
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 |
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, HP-UX, and IBM AIX version and package requirements
This section 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
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: