实战:oracle巡检脚本v1(二)
| grep -A 16 "Memory Device$" |grep Size:|grep -v "No Module Installed"|awk '{print "*" $2,$3}'|uniq -c` #物理内存数量
sysver=`cat /etc/issue | head -1` #--系统版本
kerver=`/bin/uname -a |awk '{print $3}'` #内核版本
#mem usage
mem_total=$(/usr/bin/free -m |grep Mem|awk '{print $2}')
mem_used=$(/usr/bin/free -m |grep Mem|awk '{print $3}')
mem_rate=`expr $mem_used/$mem_total*100|bc -l`
#mem_summary
mem_sum=`/usr/bin/free -m | xargs | awk '{print "Free/total memory: " $17 " / " $8 " MB"}' \
| awk -F":" 'BEGIN{print " FREE / TOTAL " } {print $2 }'`
#disk space
dk_usage=`/bin/df -h | xargs | awk '{print "Free/total disk: " $11 " / " $9}'`
cechon "1.1 server hostname is:" red
echo ${hostname}
cechon "1.2 server ipaddree is: " red
echo ${ipaddress}
if [ "${gtway01}" = "" ];then
cechon "1.3 server gateway is:" red
echo ${gtway02}
else
cechon "1.3 server gateway is:" red
echo ${gtway01}
fi
cechon "1.4 server cpuinfo is: " red
echo ${cpuinfo}
cechon "1.5 server Physical memory number is: " red
echo ${phmem}
cechon "1.6 server version is: " red
echo ${sysver}
cechon "1.7 server system kernel version is: " red
echo ${kerver}
cechon "1.8 server memory Summary is: " red
echo ${mem_sum}
cechon "1.9 server memory usage rate is: " red
echo ${mem_rate:0:5}%
cechon "1.10 server disk usage is: " red
echo
cechon "detail: " green
echo
#disk usage
df -H |awk -F '\t' '{ print $1,$2,$3,$4,$5,$6}'
echo
cechon "Summary: " green
echo
echo ${dk_usage}
echo
cechon "1.11 server CPU load average is: " red
echo
/usr/bin/uptime | awk 'BEGIN{print "1min, 5min, 15min"} {print $10,$11,$12}'
echo
cechon "1.12 server started services is: " red
echo
/sbin/chkconfig --list | grep on
echo
echo
cechon "1.13 server CPU free is: " red
/usr/bin/top -b -n 1 | grep Cpu | awk '{print $5}' | cut -f 1 -d "."
echo
cechon "1.14 server ESTABLISHED TCP connect number is: " red
echo
/bin/netstat -n | awk '/^tcp/ {++S[$NF]} END {for(a in S) print a, S[a]}'
echo
cechon "1.15 oracle ESTABLISHED connect is: " red
echo
/bin/netstat -an -t | grep ":1521" | grep ESTABLISHED | awk '{printf "%s %s\n",$5,$6}' | sort |sed 's/^::ffff://'
echo
cechon "1.16 oracle runing processes is: " red
echo
/bin/ps -ef|grep ora_|grep -v grep&&ps -ef|grep ora_|grep -v grep|wc -l
echo
cechon "1.17 oracle LISTENER status is: " red
echo
/bin/ps -ef|grep lsn|grep -v grep
echo
lsnrctl status
echo
echo
echo "***********************************************************************"
echo
cechon "***********************************************************************" yellow
echo
cechon "2.Check the database basic situation:" green
echo
cechon "***********************************************************************" yellow
echo
#configure oracle user and password
ora_user="sys"
ora_pass="jinriDBAocpyang_jinri_ocp.com"
#2.1 oracle database version
echo
sqlplus -S "${ora_user}/${ora_pass} as sysdba" <
/dev/null #禁止sqlplus执行结果回显
set heading off;
set feedback off;
set termout off;
set pagesize 0;
set verify off;
set echo off;
spool 1.txt
select * from v\$version;
spool off
exit;
!01
cechon "2.1 oracle database version is : " red
echo
cat 1.txt
echo
rm -rf 1.txt
#2.2 oracle database information
sqlplus -S "${ora_user}/${ora_pass} as sysdba" </dev/null #禁止sqlplu