登录  
 加关注
查看详情
   显示下一条  |  关闭
温馨提示!由于新浪微博认证机制调整,您的新浪微博帐号绑定已过期,请重新绑定!立即重新绑定新浪微博》  |  关闭

飞哥的技术博客

世上无难事,只怕有心人!

 
 
 

日志

 
 
 
 

Oracle 数据库 10g 第 2 版单个实例和 Oracle 真正应用集群在 Oracle Enterprise Linux 5 for Linux x86-64 上,使用 OCFS2 和 ASM + 10.2.0.3 + IBM System x3950 + IBM System Storage DS8000 系列   

2009-09-11 16:32:11|  分类: Oracle |  标签: |举报 |字号 订阅

  下载LOFTER 我的照片书  |
Validated Configuration Details
Configuration Summary Oracle Database 10g Release 2 Single Instance and Oracle Real Application Clusters (RAC) on Oracle Enterprise Linux 5 for Linux x86-64 using OCFS2 and Automatic Storage Management (ASM)
Publication Date 15-APR-08
Version 1
Server Platform IBM System X - x3550 (x336)
Storage Model IBM System Storage DS8000 Family
Oracle Software Oracle Database 10g Release 2 (10.2.0.3) for Linux x86-64
Linux Distibution Oracle Enterprise Linux 5 x86_64
 
Server and Storage Platform Details
Server Model 4 X IBM System X - x3550 (x336)
Server Details Additional Server models covered by this configuration:IBM System x - x3400 (x226), x3500 (x236), x3800 (x260),x3650 (x346), x3850 (x366), IBM BladeCenter HS20 and HS21
Processors 2 X Dual Core Intel(R) Xeon(TM) CPU 5160 3.00GHz
Memory 4GB RAM
Network/Interconnect 2 X Broadcom NetXtreme II BCM5708s
HBA 1 X Dual port QLogic QLE2462 Fibre Channel HBA , 1 X Emulex PCI-E LPe11002 dual port
Storage Model DS8100 and DS8100 Turbo , IBM System Storage DS8000 Family , DS8300 and DS8300 Turbo
 
Switch Details
Switch Model Cisco Catalyst 6500-E
Switch Type Network Switch
Additional Info. None
 
Switch Model Brocade 2005-B32
Switch Type FC Switch
Additional Info. None
 
Switch Model Cisco Catalyst 3500 XL(private.)
Switch Type Network Switch
Additional Info. None
 
Linux Distribution Details
OS OEL 5 x86_64
Kernel kernel-2.6.18-53.1.14.0.1.el5.x86_64.rpm or higher
 
Additional Packages Needed From Distribution
binutils-2.17.50.0.6-2.el5.x86_64.rpm
compat-db-4.2.52-5.1.x86_64.rpm
compat-gcc-34-3.4.6-4.x86_64.rpm
compat-gcc-34-c++-3.4.6-4.x86_64.rpm
compat-libstdc++-33-3.2.3-61.i386.rpm
compat-libstdc++-33-3.2.3-61.x86_64.rpm
gcc-4.1.1-52.el5.2.x86_64.rpm
gcc-c++-4.1.1-52.el5.2.x86_64.rpm
gdb-6.5-16.el5.x86_64.rpm
gdbm-1.8.0-26.2.1.x86_64.rpm
glibc-2.5-12.x86_64.rpm
glibc-common-2.5-12.x86_64.rpm
glibc-devel-2.5-12.i386.rpm
ksh-20060214-1.4.x86_64.rpm
libXp-1.0.0-8.x86_64.rpm
libXtst-1.0.1-3.1.i386.rpm
libaio-devel-0.3.106-3.2.x86_64.rpm
libgnome-2.16.0-6.el5.x86_64.rpm
libstdc++-4.1.1-52.el5.2.x86_64.rpm
libstdc++-devel-4.1.1-52.el5.2.x86_64.rpm
make-3.81-1.1.x86_64.rpm
sysstat-7.0.0-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.44.el5.x86_64.rpm
xorg-x11-xinit-1.0.2-13.el5.x86_64.rpm
Oracle Packages
ocfs2-2.6.18-8.0.0.4.1.el5-1.2.8-2.el5.x86_64.rpm Corresponding to the kernel version
ocfs2-tools-1.2.8-2.el5.x86_64.rpm Required for DB on OCFS2
ocfs2console-1.2.8-2.el5.x86_64.rpm Required for DB on OCFS2
oracle-validated-1.0.0-3.el5.x86_64.rpm 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.18-8.0.0.4.1.el5-2.0.4-1.el5.x86_64.rpm Corresponding to the kernel version
oracleasm-support-2.0.4-1.el5.x86_64.rpm Required for DB on ASM
oracleasmlib-2.0.3-1.el5.x86_64.rpm Required for DB on ASM
Other Packages
device-mapper-1.02.13-1.el5.x86_64.rpm
Configuration Files
File NameSort by this column Conf File Settings Comments
/etc/modprobe.conf options hangcheck-timer hangcheck_tick=30 hangcheck_margin=180 hangcheck_reboot=1  
/etc/multipath.conf defaults { polling_interval 30 failback immediate no_path_retry 5 rr_min_io 100 path_checker tur user_friendly_names yes } Latest settings are available at http://www-1.ibm.com/support/docview.wss? rs=540&context=ST52G7&dc=D430&uid=ssg1S4000107&loc=en_US&cs=utf-8<=en
  device { vendor "IBM" product "2107900" path_grouping_policy group_by_serial }  
