ITPub博客

首页 > 数据库 > Oracle > ORACLE提供检验RAC是否健康脚本

ORACLE提供检验RAC是否健康脚本

原创 Oracle 作者:lovehewenyu 时间:2014-04-14 12:03:08 0 删除 编辑

About Using CVU Cluster Healthchecks After Installation


ORACLE提供检验RAC是否健康脚本

http://docs.oracle.com/cd/E11882_01/install.112/e48294/trouble.htm#BABHHDGJ

dwdb1:/home/grid$cluvfy comp healthcheck -collect cluster -bestpractice

 

Verifying OS Best Practice


Verifying availability of port 8888 ...met
Verifying Network parameter - ipqmaxlen ...met
Verifying Network parameter - rfc1323 ...met
Verifying Network parameter - sb_max ...met
Verifying Network parameter - tcp_sendspace ...met
Verifying Network parameter - tcp_recvspace ...met
Verifying Network parameter - udp_sendspace ...met
Verifying Network parameter - udp_recvspace ...met


Verifying Clusterware Best Practice

Verifying CSS misscount parameter ...met
Verifying CSS reboottime parameter ...met
Verifying CSS disktimeout parameter ...met
Verifying Ethernet Jumbo Frames ...met

 

******************************************************************************************
        Summary of environment
******************************************************************************************

Date (mm/dd/yyyy)    :  04/14/2014                                       
Time (hh:mm:ss)      :  11:53:58                                         
Cluster name         :  scan-dwdoudou                                        
Clusterware version  :  11.2.0.4.0                                       
Grid home            :  /oracle/rac/11.2                                 
Grid User            :  grid                                             
Operating system     :  AIX6.1                                           

******************************************************************************************
System recommendations
******************************************************************************************

Verification Check        :  Network parameter - udp_recvspace                           
Verification Description  :  Checks if the network parameter is set correctly on the     
                             system                                                      
Verification Result       :  MET                                                         
Verification Summary      :  Check for Network parameter - udp_recvspace passed          

Node                Status    Expected Value                Actual Value                 
------------------------------------------------------------------------------------------

dwdb1               PASSED    655360                        en9=655360                   
dwdb2               PASSED    655360                        en9=655360                   

__________________________________________________________________________________________

Verification Check        :  Network parameter - udp_sendspace                           
Verification Description  :  Checks if the network parameter is set correctly on the     
                             system                                                      
Verification Result       :  MET                                                         
Verification Summary      :  Check for Network parameter - udp_sendspace passed          

Node                Status    Expected Value                Actual Value                 
------------------------------------------------------------------------------------------

dwdb1               PASSED    65536                         en9=65536                    
dwdb2               PASSED    65536                         en9=65536                    

__________________________________________________________________________________________

Verification Check        :  Network parameter - tcp_recvspace                           
Verification Description  :  Checks if the network parameter is set correctly on the     
                             system                                                      
Verification Result       :  MET                                                         
Verification Summary      :  Check for Network parameter - tcp_recvspace passed          

Node                Status    Expected Value                Actual Value                 
------------------------------------------------------------------------------------------

dwdb1               PASSED    65536                         en9=65536                    
dwdb2               PASSED    65536                         en9=65536                    

__________________________________________________________________________________________

Verification Check        :  Network parameter - tcp_sendspace                           
Verification Description  :  Checks if the network parameter is set correctly on the     
                             system                                                      
Verification Result       :  MET                                                         
Verification Summary      :  Check for Network parameter - tcp_sendspace passed          

Node                Status    Expected Value                Actual Value                 
------------------------------------------------------------------------------------------

dwdb1               PASSED    65536                         en9=131072                   
dwdb2               PASSED    65536                         en9=131072                   

__________________________________________________________________________________________

Verification Check        :  Network parameter - sb_max                                  
Verification Description  :  Checks if the network parameter is set correctly on the     
                             system                                                      
Verification Result       :  MET                                                         
Verification Summary      :  Check for Network parameter - sb_max passed                 

Node                Status    Expected Value                Actual Value                 
------------------------------------------------------------------------------------------

dwdb1               PASSED    4194304                       en9=4194304                  
dwdb2               PASSED    4194304                       en9=4194304                  

__________________________________________________________________________________________

Verification Check        :  Network parameter - rfc1323                                 
Verification Description  :  Checks if the network parameter is set correctly on the     
                             system                                                      
Verification Result       :  MET                                                         
Verification Summary      :  Check for Network parameter - rfc1323 passed                

Node                Status    Expected Value                Actual Value                 
------------------------------------------------------------------------------------------

dwdb1               PASSED    1                             en9=1                        
dwdb2               PASSED    1                             en9=1                        

__________________________________________________________________________________________

Verification Check        :  Network parameter - ipqmaxlen                               
Verification Description  :  Checks if the network parameter is set correctly on the     
                             system                                                      
Verification Result       :  MET                                                         
Verification Summary      :  Check for Network parameter - ipqmaxlen passed              

