Printer View

Browse Published Validated Configurations  >  Validated Configuration Details
Program Scope

The goal of this program is to validate hardware with Oracle Linux and Oracle VM, and to identify issues and configuration details that would impact customer deployments. Oracle developed the program to go far beyond the standard certification testing normally performed with operating systems. Hardware vendors participating in this program perform thorough testing of the hardware in real-world configurations with Oracle Linux and Oracle VM.

This is not a database certification. Oracle Database is a component of the environment because it is demanding on hardware resources (processor, memory, cache, storage, network) and the operating system, and well suited for this advanced level of testing. The validation program uses Oracle Database as a tool and hardware is not certified with Oracle Database as a result of the validation program.

For more information please see the program's Frequently Asked Questions (FAQ).

Validated Configuration Details
Configuration SummaryOracle Linux 5 Update 5 x86_64 on Dell PowerEdge R910 and Dell Compellent SC040 with Oracle Database 11g Release 2
Publication Date07-SEP-11
Version1.0
Server PlatformDell PowerEdge R910
Storage ModelDell Compellent SC040
Oracle SoftwareOracle Database 11g Release 2 (11.2.0.2) for Linux x86-64
Linux DistributionOracle Linux 5 Update 5 x86_64
Server and Storage Platform Details
Server Model2 X Dell PowerEdge R910
Server DetailsAdditional Server model covered by this configuration:PowerEdge R810 and PowerEdge M910
Processors2 X Quad Core Intel(R) Xeon(R) CPU E7520 1.87GHz
Memory16GB RAM
OnBoardStorage2 X 146GB Seagate
RAIDPERC H700 - 2.100.03-1062
Network/Interconnect2 X Dual Port Broadcom Corporation NetXtreme II BCM5709 Gigabit Ethernet
MultipathDevice mapper multipath 0.4.9-23.0.4
Storage ModelDell Compellent SC040 , Dell Compellent SC030
Storage DetailsDell Compellent SC040
 
Switch Details
Switch ModelBrocade 300
Switch TypeFC Switch
Additional Info.None
 
Switch ModelDell PowerConnect 6248
Switch TypeNetwork Switch(1GbE)
Additional Info.None
 
Oracle Linux Distribution Details
osOracle Linux 5 Update 5 x86_64
Kernelkernel-2.6.32-100.0.19.el5.x86_64.rpm or higher
oracle-linuxoracle-linux-5.0.0-6.rpm or higher, it installs Oracle Linux 5 with Unbreakable Enterprise Kernel
 
Additional Packages Needed From Distribution
binutils-2.17.50.0.6-14.el5.x86_64.rpm
compat-libstdc++-33-3.2.3-61.i386.rpm
compat-libstdc++-33-3.2.3-61.x86_64.rpm
elfutils-libelf-devel-0.137-3.el5.x86_64.rpm
gcc-4.1.2-48.el5.x86_64.rpm
gcc-c++-4.1.2-48.el5.x86_64.rpm
gdb-7.0.1-23.el5.x86_64
glibc-2.5-49.i686.rpm
glibc-2.5-49.x86_64.rpm
glibc-common-2.5-49.x86_64.rpm
glibc-devel-2.5-49.i386.rpm
glibc-devel-2.5-49.x86_64.rpm
libXp-1.0.0-8.1.el5.x86_64.rpm
libXtst-1.0.1-3.1.i386.rpm
libaio-0.3.106-5.i386.rpm
libaio-0.3.106-5.x86_64.rpm
libaio-devel-0.3.106-5.x86_64.rpm
libstdc++-4.1.2-48.el5.i386.rpm
libstdc++-4.1.2-48.el5.x86_64.rpm
libstdc++-devel-4.1.2-48.el5.x86_64.rpm
make-3.81-3.el5.x86_64.rpm
sysstat-7.0.2-3.el5.x86_64.rpm
unixODBC-2.2.11-7.1.x86_64.rpm
unixODBC-devel-2.2.11-7.1.x86_64.rpm
util-linux-2.13-0.52.0.1.el5_4.1.x86_64
xorg-x11-utils-7.1-2.fc6.x86_64.rpm
Oracle Packages
oracle-validated-1.1.0-7.el5.x86_64.rpmoracle-validated installs the packages required for Oracle Database and sets the recommended system parameters. It is not required but is recommended to save time in getting the system setup.It is available in ULN channels, Oracle Linux media, and public-yum.oracle.com. NOTE: oracle-validated does not install gdb. Oracle support recommends to install gdb for supportability and diagnosability.
oracleasm-support-2.1.4-1.el5.x86_64.rpmRequired for DB on ASM
oracleasmlib-2.0.4-1.el5.x86_64.rpmRequired for DB on ASM
Other Packages
device-mapper-multipath-0.4.9-23.0.4.el5 (This package is obtained from OS distribution)
Configuration Files
Conf File Settings Comments
/etc/security/limits.conforacle hard nproc 131072 
 oracle soft nproc 131072 
 oracle hard nofile 131072 
 oracle soft nofile 131072# depending on size of db, these may need to be larger
 oracle hard memlock 50000000 
 oracle soft memlock 50000000# set memlock greater than or equal to the sga size to allow oracle to use hugepages if configured
 oracle soft core unlimited 
 oracle hard core unlimited 
