Report_server_and_alert_oracle.sh

#!/bin/bash 
# 
#    NAME 
#      Report_Server polling.sh   2016-12-30
# 
#    DESCRIPTION 
#      Collecting Server info and alert log   
# 
#    NOTES 
#      sh Report_server_and_alert.sh 
# 
#    MODIFIED       (yyyy-mm-dd) 
#    liyanming       2016-12-30 
#    Scripts_PATH =/home/oracle/scripts/check/bin  Log_Path=/home/oracle/scripts/check/log
echo "You are logged in as `whoami`";
if [ `whoami` != oracle ]; then  
echo "Must be logged on as oracle to run this script." 
exit
fi
export AIXTHREAD_SCOPE=S #(S for system-wide thread scope)
export TMPDIR=/tmp
umask 022
export ORACLE_HOSTNAME=testrac1
export ORACLE_UNQNAME=dw
export ORACLE_BASE=/u02
export ORACLE_HOME=/u02/app/oracle
export ORACLE_SID=dw1
export ORACLE_TERM=xterm
export PATH=$ORACLE_HOME/bin:/usr/sbin:/usr/kerberos/bin:/usr/local/bin:/bin:/usr/bin:/home/grid/bin:$PATH
export LD_LIBRARY_PATH=$ORACLE_HOME/lib:/lib:/usr/lib
export CLASSPATH=$ORACLE_HOME/JRE:$ORACLE_HOME/jlib:$ORACLE_HOME/rdbms/jlib
export DISPLAY=10.1.110.130:0.0
JAVA_HOME=/usr/local/java1.8
export CLASSPATH=.:$JAVA_HOME/lib:$JAVA_HOME/jre/lib
export PATH=$JAVA_HOME/bin:$JAVA_HOME/jre/bin:$PATH
CHECK_REPORT_PATH=/home/oracle/scripts/check/log
CHECK_DATE=`date +%F`  
echo "Running script. at `date`"  >$CHECK_REPORT_PATH/Report_server_and_alert_oracle_$CHECK_DATE.out


cd /u02/diag/rdbms/dw/dw1/trace/


echo ' #################### Check Start #################### ' >>$CHECK_REPORT_PATH/Report_server_and_alert_oracle_$CHECK_DATE.out


echo ' 1.Background process===============================' >>$CHECK_REPORT_PATH/Report_server_and_alert_oracle_$CHECK_DATE.out
ps -ef|grep $ORACLE_SID  >>$CHECK_REPORT_PATH/Report_server_and_alert_oracle_$CHECK_DATE.out


echo ' 2.crontab info=====================================' >>$CHECK_REPORT_PATH/Report_server_and_alert_oracle_$CHECK_DATE.out
crontab -l >>$CHECK_REPORT_PATH/Report_server_and_alert_oracle_$CHECK_DATE.out
 
echo ' 3.Alert Log ORA- Warning===========================' >>$CHECK_REPORT_PATH/Report_server_and_alert_oracle_$CHECK_DATE.out
tail -2000 alert_$ORACLE_SID.log | grep ORA-  >>$CHECK_REPORT_PATH/Report_server_and_alert_oracle_$CHECK_DATE.out
sleep 2; 
 
echo ' 4.Alert Log  tail 1000=============================' >>$CHECK_REPORT_PATH/Report_server_and_alert_oracle_$CHECK_DATE.out
tail -500 alert_$ORACLE_SID.log  >>$CHECK_REPORT_PATH/Report_server_and_alert_oracle_$CHECK_DATE.out
 
echo ' 5.machine information==============================' >>$CHECK_REPORT_PATH/Report_server_and_alert_oracle_$CHECK_DATE.out


echo " 5.1----------------host name-----------------------" >>$CHECK_REPORT_PATH/Report_server_and_alert_oracle_$CHECK_DATE.out
hostname  >>$CHECK_REPORT_PATH/Report_server_and_alert_oracle_$CHECK_DATE.out
echo "" >>$CHECK_REPORT_PATH/Report_server_and_alert_oracle_$CHECK_DATE.out


