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 SummaryOEL 4 Update 5 x86-64 on Huawei Tecal 2P BA22 server series and Huawei 3100 Array Storage with Oracle Database 10g Release 2
Publication Date28-APR-08
Version1.0
Server PlatformHuawei Tecal 2P BA22 server series
Storage ModelHuawei 3100 Array Storage
Oracle SoftwareOracle Database 10g Release 2 (10.2.0.3) for Linux x86_64
Linux DistributionOracle Enterprise Linux 4 Update 5 x86-64
Server and Storage Platform Details
Server Model3 X Huawei Tecal 2P BA22 server series
Server DetailsFor this server, additional Processor model covered: 2 x Dual Core AMD Opteron 2210 1.8GHz
Processors2 X Dual Core AMD Opteron 2218 2.6G
Memory8GB RAM
OnBoardStorage2 X 73 GB SAS 10k rpm
Network/Interconnect1 X Dual port Onboard Broadcom NetXtreme II BCM5715 Gigabit
HBA QLogic QLA2342 2Gb dual port FC HBA
Storage ModelHuawei 3100 Array Storage
Storage Details16 X 73 GB 15K rpm FC Drives (3 X RAID 5,1 X RAID 0)
 
Switch Details
Switch ModelHuawei ATCA NX20 Blade Switch
Switch TypeTransfers speed: FC:2GB/SEC GE:1GB/SEC
Additional Info.None
 
Linux Distribution Details
OSOEL 4 Update 5 x86-64
Kernelkernel-smp-2.6.9-55.0.0.0.2.EL.x86_64.rpm or higher
 
Additional Packages Needed From Distribution
binutils-2.15.92.0.2-22.x86_64.rpm
compat-db-4.1.25-9.x86_64.rpm
compat-libstdc++-33-3.2.3-47.3.i386.rpm
compat-libstdc++-33-3.2.3-47.3.x86_64.rpm
gcc-3.4.6-8.0.1.x86_64.rpm
gcc-c++-3.4.6-8.0.1.x86_64.rpm
gdb-6.3.0.0-1.143.el4.x86_64.rpm
glibc-2.3.4-2.36.i686.rpm
glibc-2.3.4-2.36.x86_64.rpm
glibc-common-2.3.4-2.36.x86_64.rpm
glibc-devel-2.3.4-2.36.i386.rpm
glibc-devel-2.3.4-2.36.x86_64.rpm
gnome-libs-1.4.1.2.90-44.2.x86_64.rpm
libaio-0.3.105-2.x86_64.rpm
libaio-devel-0.3.105-2.x86_64.rpm
libstdc++-3.4.6-8.0.1.x86_64.rpm
libstdc++-devel-3.4.6-8.0.1.x86_64.rpm
make-3.80-6.EL4.x86_64.rpm
pdksh-5.2.14-30.3.x86_64.rpm
sysstat-5.0.5-14.rhel4.x86_64.rpm
unixODBC-2.2.11-1.RHEL4.1.x86_64.rpm
unixODBC-devel-2.2.11-1.RHEL4.1.x86_64.rpm
xorg-x11-deprecated-libs-6.8.2-1.EL.18.0.1.i386.rpm
Oracle Packages
oracle-validated-1.0.0-4.el4.x86_64.rpm [ Optional package,but recommended ]This package automatically pulls in package dependencies and sets system parameters recommended above. It is not required but is recommended to save time in getting the system setup. It is available from ULN by subscribing to the "Oracle Software" channel and then using up2date to install it. The dependent packages will be installed and parameters will be adjusted as part of this up2date process. NOTE: For supportability and diagnosability gdb should also be installed using up2date
oracleasm-2.6.9-55.0.0.0.2.ELlargesmp-2.0.3-2.x86_64.rpm or higherRequired for DB on ASM
oracleasm-support-2.0.3-2.x86_64.rpmRequired for DB on ASM
oracleasmlib-2.0.2-1.x86_64.rpmRequired for DB on ASM
Configuration Files
Conf File Settings Comments
/etc/modprobe.confoptions hangcheck-timer hangcheck_tick=1 hangcheck_margin=10 hangcheck_reboot=1 
/etc/security/limits.conforacle soft nproc 131072 
 oracle hard nofile 131072 
 oracle soft nofile 131072# depending on size of db, these may need to be larger
 oracle hard core unlimited 
 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 nproc 131072 
/etc/sysctl.confkernel.sem=250 32000 100 142 
 kernel.shmmax=4172025856#Set to a value half the size of physical memory
 kernel.shmmni=4096 
 kernel.shmall=3279547 
 kernel.sysrq=1 
 net.core.rmem_default=262144# rmem_default can be tuned based on workload to balance performance vs lowmem usage
 net.core.rmem_max=2097152# rmem_max can be tuned based on workload to balance performance vs lowmem usage
 net.core.wmem_default=262144 
 net.core.wmem_max=262144 
 vm.nr_hugepages=800 
 kernel.msgmnb=65536 
 kernel.msgmax=8192 
 kernel.msgmni=2878 
 vm.lower_zone_protection=100 
 fs.aio-max-nr=3145728 
 fs.file-max=327679 
 net.ipv4.ip_local_port_range=1024 65000 
 net.ipv4.conf.default.rp_filter = 1 
 net.ipv4.ip_forward = 0 
 kernel.core_uses_pid = 1 
