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

飞哥的技术博客

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

 
 
 

日志

 
 
 
 

Oracle 数据库 11g 第 1 版单个实例和 Oracle 真正应用集群在 Oracle Enterprise Linux 5 Update 1 for Linux x86-64 上,使用 ASM + 11.1.0.6 + Dell PowerEdge 2950 III + Dell|EMC CX3-80   

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

  下载LOFTER 我的照片书  |
Validated Configuration Details
Configuration Summary Oracle Database 11g Release 1 Single Instance and Oracle Real Application Clusters (RAC) on Oracle Enterprise Linux 5 Update 1 for Linux x86-64 using ASM
Publication Date 06-AUG-08
Version 1.0
Server Platform Dell PowerEdge 2950 III
Storage Model Dell|EMC CX3-80
Oracle Software Oracle Database 11g Release 1 (11.1.0.6) for Linux x86-64
Linux Distibution Oracle Enterprise Linux 5 Update 1 x86_64
 
Server and Storage Platform Details
Server Model 2 X Dell PowerEdge 2950 III
Processors 2 X Quad Core Intel Xeon X5460 3.16 GHz
Memory 8GB RAM
OnBoardStorage 4 X 73GB SAS 15K
RAID Dell Perc 6/i RAID controller
Network/Interconnect Intel 82575GB Gigabit Ethernet , Broadcom NetXtreme II BCM5708 Gigabit Ethernet
HBA 2 X Dual port QLogic QLE2462 Fibre Channel HBA
Storage Model CX3-40f , CX3-10c , CX3-20f , CX3-40 , CX3-40c , Dell|EMC CX3-20 Storage Arrays , CX3-20c , Dell|EMC CX3-80
Storage Details FC HDDs: 146G 15K rpm Drives (RAID 5)
 
Switch Details
Switch Model Brocade 4100
Switch Type FC Switch
Additional Info. None
 
Switch Model PowerConnect 5324
Switch Type Network Switch
Additional Info. None
 
