转自 http://www.askmaclean.com/archives/script-collect-rac-diag.html
以下脚本可以用于汇总RAC诊断信息, 并非每一个输出或者每一个日志都要阅读,在问题诊断时可以有针对性地查看, 如果是远程协助的会,可以让用户收集完打包 ,这样省去多次交互的时间:
- Cluster 启动状态
- hostname
- uptime
- vmstat iostat nmon OS stats
- /etc/sysctl.conf /etc/system vmo -a no -a
- /etc/inittab
- /etc/init.d/init.crs
- /etc/init.d/init.crsd
- /etc/init.d/init.cssd
- /etc/init.d/init.evmd
- olsnodes
- crsctl check css
- crsctl check crs status
- crsctl check crsd status
- crsctl check cssd status
- crsctl check evmd status
- crsctl query css votedisk
- crsctl get css priority
- crsctl get css diagwait
- crsctl get css disktimeout
- crsctl get css misscount
- crsctl get css reboottime
- crsctl query crs softwareversion
- crsctl query crs activeversion
- opatch lsinventory -detail
- /var/opt/oracle/ocr.loc 或 /etc/oracle/ocr.loc
- cluvfy comp sys -n <hostname> -p crs -verbose
- cluvfy comp sys -n <hostname> -p databaase -verbose
- cluvfy stage -post crsinst -n <hostname> -verbose
- cluvfy comp software -verbose -n all
- Clusterware 版本
- $ORA_CRS_HOME 已安装产品的信息
- $ORA_CRS_HOME 已应用补丁的信息
- crs_stat -u
- crs_stat -p
- $ORA_CRS_HOME/log/<hostname>/alert<hostname>.log
- $ORA_CRS_HOME/crs/log/*.log
- $ORA_CRS_HOME/log/<hostname>/crsd/*
- $ORA_CRS_HOME/css/log/*.log
- $ORA_CRS_HOME/css/init/*.log
- $ORA_CRS_HOME/log/<hostname>/cssd/*
- $ORA_CRS_HOME/racg/dump/*
- $ORACLE_HOME/racg/dump/*
- $ORA_CRS_HOME/log/<hostname>/racg/*
- $ORACLE_HOME/log/<hostname>/racg/*
- $ORA_CRS_HOME/evm/log/*.log
- $ORA_CRS_HOME/evm/init/*.log
- $ORA_CRS_HOME/log/<hostname>/evmd/*
- $ORA_CRS_HOME/log/<hostname>/client/*
- $ORACLE_HOME/log/<hostname>/client/*
- $ORA_CRS_HOME/log/<hostname>/ohasd/ohasd.log
- $ORA_CRS_HOME/log/<hostname>/gpnpd/gpnpd.log
- /etc/oracle/oprocd/*oprocd.log 或 /var/opt/oracle/oprocd/*oprocd.log
- /etc/oracle/lastgasp/*.lgl 或 /var/opt/oracle/lastgasp/*.lgl
- debug resource
# cd $ORA_CRS_HOME/bin
# crsctl debug log res <resname:level>
# crsctl debug log res <vip resourfce name>:5
- ocrdump
- ocrcheck
- ocrconfig -showbackup
- /var/opt/oracle/srvConfig.loc 或 /etc/srvConfig.loc
- srvctl config nodeapps -n <hostname> -a -l -g -s
- srvctl config
- srvctl config database -d <dbname> -a
- srvctl config scan_listener
- srvctl status scan_listener
- srvctl config scan
- srvctl status scan
- srvctl config srvpool
- srvctl status srvpool -a
- srvctl config listener
- srvctl status listener
- srvctl config listener -n <hostname>
- oifcfg iflist
- oifcfg getif
- interconnect 信息 x$skgxpia or oradebug ipc
- IPC 信息
- messages 或 syslog OS日志
IBM: /bin/errpt -a > messages.out
Linux: /var/log/messages
Solaris: /var/adm/messages
- netstat -rn
- ifconfig -a
- cat /etc/hosts
- netstat -s