echo " 5.2----------------id------------------------------" >>$CHECK_REPORT_PATH/Report_server_and_alert_oracle_$CHECK_DATE.out
id  >>$CHECK_REPORT_PATH/Report_server_and_alert_oracle_$CHECK_DATE.out
echo "" >>$CHECK_REPORT_PATH/Report_server_and_alert_oracle_$CHECK_DATE.out


echo " 5.3----Current uptime,users and load averages -----" >>$CHECK_REPORT_PATH/Report_server_and_alert_oracle_$CHECK_DATE.out
uptime >>$CHECK_REPORT_PATH/Report_server_and_alert_oracle_$CHECK_DATE.out
echo "" >>$CHECK_REPORT_PATH/Report_server_and_alert_oracle_$CHECK_DATE.out


echo " 5.4----------------CPU number----------------------" >>$CHECK_REPORT_PATH/Report_server_and_alert_oracle_$CHECK_DATE.out
prtconf| grep Processors >>$CHECK_REPORT_PATH/Report_server_and_alert_oracle_$CHECK_DATE.out
sleep 1;
echo "" >>$CHECK_REPORT_PATH/Report_server_and_alert_oracle_$CHECK_DATE.out


echo " 5.5----------------memory info---------------------" >>$CHECK_REPORT_PATH/Report_server_and_alert_oracle_$CHECK_DATE.out
prtconf | grep Memory >>$CHECK_REPORT_PATH/Report_server_and_alert_oracle_$CHECK_DATE.out
sleep 1; 
echo "" >>$CHECK_REPORT_PATH/Report_server_and_alert_oracle_$CHECK_DATE.out


echo " 5.6----------------disk info-----------------------" >>$CHECK_REPORT_PATH/Report_server_and_alert_oracle_$CHECK_DATE.out
df -g >>$CHECK_REPORT_PATH/Report_server_and_alert_oracle_$CHECK_DATE.out
sleep 1; 
echo "" >>$CHECK_REPORT_PATH/Report_server_and_alert_oracle_$CHECK_DATE.out


echo " 5.7----------------kernel parameter----------------" >>$CHECK_REPORT_PATH/Report_server_and_alert_oracle_$CHECK_DATE.out
lsattr -El sys0 >>$CHECK_REPORT_PATH/Report_server_and_alert_oracle_$CHECK_DATE.out
sleep 1; 
echo "" >>$CHECK_REPORT_PATH/Report_server_and_alert_oracle_$CHECK_DATE.out


echo " 5.8----------------os lever------------------------" >>$CHECK_REPORT_PATH/Report_server_and_alert_oracle_$CHECK_DATE.out
oslevel >>$CHECK_REPORT_PATH/Report_server_and_alert_oracle_$CHECK_DATE.out
sleep 1; 
echo "" >>$CHECK_REPORT_PATH/Report_server_and_alert_oracle_$CHECK_DATE.out


echo " 5.9----------------CPU memory usage----------------" >>$CHECK_REPORT_PATH/Report_server_and_alert_oracle_$CHECK_DATE.out
vmstat 5 5 >>$CHECK_REPORT_PATH/Report_server_and_alert_oracle_$CHECK_DATE.out
sleep 1; 
echo "" >>$CHECK_REPORT_PATH/Report_server_and_alert_oracle_$CHECK_DATE.out


echo " 5.10----------------Io check------------------------" >>$CHECK_REPORT_PATH/Report_server_and_alert_oracle_$CHECK_DATE.out
iostat >>$CHECK_REPORT_PATH/Report_server_and_alert_oracle_$CHECK_DATE.out


echo "#################### Check End! ####################" >>$CHECK_REPORT_PATH/Report_server_and_alert_oracle_$CHECK_DATE.out