Filesystems Tested
Filesystem Mount Options Details
ASMNoneUsing Automatic Storage Management Library Driver (asmlib) for datafiles
Driver Modules
Driver ModuleHangcheck-timer module
VersionNone
SettingsNone
Additional Info.The driver used is the hangcheck-timer module supplied with the distribution
 
Driver ModuleNetwork driver module (tg3)
Version3.64-rh
SettingsNone
Additional Info.The network driver module used is the version supplied with the distribution
 
Driver ModuleFusion MPT SAS HBA driver module
Version3.12.19.00
SettingsNone
Additional Info.The SAS HBA driver module is supplied with the distribution
 
Driver ModuleQlogic HBA driver module (qla2300)
Version8.01.04
SettingsNone
Additional Info.The driver used is the HBA driver supplied with the distribution
 
Miscellaneous
Two gigabit networks, 1 for public(igb) and 1 private(igb).
The swap partition is 16GB.
Oracle Software Details
ProductOracle Database 10g Release 2, Single Instance and Oracle Real Application Clusters (RAC) for Linux x86_64
Version10.2.0.3
Patches5526245 , 6614205 , 5940792 , 5452672
 
Configuration Feedback
Bug No4593892
Summaryrepeated warnings in dmesg about lost ticks (it 80129/bz 139376)
Affectsusually seen on x86-64, both Intel and Opteron based systems
Symptomdmesg will have errors like: warning: many lost ticks. Your time source seems to be instable or some driver is hogging interrupts rip __do_softirq+0x4d/0xd0
Solution/WorkaroundFixed in U5
 
Bug No5041764
SummaryCFQ io scheduler can delay/hang io (bz 184535/it 88208 )
Affectsheavy io access to raw/block devices
Symptomio requests will start to hang or take a long to complete RAC node could be evicted
Solution/WorkaroundFixed in U4. Pre-U4, boot w/ elevator=deadline
 
Bug No5058952
Summarye1000 flow control defaults to none in the 2.6 kernel
Affectse1000 network interfaces with heavy traffic
SymptomNetwork performance of the system is affected. For e.g: In the case of a RAC cluster, this may result in lost global cache blocks.
Solution/WorkaroundFixed in U4. Pre-U4, load e1000 with FlowControl=1 (Rx)
 
Bug No5093059
Summarynetdump doesn't load with bonding configured (it 85145)
Affectsbringing up netdump over a bonded interface
Symptom/var/log/messages will have an error: netlog: bond0 doesn't support polling, aborting.
Solution/WorkaroundFixed in U4.
 
Bug No5136660
Summarybonding primary=ethX doesn't take effect
AffectsBonding doesn't take effect
SymptomIf we make a bond of eth5 and eth6, where eth6 is primary, on reboot eth5 will become active which makes server inaccessible.
Solution/WorkaroundFixed in 2.6.9.42.0.3.0.2.EL kernel or higher
 
Bug No5333606
Summaryrpm throws errors if selinux is disabled at OS installation and is enabled at runtime
Affectserror at rpm packages installs
Symptomduring packages installation, errors indicate the scriplet failures
Solution/Workaroundrelabel the filesystems through 'touch /.autorelabel' or 'fixfilesrelabel'
 
Bug No5447805 (BZ 202186)
SummaryKernel panic on 'aio_put_req' with x86_64 RHEL 4 AS U3 when all multipathed paths fails at the same time
Affectsmultipath solutions
SymptomKernel panic on aio_out_req
Solution/WorkaroundFixed in kernel-2.6.9-42.5.EL.src.rpm (available from RedHat) or in kernel-smp-2.6.9.42.0.3.0.3.EL.x86_64.rpm (available from Oracle)
 
Bug No5463714
Summarysystem will hang if reboot or restart iscsi service without unmount ocfs2 partition on iscsi volume
Affectssystem hang
Symptomrestart iscsi service or reboot without umount iscsi volume cause system hang
Solution/Workaroundunmount iscsi volume before restart iscsi service or reboot server
 
Bug No5593995
SummaryUsing Pro*C causes the system to run out of memory
AffectsCaused the system to hang.
SymptomThe system hangs.
Solution/WorkaroundFor OEL5U3, Remove references to pathnames that do not exist on your system in pcscfg.cfg. Fixed in OEL5U4.
 
Bug No5693201
SummaryApplication does not detect OEL4 as RHEL4
AffectsApplications that use /etc/redhat-release for detection of distribution
SymptomApplications that use /etc/redhat-release for detection of distribution may error out
Solution/Workaroundecho "Red Hat Enterprise Linux AS release 4 (Nahant Update 4)" > /etc/redhat-release
 