/etc/sysctl.confkernel.shmmni = 4096 
 net.ipv4.ip_local_port_range = 9000 65500 
 kernel.shmmax = 4398046511104 
 kernel.shmall = 1073741824 
 fs.file-max = 6815744 
 net.core.rmem_default = 262144 
 net.core.wmem_default = 262144 
 fs.aio-max-nr = 3145728 
 net.core.rmem_max = 4194304 
 kernel.sem = 250 32000 100 142 
 kernel.msgmni = 2878 
 kernel.msgmax = 65536 
 net.core.wmem_max = 1048576 
 net.ipv4.tcp_syncookies = 1 
 kernel.core_uses_pid = 1 
 kernel.sysrq = 1 
 net.ipv4.conf.default.rp_filter = 1 
 kernel.msgmnb = 65536 
Filesystems Tested
Filesystem Mount Options Details
ASMNoneUsing Automatic Storage Management Library Driver (asmlib) on device-mapper devices for OCR,VOTE and datafiles
Driver Modules
Driver ModuleNetwork driver module (bnx2)
Versionv2.0.2
SettingsNone
Additional Info.The driver is supplied with Oracle Linux 5
 
Driver ModuleHBA driver module (qla2xxx)
Version8.03.01.01.32.1-k9
SettingsNone
Additional Info.The driver is supplied with Oracle Linux 5
 
Miscellaneous
Three 1 GbE networks, 1 for public(bnx2) and 2 private(bnx2).
The swap partition is 18GB.
Oracle Software Details
ProductOracle Database 11g Release 2, Single Instance and Oracle Real Application Clusters (RAC) for Linux x86-64
Version11.2.0.2
Patchesnone
 
Configuration Feedback
Bug No9466221
SummaryDmesg displays "Task XXXX: blocked for more than 120 seconds" under load
AffectsSystems on OEL5.5/RHEL5.5
SymptomFollowing messages may be seen in dmesg - "Task XXXX: blocked for more than 120 seconds"
Solution/WorkaroundThese messages are only for information;newly added in OEL5.5/RHEL5.5. To disable this messages echo 0 > /proc/sys/kernel/hung_task_timeout_secs"
 
Bug No10056679
Summaryunable to start X
AffectsX environment
SymptomOn some hardware startup of X environment may fail after upgrading to Unbreakable Enterprise Kernel with following Error:#Fatal server error:#Cannot run in framebuffer mode. Please specify busIDs for all framebuffer devices.
Solution/Workaroundreconfigure X using command "X -configure" and use generated configuration file to start X environment.
 
Bug No10104470
SummaryError message on boot, "Unable to set hardware clock"
AffectsNone
SymptomError message at boot or at runtime while attempting to set the hardware clock
Solution/WorkaroundThis error at boot can be safely ignored. If this error is encountered at runtime, install util-linux-2.13-0.52.0.1.rpm. Fixed in EL5U6
 