Node                Status    Expected Value                Actual Value                 
------------------------------------------------------------------------------------------

dwdb1               PASSED    512                           en9=512                      
dwdb2               PASSED    512                           en9=512                      

__________________________________________________________________________________________

Verification Check        :  availability of port 8888                                   
Verification Description  :  availability of port 8888                                   
Verification Result       :  MET                                                         
Verification Summary      :  Check for availability of port 8888 passed                  

Node                Status    Expected Value                Actual Value                 
------------------------------------------------------------------------------------------

dwdb1               PASSED    true                          true                         
dwdb2               PASSED    true                          true                         

__________________________________________________________________________________________


******************************************************************************************
Clusterware recommendations
******************************************************************************************

Verification Check        :  Ethernet Jumbo Frames                                       
Verification Description  :  Checks if Jumbo Frames are configured on the system         
Verification Result       :  MET                                                         
Verification Summary      :  Check for Ethernet Jumbo Frames passed                      
Additional Details        :  A performance improvement can be seen with Jumbo Frames,    
                             check with your system and network administrator first and  
                             if possible, configure Jumbo Frames on interconnect. See    
                             reference for more detail specific to platform.             
References (URLs/Notes)   :  http://docs.hp.com/en/AB290-90001/ch01s11.html?jumpid=reg_R 
                             1002_USEN 
                             http://www.sun.com/products/networking/ethernet/jumbo/ 
                             http://kbserver.netgear.com/kb_web_files/n101539.asp 
                             http://www.cisco.com/en/US/products/hw/switches/ps700/produ 
                             cts_configuration_example09186a008010edab.shtml 
                             http://www.juniper.net/company/presscenter/pr/2005/pr-05081 
                             5.html 
                             http://darkwing.uoregon.edu/~joe/jumbo-clean-gear.html 
                             http://www.dell.com/content/products/productdetails.aspx/pw 
                             cnt_2724?c=us&cs=04&l=en&s=bsd 
                             http://www.intel.com/support/network/adapter/index.htm      

Node                Status    Expected Value                Actual Value                 
------------------------------------------------------------------------------------------

dwdb1               PASSED    1500                          1500                         
dwdb2               PASSED    1500                          1500                         

__________________________________________________________________________________________

Verification Check        :  CSS disktimeout parameter                                   
Verification Description  :  Checks if the CSS disktimeout is set correctly on the       
                             system                                                      
Verification Result       :  MET                                                         
Verification Summary      :  Check for CSS disktimeout parameter passed                  
Additional Details        :  The maximum amount of time allowed for a voting file I/O    
                             to complete; if this time is exceeded the voting disk will  
                             be marked as offline.  Note that this is also the amount    
                             of time that will be required for initial cluster           
                             formation, i.e. when no nodes have previously been up and   
                             in a cluster.                                               
References (URLs/Notes)   :  https://support.oracle.com/CSP/main/article?cmd=show&type=N 
                             OT&id=294430.1                                              

Node                Status    Expected Value                Actual Value                 
------------------------------------------------------------------------------------------

dwdb1               PASSED    200                           200                          
dwdb2               PASSED    200                           200                          

__________________________________________________________________________________________

Verification Check        :  CSS reboottime parameter                                    
Verification Description  :  Checks if the CSS reboottime is set correctly on the system 
Verification Result       :  MET                                                         
Verification Summary      :  Check for CSS reboottime parameter passed                   
Additional Details        :  reboottime (default 3 seconds) is the amount of time        
                             allowed for a node to complete a reboot after the CSS       
                             daemon has been evicted.                                    
References (URLs/Notes)   :  https://support.oracle.com/CSP/main/article?cmd=show&type=N 
                             OT&id=294430.1                                              

Node                Status    Expected Value                Actual Value                 
------------------------------------------------------------------------------------------

dwdb1               PASSED    3                             3                            
dwdb2               PASSED    3                             3                            

__________________________________________________________________________________________

Verification Check        :  CSS misscount parameter                                     
Verification Description  :  Checks if the CSS misscount is set correctly on the system  
Verification Result       :  MET                                                         
Verification Summary      :  Check for CSS misscount parameter passed                    
Additional Details        :  The CSS misscount parameter represents the maximum time,    
                             in seconds, that a network heartbeat can be missed before   
                             entering into a cluster reconfiguration to evict the node   
References (URLs/Notes)   :  https://support.oracle.com/CSP/main/article?cmd=show&type=N 
                             OT&id=294430.1                                              

Node                Status    Expected Value                Actual Value                 
------------------------------------------------------------------------------------------

dwdb1               PASSED    30                            30                           
dwdb2               PASSED    30                            30                           

_________________________________________________________________________________________

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

请登录后发表评论 登录
全部评论
10年老鸟,Oracle,Mysql,EMC 存储,NBU备份

注册时间:2012-02-03

  • 博文量
    268
  • 访问量
    1313757