• Script:Collect vip resource Diagnostic Information


    以下脚本可以用于收集 Oracle RAC中vip 资源或其他CRS resource的诊断信息:  
    action plan:
    
    ./runcluvfy.sh stage -post crsinst -n all  -verbose
    
    ./runcluvfy.sh stage -pre crsinst -n all  -verbose
    
    or
    
    
    cluvfy stage -post crsinst -n all -verbose
    
    cluvfy stage -pre  crsinst -n all -verbose
    
    1. Please upload the following logs of all two nodes:
    $CRS_HOME/log/<nodename>/*.log
    $CRS_HOME/log/<nodename>/crsd/*.log
    $CRS_HOME/log/<nodename>/cssd/*.log
    $CRS_HOME/log/<nodename>/racg/*.log
    $CRS_HOME/log/<nodename>/client/*.log
    $CRS_HOME/log/<nodename>/evmd/*.log
    
    /etc/oracle/oprocd/*.log.* or /var/opt/oracle/oprocd/*.log.* (If have)
    
    $crs_stat –t
    $crsctl check crs
    $crsctl check boot
    
    2. 
    
    Please consult your sysadmin and make sure that the gateway is pingable all the time 
    
    1- test the gw on every node
    consult your sysadmin to create a crontab unix shell script to ping the
    gateway of your public interface every 2 seconds for example and the result is to be
    spooled in /tmp/test_gw_<nodename>.log
    
    ping your gateway  and upload the ping log 
    
    2- increase the tracing level of the vip resource  
      as root user
      # cd $ORA_CRS_HOME/bin
      # crsctl debug log res <resname:level>
      # crsctl debug log res <vip resourfce name>:5
    
    3- restart the clusterware
    
    3- execute this test on both nodes at the same time
       $ script /tmp/testvip_<nodename>.log
       $ cd $ORA_CRS_HOME/bin
       $ hostname
       $ date
       $ cat /etc/hosts
       $ ifconfig -a
       $ oifcfg getif  
       $ netstat -rn
    
       $ oifcfg iflist
       $ srvctl config nodeapps -n <nodename> -a -g -s -l               (repeate it for all nodes)
    
       $ crs_stat –t
       $ exit
    
    4- reset the tracing level of the vip resource  
      as root user
      # cd $ORA_CRS_HOME/bin
      # crsctl debug log res <resname:level>
      # crsctl debug log res <vip resourfce name>:1
    
    Up on the next occurence, please upload the following information from all nodes
    
      a-  /tmp/test_gw_<nodename>.log
      b- /tmp/testvip_<nodename>.log
      c- the crsd log
      d. The resource racg
         $ORA_CRS_HOME/log/<nodename>/racg/vip*
    
      e. the racgvip script from
         $ORA_CRS_HOME/bin/racgvip
      f- RDA from all the nodes
        Note 314422.1 Remote Diagnostic Agent (RDA) 4.0 – Overview
    
       g- the o/s message file
          IBM: /bin/errpt -a > messages.out
          Linux: /var/log/messages
          Solaris: /var/adm/messages
    
    3. CRS Diagnostics
    
    note 330358.1 -- CRS Diagnostic Collection Guide, please use (all .gz files especially crsData_$HOST.tar.gz
    need to be uploaded)
    
    diagcollection.pl --collect 
    
    Please make sure to include *ALL* requested files (missing any will delay or prevendting from
    identifying root cause) from *ALL* nodes in a single zip and upload.
    
    Note 330358.1 - CRS 10gR2/ 11gR1/ 11gR2 Diagnostic Collection Guide       
    Note 298895.1 - Modifying the default gateway address used by the Oracle 10g VIP
    Note 399213.1 - VIP Going Offline Intermittantly - Slow Response from Default Gateway
    Note 401783.1 - Changes in Oracle Clusterware after applying 10.2.0.3 Patchset
  • 相关阅读:
    elk+redis
    elk7.4+filebeat收集日志
    k8s-高可用集群实现(keepalived+haproxy)
    k8s-高可用集群实现(keepalived)
    keepalived(双主模式)+haproxy+mysql_slave
    haproxy-实现mysql多slave读负载均衡
    MySQL数据库的配置
    前端模块化(AMD和CMD、CommonJs)
    一分钟配置jdk
    MySQL基础语法
  • 原文地址:https://www.cnblogs.com/macleanoracle/p/2968176.html
Copyright © 2020-2023  润新知