Bug No10121864
SummaryMultipathd path checker unable to recognise restored paths
Affectsmultipath configurations after storage disconnect
SymptomThe path checker fails to recognize the restored storage path, thus fail to restore the device-mapper multipaths and shows status as faulty.
Solution/WorkaroundRestart mutlipathd for path checker to recognise restored storage paths. Fixed in EL5U6
 
Bug No10250424
SummaryMultipath with SAN not consistently creating devices for partitions using UEK
AffectsAny application using device mapper disk partitions after bootup
SymptomFailure to create device mapper disk partitions during boot time
Solution/WorkaroundManually restart the multipathd service after bootup, Fixed in OL5U6
 
Bug No10381916
SummaryDuring the network failure on one rac node, oracle shadow processes failover to surviving nodes but after some time oracle shadow processes crashes on survived nodes with following error in alertlogs "Fatal NI connect error 12547, connecting to:(LOCAL=NO)"
Affects11gR2 RAC
SymptomOracle shadow processes crashes on survived nodes with following error in alertlogs "Fatal NI connect error 12547, connecting to:(LOCAL=NO)" after network failure on one node.
Solution/WorkaroundReduce the load or Contact Oracle support for higher loads
 
Bug No6140224
SummarySQLPLUS FAILS TO LOAD LIBNNZ11.SO WITH SELINUX ENABLED ON EL5/RHEL5
Affects11gR1 and 11gR2
Symptomsqlplus fails with the following error message "cannot restore segment prot after reloc: Permission denied"
Solution/WorkaroundDisable selinux
 
Bug No9100826
SummaryFlashback Archive: Error ORA-942 in database alert and trace logs.
Affects11gR2
SymptomDuring database creation following messages are seen in database alert log and trace files: "Flashback Archive: Error ORA-942 in SQL select ROWID from SYS_FBA_FA where ROWNUM = 1".
Solution/WorkaroundContact Oracle Support.
 
Bug No9126894
Summary"ORA-24010: QUEUE SYS.AQ_SRVNTFN_TABLE_Q_1 does not exist" in database trace files
Affects11gR2
SymptomError message "Exception Occured, Error msg: ORA-24010: QUEUE SYS.AQ_SRVNTFN_TABLE_Q_1 does not exist" seen in trace log files
Solution/WorkaroundFixed in 11.2.0.3
 
Bug No9391048
Summary"ERROR: SGA Memory leak detacted" error during database shutdown
Affects11gR2
SymptomError message "ERROR: SGA memory leak detected" seen in trace log files during database shutdown.
Solution/WorkaroundContact Oracle Support.
 
Bug No10377185
SummaryOCI CLIENT PROGRAM TERMINATES WITH SEGMENTATION FAULT
AffectsRAC network destructive tests
SymptomConnection crashes on the master node after the network failure is done on the second node
Solution/WorkaroundIncreasing the soft stack limit size to 10M on both the nodes
 
Bug No8451866
SummaryIncorrect multipath.conf setting affects RAC node failover. Settings(features = "1 queue_if_no_path") and/or (no_path_retry = queue) causes the node hang if io path fails. no_path_retry has to be set to the numeric value explicitly.
AffectsAll applications using device mapper multipath devices which have contingency plan in case of io path failure.
SymptomRAC node hangs if io path fails.
Solution/WorkaroundIn configuration file /etc/multipath.conf,set no_path_retry and polling_interval to the numeric values, for example, "no_path_retry=5" and "polling_interval=10" so as to disable queuing. These values depend on system workload.
 
Bug No8265418
Summarykexec/kdump not working as expected on HP Smart Array P400i Controller
Affectsvmcore generation on cciss disks (HP Smart Array P400i Controller Firmware Version: 1.18)
SymptomAfter booting from crash kernel, machine will hang with following messages on console: cciss:using PCI PM to reset controller cciss:controller message 03:00 timed out
Solution/WorkaroundRemove reset_devices from KDUMP_COMMANDLINE_APPEND argument in /etc/sysconfig/kdump
 
 
Copyright (c) 2007, Oracle Corporation. All Rights Reserved.