#!/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/grid/scripts/check/bin Log_Path=/home/grid/scripts/check/log
echo "You are logged in as `whoami`";
if [ `whoami` != grid ]; then
echo "Must be logged on as grid 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=/u01/app/oracle
export ORACLE_HOME=/u01/11.2.0/grid
export ORACLE_SID=+ASM1
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
CHECK_REPORT_PATH=/home/grid/scripts/check/log
CHECK_DATE=`date +%F`
echo "Running script. at `date`" > $CHECK_REPORT_PATH/Report_server_and_alert_$CHECK_DATE.out
cd /u01/11.2.0/grid/log/testrac1/
echo ' #################### Check Start #################### ' >> $CHECK_REPORT_PATH/Report_server_and_alert_$CHECK_DATE.out
echo ' 1.Background process===============================' >> $CHECK_REPORT_PATH/Report_server_and_alert_$CHECK_DATE.out
ps -ef|grep /u01 >> $CHECK_REPORT_PATH/Report_server_and_alert_$CHECK_DATE.out
echo ' 2.crontab info=====================================' >> $CHECK_REPORT_PATH/Report_server_and_alert_$CHECK_DATE.out
crontab -l >> $CHECK_REPORT_PATH/Report_server_and_alert_$CHECK_DATE.out
echo ' 3.Alert Log CRS- Warning===========================' >> $CHECK_REPORT_PATH/Report_server_and_alert_$CHECK_DATE.out
tail -2000 alert$ORACLE_HOSTNAME.log | grep CRS- >> $CHECK_REPORT_PATH/Report_server_and_alert_$CHECK_DATE.out
sleep 2;
echo ' 4.Alert Log tail 1000=============================' >> $CHECK_REPORT_PATH/Report_server_and_alert_$CHECK_DATE.out
tail -1000 alert$ORACLE_HOSTNAME.log >> $CHECK_REPORT_PATH/Report_server_and_alert_$CHECK_DATE.out
echo ' 5.machine i nformation==============================' >> $CHECK_REPORT_PATH/Report_server_and_alert_$CHECK_DATE.out
echo " 5.1----------------host name-----------------------" >> $CHECK_REPORT_PATH/Report_server_and_alert_$CHECK_DATE.out
hostname >> $CHECK_REPORT_PATH/Report_server_and_alert_$CHECK_DATE.out
echo "" >> $CHECK_REPORT_PATH/Report_server_and_alert_$CHECK_DATE.out
echo " 5.2----------------id------------------------------" >> $CHECK_REPORT_PATH/Report_server_and_alert_$CHECK_DATE.out
id >> $CHECK_REPORT_PATH/Report_server_and_alert_$CHECK_DATE.out
echo "" >> $CHECK_REPORT_PATH/Report_server_and_alert_$CHECK_DATE.out
echo "#################### Check End! ####################" >> $CHECK_REPORT_PATH/Report_server_and_alert_$CHECK_DATE.out
#
# 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/grid/scripts/check/bin Log_Path=/home/grid/scripts/check/log
echo "You are logged in as `whoami`";
if [ `whoami` != grid ]; then
echo "Must be logged on as grid 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=/u01/app/oracle
export ORACLE_HOME=/u01/11.2.0/grid
export ORACLE_SID=+ASM1
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
CHECK_REPORT_PATH=/home/grid/scripts/check/log
CHECK_DATE=`date +%F`
echo "Running script. at `date`" > $CHECK_REPORT_PATH/Report_server_and_alert_$CHECK_DATE.out
cd /u01/11.2.0/grid/log/testrac1/
echo ' #################### Check Start #################### ' >> $CHECK_REPORT_PATH/Report_server_and_alert_$CHECK_DATE.out
echo ' 1.Background process===============================' >> $CHECK_REPORT_PATH/Report_server_and_alert_$CHECK_DATE.out
ps -ef|grep /u01 >> $CHECK_REPORT_PATH/Report_server_and_alert_$CHECK_DATE.out
echo ' 2.crontab info=====================================' >> $CHECK_REPORT_PATH/Report_server_and_alert_$CHECK_DATE.out
crontab -l >> $CHECK_REPORT_PATH/Report_server_and_alert_$CHECK_DATE.out
echo ' 3.Alert Log CRS- Warning===========================' >> $CHECK_REPORT_PATH/Report_server_and_alert_$CHECK_DATE.out
tail -2000 alert$ORACLE_HOSTNAME.log | grep CRS- >> $CHECK_REPORT_PATH/Report_server_and_alert_$CHECK_DATE.out
sleep 2;
echo ' 4.Alert Log tail 1000=============================' >> $CHECK_REPORT_PATH/Report_server_and_alert_$CHECK_DATE.out
tail -1000 alert$ORACLE_HOSTNAME.log >> $CHECK_REPORT_PATH/Report_server_and_alert_$CHECK_DATE.out
echo ' 5.machine i nformation==============================' >> $CHECK_REPORT_PATH/Report_server_and_alert_$CHECK_DATE.out
echo " 5.1----------------host name-----------------------" >> $CHECK_REPORT_PATH/Report_server_and_alert_$CHECK_DATE.out
hostname >> $CHECK_REPORT_PATH/Report_server_and_alert_$CHECK_DATE.out
echo "" >> $CHECK_REPORT_PATH/Report_server_and_alert_$CHECK_DATE.out
echo " 5.2----------------id------------------------------" >> $CHECK_REPORT_PATH/Report_server_and_alert_$CHECK_DATE.out
id >> $CHECK_REPORT_PATH/Report_server_and_alert_$CHECK_DATE.out
echo "" >> $CHECK_REPORT_PATH/Report_server_and_alert_$CHECK_DATE.out
echo "#################### Check End! ####################" >> $CHECK_REPORT_PATH/Report_server_and_alert_$CHECK_DATE.out