/etc/security/limits.conf 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  
  oracle hard memlock 50000000  
  oracle soft nofile 131072 # depending on size of db, these may need to be larger
  oracle hard nofile 131072  
  oracle hard core unlimited  
  oracle soft nproc 131072  
/etc/sysconfig/oracleasm ORACLEASM_SCANORDER="mapper/mpath"  
/etc/sysctl.conf net.ipv4.ip_local_port_range=1024 65000  
  kernel.shmmax=2074114048 #Set to a value half the size of physical memory
  fs.aio-max-nr=3145728  
  net.core.wmem_max=262144  
  net.core.wmem_default=262144  
  net.core.rmem_max=2097152 # rmem_max can be tuned based on workload to balance performance vs lowmem usage
  net.core.rmem_default=262144 # rmem_default can be tuned based on workload to balance performance vs lowmem usage
  kernel.sysrq=1  
  kernel.shmall=3279547  
  kernel.shmmni=4096  
  kernel.sem=250 32000 100 142  
  kernel.msgmnb = 65536  
  kernel.msgmax=8192  
  kernel.msgmni=2878  
  fs.file-max=327679  
Filesystems Tested
Filesystem Mount Options Details
ASM None Using Automatic Storage Management Library Driver (asmlib) for datafiles
RAW None ocr and voting disk located on raw partitions, for configuration with datafiles on ASM storage.
OCFS2 _netdev,datavolume,nointr Datafiles, ocr and voting disk files on OCFS2
Driver Modules
Driver Module Hangcheck-timer module
Version None
Settings None
Additional Info. The driver used is the hangcheck-timer module supplied with the distribution
 
Driver Module Emulex LightPulse Fibre Channel SCSI driver HBA
Version 8.1.10.3
Settings None
Additional Info. Firmware 2.50A6 (Z2F2.50A6). The driver used is the HBA driver module supplied with the distribution
 
Driver Module Network driver module (bnx2)
Version None
Settings None
Additional Info. The driver used is the bnx2 driver supplied with the distribution
 
Driver Module Qlogic HBA (QLE2462)
Version 8.01.07-k1
Settings None
Additional Info. The driver used is the HBA driver supplied with the distribution
 
Miscellaneous
2 gigabit networks configured: public and cluster_interconnect .
Swap partition is twice the size of physical RAM
Oracle Software Details
Product Oracle Database 10g Release 2, Single Instance and Oracle Real Application Clusters (RAC) for Linux x86-64
Version 10.2.0.3
Patches 6614205 , 5526245 , 5940792 , 5452672
 
Configuration Feedback
Bug No 6045759
Summary Applications using random numbers may hang or report errors if there is insufficient random data in the system
Affects Oracle applications tools (e.g: java apps) requesting random data
Symptom Oracle applications tools (e.g: java apps) requesting random data from /dev/random either hang or print out the following information message: Not enough random bytes available. Please do some other work to give the OS a chance to collect more entropy!
Solution/Workaround If using e1000 or bnx2 network drivers on OEL5 the entropy=1 module option can be set for either of these drivers in /etc/modprobe.conf. Fixed in 2.6.18-8.0.0.4.1.el5 kernel or higher
 
Bug No 6075960
Summary If an ORACLE_HOME resides on an nfs partition, a reboot while Oracle is running may cause a panic
Affects Oracle deployments with Oracle_home on an nfs partition
Symptom If the ORACLE_HOME resides on an nfs partition and the system is rebooted while an Oracle instance is still running, the system may panic. This does not cause a data corruption, but the system will need to be restarted
Solution/Workaround Fixed in 2.6.18-53.0.0.0.1.el5 kernel or higher. For other kernel versions lower than this, please shutdown the database instance before reboot of the server.
 
Bug No 6079461
Summary OCI program fails to execute with error: LIBNNZ10.SO: cannot restore segment prot after reloc: Permission denied
Affects OCI programs when selinux is enabled.
Symptom If selinux is enabled, running an OCI application may fail with the following error: libnnz10.so: cannot restore segment prot after reloc: Permission denied
Solution/Workaround Disable selinux(either via the selinux=0 boot option or by setting SELINUX=disabled in /etc/sysconfig/selinux)
 
