###主机检查####
#!/bin/bash
echo ''
banner `hostname`
echo '主机名(hostname)'
hostname
echo ''
echo '登陆信息'
who am i
echo ''
echo '收集时间(date)'
date +"%Y年%m月%d日 %H:%M:%S 星期%w"
echo ''
echo '系统内核信息(uname -a)'
uname -a
echo ''
echo '系统版本(cat /etc/redhat-release)'
cat /etc/redhat-release
echo ''
echo '系统运行时间(uptime)'
uptime
echo ''
echo 'CPU使用情况(sar 2 5)'
sar 2 5
echo ''
echo '内存使用情况(vmstat 2 5/free -h)'
vmstat 2 5
free -h
echo ''
echo 'hosts信息(cat /etc/hosts)'
cat /etc/hosts
echo ''
echo '内存信息 (cat /proc/meminfo)'
cat /proc/meminfo
echo ''
echo 'cpu信息(cat /proc/cpuinfo)'
cat /proc/cpuinfo
echo ''
echo '系统错误日志(grep -i "error" /var/log/messages)'
grep -Ei 'error|fail' /var/log/messages
echo ''
echo '文件系统使用率(df -h)'
df -h
echo ''
echo 'HA状态检查(hastatus -sum)'
hastatus -sum
echo ''
echo 'dg状态检查(vxdg list)'
vxdg list
echo ''
echo 'disk状态检查(vxdisk list)'
vxdisk list
echo ''
echo '心跳状态检查(lltconfig -a list,gabconfig -a)'
lltconfig -a list
gabconfig -a
echo ''
echo '查看服务器型号(dmidecode | grep 'Product Name')'
dmidecode | grep 'Product Name'
echo ''
echo '查看主板的序列号:(dmidecode |grep 'Serial Number')'
dmidecode |grep 'Serial Number'
echo ''
echo '查看系统序列号:(dmidecode -s system-serial-number)'
dmidecode -s system-serial-number
echo ''
echo '查看内存信息:(dmidecode -t memory)'
dmidecode -t memory
echo ''
echo '查看OEM信息:(dmidecode -t 11)'
dmidecode -t 11
echo ''
echo '查看数据库补丁:(opatch lsinventory/lspatches)'
su - oracle -c '$ORACLE_HOME/OPatch/opatch lsinventory -oh $ORACLE_HOME'
su - oracle -c '$ORACLE_HOME/OPatch/opatch lspatches'
echo '以上为数据库补丁信息'
echo ''
echo '查看RAC补丁:(opatch lsinventory/lspatches)'
su - grid -c '$ORACLE_HOME/OPatch/opatch lsinventory -oh $ORACLE_HOME'
su - grid -c '$ORACLE_HOME/OPatch/opatch lspatches'
echo '以上为RAC补丁信息'
echo ''
echo '查看RAC状态:(crsctl stat res -t;ocrcheck;crsctl query css votedisk)'
su - grid -c 'crsctl stat res -t'
su - grid -c 'ocrcheck'
su - grid -c 'crsctl query css votedisk'
echo '以上集群状态信息'
echo ''
echo '查看数据库监听状态:(lsnrctl status)'
su - oracle -c "lsnrctl status"
su - grid -c "lsnrctl status"
echo ''
echo '查看crs日志:(tail -500 alert*)'
su - grid -c 'tail -500 $ORACLE_BASE/diag/crs/`hostname`/crs/trace/alert*'
su - grid -c 'tail -100 $ORACLE_HOME/log/`hostname`/alert*'
echo '以上为crs告警日志'
echo ''
echo '查看asm日志:(tail -500 alert*)'
su - grid -c 'tail -500 $ORACLE_BASE/diag/asm/+asm/$ORACLE_SID/trace/alert*'
echo '以上为ASM告警日志'
echo ''
echo '查看db告警日志:(tail -5000 alert*)'
su - oracle -c 'tail -5000 $ORACLE_BASE/diag/rdbms/$ORACLE_UNQNAME/$ORACLE_SID/trace/alert*'
echo '以上为db告警日志'
echo ''
echo 'cat /etc/sysctl.conf'
cat /etc/sysctl.conf
echo ''
echo 'cat /etc/security/limits.conf'
cat /etc/security/limits.conf
echo ''
echo 'cat ~/.bash_profile'
su - oracle -c 'cat ~/.bash_profile'
echo ''
echo '检查完成!!!'