orachk 的几个waring 解决办法

waring 1： 

WARNING

ASM Check

Linux Disk I/O Scheduler should be configured to [Deadline]

All ASM Instances

View

做了如下修改：

[root@bcc1 ~]# echo 'deadline' > /sys/block/sda/queue/scheduler
[root@bcc1 ~]# cat /sys/block/sda/queue/scheduler 
noop anticipatory [deadline] cfq 

要配置在重启后任然有效：

[root@bcc1 ~]# vi /etc/grub.conf 
# grub.conf generated by anaconda 
# 
# Note that you do not have to rerun grub after making changes to this file 
# NOTICE: You have a /boot partition. This means that 
# all kernel and initrd paths are relative to /boot/, eg. 
# root (hd0,0) 
# kernel /vmlinuz-version ro root=/dev/mapper/bcc1sysvg-bcc1rootlv 
# initrd /initrd-[generic-]version.img 
#boot=/dev/sda 
default=0 
timeout=5 
splashimage=(hd0,0)/grub/splash.xpm.gz 
hiddenmenu 
title Red Hat Enterprise Linux (2.6.32-431.el6.x86_64) 
root (hd0,0) 
kernel /vmlinuz-2.6.32-431.el6.x86_64 ro root=/dev/mapper/bcc1sysvg-bcc1rootlv elevator=deadline rd_NO_LUKS LANG=en_US.UTF-8 rd_LVM_LV=bcc1sysvg/bcc1rootlv rd_NO_MD SYSFONT=latarcyrheb-sun16 rd_LVM_LV=bcc1sysvg/bcc1swaplv KEYBOARDTYPE=pc KEYTABLE=us crashkernel=auto rhgb quiet rd_NO_DM rhgb quiet 
initrd /initramfs-2.6.32-431.el6.x86_64.img 

需要在reboot之后生效


waring 2：

WARNING

OS Check

Linux transparent huge pages are enabled

All Database Servers

View

# vi /etc/rc.local 
if test -f /sys/kernel/mm/transparent_hugepage/enabled; then
   echo never > /sys/kernel/mm/transparent_hugepage/enabled
fi
if test -f /sys/kernel/mm/transparent_hugepage/defrag; then
   echo never > /sys/kernel/mm/transparent_hugepage/defrag
fi

经测试在rhel 6上，必须在 grub.conf文件中配置，重启之后，才会生效。
[root@bcc1 ~]# vi /etc/grub.conf 
# grub.conf generated by anaconda
#
# Note that you do not have to rerun grub after making changes to this file
# NOTICE:  You have a /boot partition.  This means that
#          all kernel and initrd paths are relative to /boot/, eg.
#          root (hd0,0)
#          kernel /vmlinuz-version ro root=/dev/mapper/bcc1sysvg-bcc1rootlv
#          initrd /initrd-[generic-]version.img
#boot=/dev/sda
default=0
timeout=5
splashimage=(hd0,0)/grub/splash.xpm.gz
hiddenmenu
title Red Hat Enterprise Linux (2.6.32-431.el6.x86_64)
        root (hd0,0)
        kernel /vmlinuz-2.6.32-431.el6.x86_64 ro root=/dev/mapper/bcc1sysvg-bcc1rootlv transparent_hugepage=never elevator=deadline rd_NO_LUKS LANG=en_US.UTF-8 rd_LVM_LV=bcc1sysvg/bcc1rootlv rd_NO_MD SYSFONT=latarcyrheb-sun16 rd_LVM_LV=bcc1sysvg/bcc1swaplv  KEYBOARDTYPE=pc KEYTABLE=us crashkernel=auto rhgb quiet rd_NO_DM rhgb quiet
        initrd /initramfs-2.6.32-431.el6.x86_64.img
需要在reboot后生效

waring 3：

WARNING

OS Check

vm.min_free_kbytes should be set as recommended.

All Database Servers

View

做了如下修改：

[root@bcc2 ~]# cat /etc/sysctl.conf | grep vm.min_free_kbytes 
vm.min_free_kbytes = 524288

[root@bcc2 ~]# sysctl -n vm.min_free_kbytes 
524288 

针对waring：

WARNING	ASM Check	ASM memory_target is not set to recommended value for Linux	All ASM Instances	View
WARNING	ASM Check	ASM SGA_TARGET is not set to recommended value	All ASM Instances	View

在 11g之后oracle建议asm的内存大小为>=1024 MB 可是在默认安装asm时，只赋予了512 MB,所以在rac安装之后，将asm 实例的内存调大。  

SQL> show parameter mem 

NAME TYPE VALUE 
------------------------------------ ----------- ------------------------------ 
memory_max_target big integer 1G 
memory_target big integer 432M 
SQL> show parameter ga 

NAME TYPE VALUE 
------------------------------------ ----------- ------------------------------ 
lock_sga boolean FALSE 
pga_aggregate_target big integer 0 
sga_max_size big integer 1G 
sga_target big integer 0

SQL> alter system set memory_target=0 scope=spfile sid='*'; ; 

System altered.

SQL> alter system set sga_target=1g scope=spfile sid='*'; 

System altered.

需要在重启ASM之后生效。

来自 “ ITPUB博客 ” ，链接：http://blog.itpub.net/26474945/viewspace-1403765/，如需转载，请注明出处，否则将追究法律责任。

转载于:http://blog.itpub.net/26474945/viewspace-1403765/