Bug No 6081490
Summary With selinux enabled, ocfs2 fails to startup via /etc/init.d/o2cb start
Affects Automated startup of ocfs2 via /etc/init.d/o2cb start
Symptom With selinux enabled, starting ocfs2 via "/etc/init.d/o2cb start" fails with the following error: "mount: block device ocfs2_dlmfs is write-protected mounting read-only. mount: cannot mount block device ocfs2_dlmfs read-only. Unable to mount ocfs2_dlmfs filesystem Failed"
Solution/Workaround Manually mount OCFS2_DLMFS using the command mount -t ocfs2_dlmfs ocfs2_dlmfs /dlm
 
Bug No 6219364
Summary Systems using kexec/kdump with Broadcom Tigon3 NICs will not be able to dump vmcore.
Affects Troubleshooting of systems via kexec/kdump with Broadcom Tigon3 NICs.
Symptom When troubleshooting with kexec/kdump, the system throws errors when trying to bring up the ethernet interface when trying to connect to the system on to which the vmcore should be dumped. This does not affect normal operations.
Solution/Workaround Fixed in 2.6.18-53.0.0.0.1.el5 kernel
 
Bug No 6241862
Summary Using sysrq+t with netconsole/tg3 configured causes the system to panic.
Affects Troubleshooting of systems via "alt sysrq t" with netconsole/tg3 configured.
Symptom When troubleshooting system, usage of "alt + sysrq + t" with netconsole/tg3 configured to take a system stack trace may cause the system to panic . This does not affect the normal operation of the system.
Solution/Workaround Fixed in 2.6.18-92.0.0.0.1.el5 kernel or higher
 
Bug No 5240928
Summary warning messages in trace files during certain workloads with async io turned on
Affects Performance under high i/o load
Symptom Following warning in trace files WARNING: ORACLE PROCESS RUNNING OUT OF OS KERNEL I/O RESOURCES
Solution/Workaround Fixed in 10.2.0.4. For 10g, versions lower than 10.2.0.4 ,apply patch 5452672.
 
Bug No 5215593
Summary unable to start RAC with db_cache_size > 4gb
Affects RAC instances with > 4gb db_cache_size
Symptom nodes that started up correctly with 10.2.0.1 may fail to startup with ORA-4031 errors in 10.2.0.2
Solution/Workaround Fixed 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 No 5526245
Summary warning messages in trace files from qmnc process
Affects 10.2.0.2 and 10.2.0.3 RAC
Symptom Following warning in trace files - KSXPLOOKUP: warning cnh incarnation number may be stale ...
Solution/Workaround Fixed in 10.2.0.4. For 10g, versions lower than 10.2.0.4 ,apply patch 5526245.
 
Bug No 6057703
Summary ORA-00600:[kclchkblkdma_3] in RAC instance
Affects 10.2.0.3 RAC
Symptom the user process may terminate leaving the above mentioned traces in alert/trace files
Solution/Workaround Fixed in 10.2.0.4. For 10g, versions lower than 10.2.0.4 ,apply patch 6614205.
 
Bug No 6682370
Summary When configuring the cluster interconnect the interface name should not contain a "."
Affects 10.2.0.3 cluster interconnect configuration
Symptom If 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/Workaround Fixed in 10.2.0.4. For 10g, versions lower than 10.2.0.4 avoid using interface names with a "."
 
Bug No 8451866
Summary Incorrect 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.
Affects All applications using device mapper multipath devices which have contingency plan in case of io path failure.
Symptom RAC node hangs if io path fails.
Solution/Workaround In 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.
 
Note: The above configuration can be deployed with Red Hat with the changes listed below:
os Kernel
RHEL 5 x86_64 kernel-2.6.18-53.1.14.el5.x86_64.rpm or higher
Required Packages
Packages
oracleasm-support-2.0.4-1.el5.x86_64.rpm
ocfs2-2.6.18-8.0.0.4.1.el5-1.2.8-2.el5.x86_64.rpm
oracleasmlib-2.0.3-1.el5.x86_64.rpm
ocfs2console-1.2.8-2.el5.x86_64.rpm
ocfs2-2.6.18-8.el5-1.2.8-2.el5.x86_64.rpm
oracleasm-2.6.18-8.el5-2.0.4-1.el5.x86_64.rpm


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




引文来源  Validated Configuration Details
  评论这张
 
阅读(895)| 评论(0)

历史上的今天

评论

<#--最新日志,群博日志--> <#--推荐日志--> <#--引用记录--> <#--博主推荐--> <#--随机阅读--> <#--首页推荐--> <#--历史上的今天--> <#--被推荐日志--> <#--上一篇,下一篇--> <#-- 热度 --> <#-- 网易新闻广告 --> <#--右边模块结构--> <#--评论模块结构--> <#--引用模块结构--> <#--博主发起的投票-->
 
 
 
 
 
 
 
 
 
 
 
 
 
 

页脚

网易公司版权所有 ©1997-2018