Bug No7240271
SummaryKernel panic occurs while starting up Oracle Enterprise Manager agent
Affects2.6.9-67.0.20.0.1.EL ( OEL ) or 2.6.9-67.0.20.EL ( RHEL ) kernels
SymptomMachine will experience a linux BUG, panic & reboot, when the EM Agent starts.
Solution/WorkaroundEL4.6 errata ( 2.6.9-67.0.20.0.2 and 2.6.9-67.0.22.0.1) kernel patches that have this fix.
 
Bug NoRedhat Bugzilla 202027
SummaryClear_kernel_mapping: mapping has been split. will leak memory
AffectsSeen on x86-64 Opteron based systems
Symptom/var/log/messages will have errors like clear_kernel_mapping: mapping has been split. will leak memory
Solution/WorkaroundFixed in U5
 
Bug No5240928
Summarywarning messages in trace files during certain workloads with async io turned on
AffectsPerformance under high i/o load
SymptomFollowing warning in trace files WARNING: ORACLE PROCESS RUNNING OUT OF OS KERNEL I/O RESOURCES
Solution/WorkaroundFixed in 10.2.0.4. For 10g, versions lower than 10.2.0.4 ,apply patch 5452672.
 
Bug No5215593
Summaryunable to start RAC with db_cache_size > 4gb
AffectsRAC instances with > 4gb db_cache_size
Symptomnodes that started up correctly with 10.2.0.1 may fail to startup with ORA-4031 errors in 10.2.0.2
Solution/WorkaroundFixed in 10.2.0.4. For 10g, versions lower than 10.2.0.4, apply patch 5940792; or set _ksmg_granule_size=33554432 in the init.ora. Larger sga sizes may need a higher value.
 
Bug No5526245
Summarywarning messages in trace files from qmnc process
Affects10.2.0.2 and 10.2.0.3 RAC
SymptomFollowing warning in trace files - KSXPLOOKUP: warning cnh incarnation number may be stale ...
Solution/WorkaroundFixed in 10.2.0.4. For 10g, versions lower than 10.2.0.4 ,apply patch 5526245.
 
Bug No6057703
SummaryORA-00600:[kclchkblkdma_3] in RAC instance
Affects10.2.0.3 RAC
Symptomthe user process may terminate leaving the above mentioned traces in alert/trace files
Solution/WorkaroundFixed in 10.2.0.4. For 10g, versions lower than 10.2.0.4 ,apply patch 6614205.
 
Bug No6682370
SummaryWhen configuring the cluster interconnect the interface name should not contain a "."
Affects10.2.0.3 cluster interconnect configuration
SymptomIf the interface name being used as the private interconnect contains a "." then 1. oifcfg getif does not display the confguration; and 2. The public interface gets used as the cluster interconnect
Solution/WorkaroundFixed in 10.2.0.4. For 10g, versions lower than 10.2.0.4 avoid using interface names with a "."
 
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 No5768303
SummaryUnder load with device mapper the system reboots
AffectsRunning Oracle with device-mapper
Symptomunder high-stress, SCSI paths are lost and servers reboot. Messages in /var/log/messages
Solution/WorkaroundFor qla2xxx and qla2400 options qlport_down_retry=1 & ql2xretrycount=5 in modprobe.conf Upgraded qLogic driver to release 8.01.06 failback parameter IMMEDIATE set to 1 in the device mapper config file
 
Bug NoOracle Bugzilla 3032
SummaryNOT ALL I/O PATHS ARE RECOVERED WITH MULTIPATH TOOL AFTER PATH FAILURE and RECOVERY. With 8.01.07 Qlogic driver
AffectsThe number of paths available for i/o
Symptomwhen a host port or storage port is blocked then unblocked or when a cable is removed then restored - one or more paths are reported down in /var/log/messages a'path is down'.
Solution/WorkaroundFixed in 8.02.14.01 driver, the following settings with 8.01.07 driver is required in modprobe.conf ConfigRequired=0 ql2xprocessrscn=1 ql2xprocessnotready=0 ql2xsuspendcount=3 ql2xretrycount=5 qlport_down_retry=3 ql2xfailover=0 ql2xioctltimeout=10
 
Note: The above configuration can be deployed with Red Hat with the changes listed below:
os Kernel
RHEL 4 AS Update 5 x86-64kernel-smp-2.6.9-55.EL.x86_64.rpm or higher
Required Packages
Packages
oracleasm-2.6.9-55.ELsmp-2.0.3-1.x86_64.rpm
oracleasmlib-2.0.2-1.x86_64.rpm
oracleasm-support-2.0.3-1.x86_64.rpm


Note: Oracle-validated for Red Hat is available from oracle-validated-1.0.0-18 onwards.

 
Copyright (c) 2007, Oracle Corporation. All Rights Reserved.