Linux Distribution Details
OS OEL 5 Update 1 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-5.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.125-3.el5.x86_64.rpm
gcc-4.1.2-14.el5.x86_64.rpm
gcc-c++-4.1.2-14.el5.x86_64.rpm
gdb-6.5-25.el5.x86_64.rpm
glibc-2.5-18.i686.rpm
glibc-2.5-18.x86_64.rpm
glibc-common-2.5-18.x86_64.rpm
glibc-devel-2.5-18.i386.rpm
glibc-devel-2.5-18.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-3.2.i386.rpm
libaio-devel-0.3.106-3.2.x86_64.rpm
libstdc++-4.1.2-14.el5.i386.rpm
libstdc++-4.1.2-14.el5.x86_64.rpm
libstdc++-devel-4.1.2-14.el5.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-deprecated-libs-6.8.2-1.EL.33.0.1.x86_64.rpm
Oracle Packages
oracle-validated-1.0.0-5.el5.x86_64.rpm This package automatically pulls in package dependencies and sets system parameters recommended above. It is not required but is recommended in order 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 be installed using up2date
oracleasm-2.6.18-53.1.14.0.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
EMCpower.LINUX-5.1.0-194.x86_64.rpm (This can be downloaded from https://powerlink.emc.com)
Configuration Files
File NameSort by this column Conf File Settings Comments
/etc/modprobe.conf options bonding miimon=100 mode=1  
  options hangcheck_timer hangcheck_tick=1 hangcheck_margin=10 hangcheck_reboot=1 #These hangcheck timer settings is for the default css misscount value and needs to be tuned based on the css misscount value & oracle RAC version
/etc/security/limits.conf oracle hard 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 soft nproc 131072  
  oracle hard nofile 131072  
  oracle soft core unlimited  
  oracle soft memlock 50000000 # set memlock greater than or equal to the sga size to allow oracle to use hugepages if configured
/etc/sysctl.conf net.core.rmem_max=4194304 # rmem_max can be tuned based on workload to balance performance vs lowmem usage
  net.core.wmem_default=262144  
  net.core.wmem_max=262144  
  net.ipv4.ip_local_port_range=1024 65000  
  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.shmmax=4185235456 #Set to a value half the size of physical memory
  fs.aio-max-nr=3145728  
  fs.file-max=327679  
  kernel.msgmni=2878  
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.
Driver Modules
Driver Module Hangcheck-timer module
Version 0.9.0
Settings Refer /etc/modprobe.conf entry in Configuration Files Section
Additional Info. The driver used is the hangcheck-timer module supplied with the distribution
 
Driver Module Emulex driver module
Version None
Settings None
Additional Info. The driver used is the version 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
 
Miscellaneous
3 gigabit networks configured: 1 for public and 2 bonded network cards for interconnect.
The swap partition is the size of physical RAM.
The default settings in /etc/modprobe.conf & /etc/modprobe.conf.pp are used for EMC PowerPath Multipathing.
Timeout Settings:
CSS diagwait set to 13. NOTE: The value of the css diagwait depends on the workload and underlying OS/storage configurations.
Oracle Software Details
Product Oracle Database 11g Release 1, Single Instance and Oracle Real Application Clusters (RAC) for Linux x86-64
Version 11.1.0.6
Patches 6778860 , 7592335
 
Configuration Feedback
Bug No 5593995
Summary Using Pro*C causes the system to run out of memory
Affects Caused the system to hang.
Symptom The system hangs.
Solution/Workaround Remove references to pathnames that do not exist on your system in pcscfg.cfg
 
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 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 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 8253185
Summary Machine becomes unresponsive during swap pressure, due to direct reclaim threads
Affects Systems with heavy memory and I/O load
Symptom During periods of heavy memory or I/O load that forces the system to swap, the machine becomes unresponsive. In the case of Oracle RAC deployments, this could result in RAC evictions.
Solution/Workaround Fixed in 2.6.18-92.1.17.0.1.el5 kernel or higher
 
Bug No 8277913
Summary Netconsole module insertion fails with bonding on el5.3
Affects netconsole with bonding.
Symptom With bonding enabled, "/etc/init.d/netconsole start" fails with the following error Initializing netconsole FATAL: Error inserting netconsole (/lib/modules//kernel/drivers/net/netconsole.ko): Invalid argument [FAILED]
Solution/Workaround Fixed in 2.6.18-92.1.17.0.2.el5 kernel or higher
 
Bug No 8451369
Summary If oracle-validated rpm is installed from CD, it fails to update the numa settings in /boot/grub/menu.lst
Affects x86_64 AMD processor based systems
Symptom Recommended settings for numa will not be set on AMD processor based systems
Solution/Workaround After install, bring up the system. Append numa=off to the lines "kernel " in /boot/grub/menu.lst. Reboot the system for changes to take effect
 
Bug No 6140224
Summary SQLPLUS FAILS TO LOAD LIBNNZ11.SO WITH SELINUX ENABLED ON EL5/RHEL5
Affects 11.1.0.6 and 11.1.0.7
Symptom sqlplus fails with the following error message "cannot restore segment prot after reloc: Permission denied"
Solution/Workaround Disable selinux
 
Bug No 6501138
Summary ORA-12751: CPU TIME OR RUN TIME POLICY VIOLATION under certain type of workloads.
Affects 11.1.0.6 and 11.1.0.7 performance
Symptom Following messages appear in the oracle trace files "Runtime exceeded 900 seconds"
Solution/Workaround Reduce the load ( e.g: reduce no of users ) or enhance system configuration for that workload
 
Bug No 7036544
Summary Database instance startup fails when sga_target was set to multiples of 4096M
Affects 11.1.0.6
Symptom Database instance startup fails with the following error " ORA-12853: insufficient memory for PX buffers: current 0K, max needed 2640K and ORA-04031: unable to allocate 21544 bytes of shared memory ("large pool","unknown object","large pool","PX msg pool")"
Solution/Workaround Fixed in 11.1.0.7, for 11.1.0.6 set the parameter large_pool_size in init.ora or increase the sga_target size.
 
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 Update 1 x86_64 kernel-2.6.18-53.1.14.el5.x86_64.rpm or higher
Required Packages
Packages
oracleasmlib-2.0.3-1.el5.x86_64.rpm
oracleasm-support-2.0.4-1.el5.x86_64.rpm
oracleasm-2.6.18-53.1.14.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
  评论这张
 
阅读(1078)| 评论(0)

历史上的今天

评论

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

页脚

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